Azure Synapse Data Engineer

Job DescriptionWe 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 ResponsibilitiesDesign, 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 SkillsAzure Synapse AnalyticsAzure Data Factory (ADF)Synapse PipelinesADLS Gen2ETL/ELTStrong SQLSynapse Dedicated SQL PoolSQL query/execution plan optimizationPartitioning, indexing, and statisticsAzure data warehouse / data lake architecturePerformance tuning and troubleshootingIdeal CandidateA strong Azure Data Engineer with hands-on experience in Synapse + ADF + ADLS Gen2 + Advanced SQL + Dedicated SQL Pool performance tuning.