Subcontractor

Birlasoft; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Birlasoft is seeking a Subcontractor to architect and optimize data engineering solutions using Azure Synapse Analytics in Noida office. You will design and implement data pipelines with ADF and Synapse Pipelines, build scalable Data Lake architectures (ADLS Gen2), and develop high-performance ETL/ELT frameworks.

You will analyze SQL workloads, configure Synapse Dedicated SQL Pools, and ensure data quality and reliability across analytics ecosystems.

Qualifications

• Experience designing data warehouses on cloud platforms.
• Proficient in Azure Synapse Analytics and ADF.
• Experience with large-scale ETL/ELT pipelines.
• Strong SQL performance tuning skills.

Responsibilities

• Design, develop, and optimize solutions using Azure Synapse Analytics.
• Build and maintain data integration with Azure Data Factory and Synapse Pipelines.
• Design scalable Data Lake architectures (ADLS Gen2).
• Develop high-performance ETL/ELT frameworks.
• Monitor and troubleshoot large-scale data workloads.
• Identify performance bottlenecks and optimize data movement and transformation.
• Ensure data quality, availability, and reliability across analytics ecosystems.
• 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.

Skills

Azure Synapse

Azure Data Factory

Synapse Pipelines

ADLS Gen2

ETL/ELT

SQL Optimization

Tools

Synapse Dedicated SQL Pools

Job description

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

Location: INDIA - NOIDA- BIRLASOFT OFFICE

Title: Subcontractor

Description:

Area(s) of responsibility

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.