Azure Synapse + Data Warehouse - Sr Technical Lead-Data Engg

Birlasoft; India; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

Birlasoft is seeking an experienced Azure Synapse Performance Engineer to design, optimize, and troubleshoot enterprise analytics platforms and data warehouses. You will handle data pipelines, data lakes, and Synapse-based workloads at scale.

The role emphasizes performance tuning, pipeline orchestration, and ensuring data quality and availability across analytics ecosystems. Strong expertise in Synapse, ADF, and data warehousing is required for success.

Qualifications

• Experience with designing enterprise-scale analytics platforms and data warehouses.
• Proficiency in Azure Synapse Analytics, ADF, and related data engineering tools.
• Strong SQL performance tuning and partitioning/ indexing knowledge.
• Experience building scalable data lakes and ETL/ELT pipelines.
• Ability to monitor, optimize, and troubleshoot large data workloads.

Responsibilities

• Design, develop, and optimize Azure Synapse-based solutions.
• Build data integration using ADF and Synapse Pipelines.
• Design scalable Data Lake architectures (ADLS Gen2).
• Develop high-performance ETL/ELT frameworks for enterprise platforms.
• Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
• Identify bottlenecks and implement optimization strategies across data movement and transformation.

Skills

Azure Synapse Analytics

Azure Data Factory

Synapse Pipelines

ADLS Gen2

Azure SQL Database

SQL Performance Tuning

ETL/ELT Design

Data Lake Architecture

Data Integration

Batch Processing

Performance Benchmarking

Partitioning & Indexing

Execution Plan Analysis

Data Modeling (Star/Snowflake)

Tools

Azure Synapse Analytics

Azure Data Factory (ADF)

Synapse Pipelines

ADLS Gen2

Azure SQL Database

Log Analytics

Job description

Select how often (in days) to receive an alert:

Location: INDIA - NOIDA- BIRLASOFT OFFICE

Title: Azure Synapse + Data Warehouse - Sr Technical Lead-Data Engg

Description:

Area(s) of responsibility

We are seeking an experienced Azure Synapse Performance Engineer with strong expertise in Azure Synapse Analytics, Azure Data Factory, ETL/ELT optimization, SQL performance tuning, and Data Warehouse architecture. The ideal candidate will be responsible for designing, optimizing, and troubleshooting enterprise-scale analytics platforms, data pipelines, and data warehouse workloads while ensuring high performance, scalability, and reliability. Similar responsibilities are referenced in internal documentation related to Azure Synapse, Data Lakes, ETL optimization, pipeline orchestration, and performance tuning.

Key Responsibilities

Azure Synapse & Data Engineering

• Design, develop, and optimize solutions using Azure Synapse Analytics.
• Build and maintain data integration solutions using Azure Data Factory (ADF) and Synapse Pipelines.
• Design and implement scalable Data Lake architectures (ADLS Gen2).
• Develop high-performance ETL/ELT frameworks for enterprise data platforms.
• Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
• Identify performance bottlenecks and implement optimization strategies across data movement and transformation processes.
• Ensure data quality, availability, and reliability across analytics ecosystems. These responsibilities align with internally referenced practices around data warehousing, ETL optimization, data lakes, and Synapse performance tuning. [25543668-c...3291332387 | Word]

SQL & Data Warehouse Performance

• Perform advanced SQL query analysis and optimization.
• Analyze and optimize execution plans for complex analytical workloads.
• Configure and tune Synapse Dedicated SQL Pools.
• Design and implement efficient partitioning strategies for large datasets.
• Optimize indexing, statistics, and workload distribution.
• Perform capacity planning and performance benchmarking.
• Support data warehouse modernization and optimization initiatives.

Required Technical Skills

Azure Technologies

• Azure Synapse Analytics
• Azure Data Factory (ADF)
• Synapse Pipelines
• Azure Data Lake Storage (ADLS Gen2)
• Azure SQL Database
• Azure Monitoring and Log Analytics

Data Engineering

• ETL/ELT Design and Development
• Data Lake Architecture
• Data Integration and Orchestration
• Batch and Incremental Data Processing
• Performance Tuning and Optimization

SQL & Data Warehousing

• Advanced T-SQL
• Query Performance Tuning
• Execution Plan Analysis
• Data Modeling (Star Schema / Snowflake Schema)
• Partitioning and Indexing Strategies
• Statistics Management
• Synapse SQL Pools
• Data Warehouse Optimization

Performance Engineering

• Root Cause Analysis
• Workload Monitoring
• Troubleshooting Large-Scale Data Processing
• Capacity Planning
• Performance Benchmarking