3 Apache Synapse Jobs in Pune | Apache Synapse Job openings in Pune

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.

• 5+ years of experience in a Data Engineering role on cloud environment

• Must have good experience in Scala/PySpark (preferably on data-bricks environment)

• Extensive experience with Transact-SQL.
• Experience in Data-bricks/Spark.

• Strong experience in Dataware house projects
• Expertise in database development projects with ETL processes.
• Manage and maintain data engineering pipelines

• Develop batch processing, streaming and integration solutions
• Experienced in building and operationalizing large-scale enterprise data solutions and applications

• Using one or more of Azure data and analytics services in combination with custom solutions
• Azure Data Lake, Azure SQL DW (Synapse), and SQL Database products or equivalent products from other cloud services providers

• In-depth understanding of data management (e. g. permissions, security, and monitoring).
• Cloud repositories for e.g. Azure GitHub, Git
• Experience in an agile environment (Prefer Azure DevOps).

Good to have

• Manage source data access security
• Automate Azure Data Factory pipelines
• Continuous Integration/Continuous deployment (CICD) pipelines, Source Repositories
• Experience in implementing and maintaining CICD pipelines
• Power BI understanding, Delta Lake house architecture
• Knowledge of software development best practices.
• Excellent analytical and organization skills.
• Effective working in a team as well as working independently.
• Strong written and verbal communication skills.
• Expertise in database development projects and ETL processes.