Job at a glance
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 efficient 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 Strong 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 .