Sr. Data Engineer

Overview

Location: Mumbai (Onsite)

Work Mode: Onsite

Experience: 5 years+

Salary : 14 LPA

Job Summary:

We are looking for a highly skilled Synapse Analytics Developer with over 5 years of experience in designing and developing analytical solutions on Azure Cloud. The ideal candidate will have hands-on expertise in Azure Synapse, ETL pipeline development, and data warehouse modeling, working closely with PySpark developers to deliver scalable data solutions.

Must-Have Skills & Responsibilities:

• 5+ years of experience in designing and developing analytical solutions using Azure Synapse Analytics and related Azure Data Services.
• Strong expertise in Dimensional Modeling and implementing Medallion Architecture.
• Design overall Azure data architecture utilizing Synapse components including:
• Serverless SQL Pool
• Dedicated SQL Pool (formerly SQL DW)
• Spark Pools
• Design and implement schemas for Dedicated SQL Pool.
• Define and build ETL pipelines in collaboration with PySpark developers.
• Create and manage Fact and Dimension Tables for data warehouse models.
• Build Azure Data Factory orchestration pipelines to execute PySpark notebooks.
• Ingest data from various sources, including:
• SAP ECC
• SAP BW
• IBM FileNet
• SQL Server and other RDBMS
• Write, debug, and optimize T-SQL queries and stored procedures.
• Monitor query performance, resource consumption, and job execution metrics.

Good to Have:

• Prior experience or knowledge of SAP Systems
• Relevant certifications like:
• AZ-900 (Microsoft Azure Fundamentals)
• DP-300 (Administering Relational Databases on Microsoft Azure)
• Exposure to Azure Data Lake, Databricks, Power BI (plus point)

Job Type: Full-time

Pay: ₹1,200,000.00 - ₹1,500,000.00 per year

Schedule:

• Day shift

Work Location: In person