Azure Synapse + Data Warehouse - Sr Technical Lead-Data Engg
BirlaSoft · Noida · onsite · Posted 42d ago
Undisclosed2–8 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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...[phone removed] | 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
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
Data ingestionadvanced sqlAzure SQL DatabaseAdls Gen2analytics platformsAzure MonitoringAnalyticsADLSData LakeAzure SynapseData EngineeringArchitectureData IntegrationAzure Data FactoryAzure Data LakeMicrosoft Azure
About Birlasoft
BirlaSoft
IT Services & Consulting
10.9k+
employees
1995
31 years old
Pune, Maharashtra
India
About
Birlasoft combines the power of a domain, enterprise, and digital technologies to reimagine business potential. Surpassing expectations, breaking convention!
Industries
IT Services & Consulting
Employee ratings
3,764 reviews
3.4/ 5
Culture
3.3
Career growth
2.6
Work-life
3.6
Employees rate it well for
Work Life Balance532Salary397Senior Management376Work Culture319Appraisal309
Find them on