Subcontractor

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] (https://birlasofto365.sharepoint.com/sites/SmartContractsCLMTool/_layouts/15/Doc.aspx?sourcedoc=%7B3C288198-ABBA-4F49-ABE5-649ECF3E239C%7D&file=25543668-c735-4e68-856b-4ab48ee0f839-638925623291332387.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

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.