Azure Synapse Engineer Azure Synapse Engineer Experience- 5 to 8 Years

Hoonartek; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Hoonartek is seeking an experienced Azure Synapse Engineer to design, develop, optimize, and maintain enterprise-scale data warehouse and analytics solutions on Azure Synapse Analytics. You will build high-performance ETL/ELT pipelines, implement incremental processing, and drive cost optimization through DWU right-sizing and workload management.

The role requires strong SQL development, experience with Synapse Pipelines, Spark, and ADLS Gen2, plus expertise in performance tuning and CI/CD

Qualifications

• Strong experience with Azure Synapse Analytics (Dedicated SQL Pool and Serverless).
• Hands-on experience with Azure Data Factory and Synapse Pipelines.
• Strong SQL development and performance tuning expertise.
• Experience implementing incremental loading, CDC, watermark-based processing.
• Expertise in DWU sizing, workload management, and query performance optimization.
• Experience with cost optimization strategies in Azure Synapse.
• Knowledge of Azure Data Lake Storage (ADLS Gen2).
• Experience with Spark, PySpark, or Synapse Notebooks.
• Understanding of dimensional modeling and enterprise data warehousing concepts.
• Experience with Azure DevOps, Git, and CI/CD practices.
• Familiarity with monitoring and troubleshooting Azure-based data platforms.

Responsibilities

• 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, CDC, or timestamp-based techniques.
• 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 and query tuning.
• Optimize SQL queries, partitioning strategies, indexing, and data distribution for performance.
• Design and maintain dimensional data models (Star/Snowflake) for reporting and analytics.
• Monitor pipeline execution, troubleshoot failures, and ensure high availability.
• Collaborate with business stakeholders, architects, and BI teams to deliver scalable analytics solutions.
• Ensure data quality, governance, security, and compliance across the data platform.

Skills

Azure Synapse Analytics

Azure Data Factory

SQL Development

Incremental Loading

CDC

DWU Sizing

Cost Optimization

ADLS Gen2

Spark/PySpark

CI/CD

Git

Dimensional Modeling

Job description

We empower enterprises globally through intelligent, creative, and insightful services for data integration, data analytics and data visualization.

Hoonartek is a leader in enterprise transformation, data engineering and an acknowledged world-class Ab Initio delivery partner.

Using centuries of cumulative experience, research and leadership, we help our clients eliminate the complexities & risk of legacy modernization and safely deliver big data hubs, operational data integration, business intelligence, risk & compliance solutions and traditional data warehouses & marts.

At Hoonartek, we work to ensure that our customers, partners and employees all benefit from our unstinting commitment to delivery, quality and value. Hoonartek is increasingly the choice for customers seeking a trusted partner of vision, value and integrity

How We Work?

Define, Design and Deliver (D3) is our in-house delivery philosophy. It’s culled from agile and rapid methodologies and focused on ‘just enough design’. We embrace this philosophy in everything we do, leading to numerous client success stories and indeed to our own success.

We embrace change, empowering and trusting our people and building long and valuable relationships with our employees, our customers and our partners. We work flexibly, even adopting traditional/waterfall methods where circumstances demand it. At Hoonartek, the focus is always on delivery and value.

Job 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.
• 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.

Job Requirement

• Strong experience with Azure Synapse Analytics (Dedicated SQL Pool and Serverless SQL Pool).
• Hands-on experience with Azure Data Factory and Synapse Pipelines.
• Strong SQL development and performance tuning expertise.
• Experience implementing incremental loading, CDC, watermark-based processing, and metadata-driven ETL frameworks.
• Expertise in DWU sizing, workload management, and query performance optimization.
• Experience with cost optimization strategies in Azure Synapse.
• Knowledge of Azure Data Lake Storage (ADLS Gen2).
• Experience with Spark, PySpark, or Synapse Notebooks.
• Understanding of dimensional modeling and enterprise data warehousing concepts.
• Experience with Azure DevOps, Git, and CI/CD practices.
• Familiarity with monitoring and troubleshooting Azure-based data platforms.