- Design, build, and maintain ETL/ELT pipelines using Azure Data Factory (ADF) including Pipelines and Data Flows.

- Connect and integrate various Azure Storage accounts, on-prem, and cloud-based data sources using ADF.

- Work extensively with Azure Data Lake Gen2, Azure SQL DB, and Logic Apps.

- Develop and optimize complex T-SQL queries, stored procedures, views, and data logic in SQL Server.

- Build and enhance SSIS ETL packages, including complex transformations, deployment, configuration, and troubleshooting.

- Develop and maintain Power BI datasets and implement DAX measures as required.

- Work on Snowflake for data modeling, query optimization, and pipeline integration.

- Support Azure DevOps processes for CI/CD, version control, and pipeline deployment.

- Collaborate with cross-functional teams following Agile methodology.

- Work with SSAS Tabular Models for analysis and BI requirements.

- Ensure data quality, governance, and operational excellence across systems.

Required Skills :

Primary Skills :

- Azure Data Factory (Pipelines & Data Flows)

- Azure Data Lake Gen2 Storage

- Logic Apps

- SQL Server Analysis Services Tabular

- Power BI (Dataset Creation)

- DAX

- T-SQL (complex queries, stored procedures, views)

- Azure DevOps

- Snowflake (4+ years)

Experience Breakdown :

- 4 - 6 years of hands-on experience with SQL Server and complex T-SQL

- 4 - 6 years of experience with SSIS (complex ETLs, deployments, configurations)

- 2 - 4 years of experience with Microsoft Azure services

- 2- 4 years of hands-on experience using ADF as ETL/ELT

Preferred Skills (Good to Have) :

- Experience with data modeling and performance tuning

- Knowledge of CI/CD pipelines for Azure data solutions

- Familiarity with cloud architecture best practices