Job Description

We are looking for an experienced Azure Synapse Data Engineer with strong hands-on expertise in Azure data engineering, data warehousing, ETL/ELT, and SQL performance optimization.

Key Responsibilities

- Design, develop, and optimize solutions using Azure Synapse Analytics.
- Build and maintain data integration pipelines using Azure Data Factory (ADF) and Synapse Pipelines.
- Design and implement scalable Azure Data Lake Storage Gen2 (ADLS Gen2) architectures.
- Develop robust and high-performance ETL/ELT frameworks for enterprise data platforms.
- Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
- Identify and resolve performance bottlenecks across data movement and transformation processes.
- Ensure data quality, availability, reliability, and consistency across analytics platforms.
- Perform advanced SQL query analysis and optimization.
- Analyze execution plans and optimize complex analytical workloads.




- Configure and tune Synapse Dedicated SQL Pools.
- Design productive partitioning strategies for large datasets.
- Optimize indexing, statistics, and workload distribution to improve query performance.

Mandatory Skills

- Azure Synapse Analytics
- Azure Data Factory (ADF)
- Synapse Pipelines
- ADLS Gen2
- ETL/ELT
- Solid SQL
- Synapse Dedicated SQL Pool
- SQL query/execution plan optimization
- Partitioning, indexing, and statistics
- Azure data warehouse / data lake architecture
- Performance tuning and troubleshooting

Ideal Candidate

A strong Azure Data Engineer with hands-on experience in Synapse + ADF + ADLS Gen2 + Advanced SQL + Dedicated SQL Pool performance tuning.

Skills:- Microsoft Windows Azure, Apache Synapse, synapse, SQL Azure, PL/SQL and Microsoft SQL Server

📌 Azure Synapse Data Engineer (Pune)
🏢 Cymetrix Software
📍 Pune