Azure Synapse Engineer

Hoonartek · Pune

Source and collection record

Last observed by our collector: 8 October 2026 at 11:30 pm IST. This is not a manual review or a confirmation from the employer.

Employer requisition: ACE01628

Job type and experience labels are automated discovery categories. The employer determines eligibility. Original experience wording was not retained separately; check the current employer page.

How sourcing and classification work · Report a discrepancy

Your application evidence checklist

Mark the statements you can support after reading the employer source. This checklist stays on this page; it does not score your eligibility or submit an application.

Attendance and availability: I checked the employer page for work location, office attendance, start date and duration.Current requisition: I checked the current employer requisition and its application requirements.

0 of 2 checks marked. Keep unresolved requirements as questions for the employer.

Collected role description

We are seeking an experienced Azure Synapse Engineer to design, develop, optimize, and maintain enterprise-scale data warehouse and analytics solutions on Azure Synapse Analytics. The ideal candidate will have strong expertise in building high-performance ETL/ELT pipelines, implementing incremental data processing, optimizing Synapse dedicated SQL pools, and driving cost optimization initiatives through effective DWU right-sizing and workload management. Design, develop, and maintain scalable data ingestion and transformation pipelines using Azure Synapse Pipelines, Spark, SQL, and Azure Data Factory. Implement incremental data processing using watermarking, Change Data Capture (CDC), Change Tracking, or timestamp-based mechanisms. Develop and optimize Dedicated SQL Pool and Serverless SQL Pool solutions for large-scale data warehousing. Perform DWU right-sizing based on workload patterns to balance performance and cost. Identify and implement cost optimization opportunities, including workload scheduling, pause/resume automation, storage optimization, and query tuning. Optimize SQL queries, partitioning strategies, indexing, and data distribution (Hash, Round Robin, Replicated tables) to improve performance. Design and maintain dimensional data models (Star/Snowflake schemas) for reporting and analytics. Monitor pipeline execution, troubleshoot failures, and ensure high availability and reliability. Implement CI/CD pipelines using Azure DevOps for deployment automation. Collaborate with business stakeholders, architects, and BI teams to deliver scalable analytics solutions. Ensure data quality, governance, security, and compliance across the data platform. Document technical designs, operational procedures, and best practices.

Collected experience requirement

5 to 8 years