Azure Synapse Data Engineer

Position: Data Engineer - Azure Synapse

Purpose of the Position: As an Azure Synapse Developer you will be responsible for designing, implementing, and managing scalable data pipelines.

InfoCepts is a global leader of end-to-end data and analytics solutions with nearly 20 years’ experience enabling customers to derive value from a variety of data-driven capabilities. Unique among its peers, InfoCepts operates with the scale of a global consulting firm, yet the expertise of a niche partner. At InfoCepts, you’ll be challenged to think innovatively, while growing your own personal and professional skills designed with the future in mind. We have more than 1200 global professionals working on cutting edge technology solutions with a single mission – transforming our customers' journey with data-driven modernization. • InfoCepts has been recognized as Gartner Peer Insights ™ Customers' Choice for two consecutive years in 2020 and 2021 which recognizes our best-in-class services that help our customers approach any data analytics problem. • We are certified by Great Place to Work®, India in 2021 and recognizes our high-trust and high performance work culture, and great employee experience in the industry. • Our award-winning reusable solutions approach is well recognized in the D&A industry and lets our Data Engineer -Azure Synapse Version 1.0 Client Logo Your title will go here, Use H1 as a header title from styles 23-01-2023 Proposal Ref No. I Version 1.0 Classification: Private Page 2 of 3 associates leverage our collective and proven consultative expertise, accelerate solution delivery through automation, enable faster time to value with reusable toolkits – all while delivering exceptional customer experience. Our success has been unique, and we are looking for professionals who are enthusiastic and passionate about data & analytics, delivering differentiated experiences, and solving real world problems for our global customers. This position works with the competency and delivery team to execute on the assigned responsibilities.

Location: Bangalore/Pune/Nagpur/ Chennai

Type of Employment: Full Time Regular

Key Result Areas and Activities:

• Design, develop and deploy ETL/ELT solutions on premise or in the cloud

• Transformation of data with stored procedures. Report Development (MicroStrategy/Power BI)

• Create and maintain comprehensive documentation for data pipelines, configurations, and processes

• Ensure data quality and integrity through effective data management practices

• Monitor and optimize data pipeline performance

• Troubleshoot and resolve data-related issues

Technical Experience:

Must Have

• Good experience in Azure Synapse

• Good experience in ADF

• Good experience in Snowflake & Stored Procedures

• Experience with ETL/ELT processes, data warehousing, and data modelling

• Experience with data quality frameworks, monitoring tools, and job scheduling

• Knowledge of data formats like JSON, XML, CSV, and Parquet

• English Fluent (Strong written, verbal, and presentation skills)

• Agile methodology & tools like JIRA

• Good communication and formal skills

Good To Have

• Good experience in MicroStrategy and PowerBI

• Experience in scripting languages such as Python, Java, or Shell scripting

• Familiarity with Azure cloud platforms and cloud data services and 4+ years of experience in Azure Synapse.

Qualities:

• Experience with or knowledge of Agile Software Development methodologies

• Can influence and implement change; demonstrates confidence, strength of conviction and sound decisions.

• Believes in head-on dealing with a problem; approaches in logical and systematic manner; is persistent and patient; can independently tackle the problem, is not over-critical of the factors that led to a problem and is practical about it; follow up with developers on related issues.

• Able to consult, write, and present persuasively.