Azure Synapse + Data Warehouse - Sr Technical Lead-Data Engg (INDIA - NOIDA- BIRLASOFT OFFICE, IN)

Birlasoft
Noida
Workplace: OnsiteFull timeFunction: Supply Chain & LogisticsSkills: ["Root cause analysis","Workload monitoring","Performance benchmarking","Troubleshooting large-scale data processing","Data quality focus"]

Design, optimize, and troubleshoot enterprise analytics platforms using Azure Synapse Analytics and Azure Data Factory. Build scalable data lake and ETL/ELT frameworks, monitor large-scale ingestion and transformation workloads, and eliminate performance bottlenecks across data movement. Lead SQL and data warehouse performance efforts—tuning Dedicated SQL Pools, execution plans, partitioning, indexing, statistics, and workload distribution—while ensuring data quality, availability, scalability, and reliability.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Birlasoft
Birlasoft
1 day ago

Azure Synapse + Data Warehouse - Sr Technical Lead-Data Engg (INDIA - NOIDA- BIRLASOFT OFFICE, IN)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 13 hours agoStatus: Live

Job Summary

Design, optimize, and troubleshoot enterprise analytics platforms using Azure Synapse Analytics and Azure Data Factory. Build scalable data lake and ETL/ELT frameworks, monitor large-scale ingestion and transformation workloads, and eliminate performance bottlenecks across data movement. Lead SQL and data warehouse performance efforts—tuning Dedicated SQL Pools, execution plans, partitioning, indexing, statistics, and workload distribution—while ensuring data quality, availability, scalability, and reliability.
Location: Noida
Workplace: Onsite
Employment Type: Full time
Job Function: Supply Chain & Logistics
Seniority: Mid level

Key Responsibilities

  • •Design, develop, and optimize Azure Synapse analytics solutions.
  • •Build and maintain data integration solutions using ADF and Synapse Pipelines.
  • •Develop scalable data lake architectures on ADLS Gen2 and high-performance ETL/ELT frameworks.
  • •Monitor and troubleshoot large-scale ingestion, transformation, and processing workloads to ensure performance, reliability, and scalability.
  • •Perform SQL and data warehouse performance engineering, including query optimization, execution plan analysis, and tuning Dedicated SQL Pools.

Key Requirements

  • •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 using ADLS Gen2.
  • •Perform advanced SQL query analysis and optimization, including execution plan analysis for complex workloads.
  • •Configure and tune Synapse Dedicated SQL Pools, including partitioning, indexing, statistics, and workload distribution.
Skills:Root cause analysisWorkload monitoringPerformance benchmarkingTroubleshooting large-scale data processingData quality focus
Tech Stack:Azure Synapse AnalyticsAzure Data Factory (ADF)Synapse PipelinesAzure Data Lake Storage (ADLS Gen2)Azure SQL DatabaseAzure Monitoring and Log AnalyticsETL/ELTT-SQLExecution Plan AnalysisStar SchemaSnowflake SchemaPartitioningIndexingStatistics ManagementSynapse Dedicated SQL PoolsData modelingData integrationPipeline orchestrationCapacity planning

Company Brief

Birlasoft
Birlasoft is a global IT services and digital solutions provider delivering consulting, enterprise applications, cloud, and infrastructure services to enterprises across industries, helping accelerate digital transformation and business modernization.
Industry: Professional Services
Company Size: Enterprise (1,001+ employees)
Revenue: USD 500M to 1B
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Noida, India
WebsiteLinkedIn