Job Summary :

We are looking for a skilled Data Engineer with strong experience in SQL, SSIS, and Azure Data Factory (ADF) to design, build, and maintain scalable data integration and ETL/ELT pipelines.

The ideal candidate will work closely with data analysts, BI teams, and business stakeholders to ensure reliable, high-quality data delivery for reporting and analytics.

Key Responsibilities :

- Design, develop, and maintain ETL/ELT pipelines using SSIS and Azure Data Factory.

- Build and optimize complex SQL queries, stored procedures, functions, and views.

- Develop data integration solutions for structured and semi-structured data from multiple sources.

- Migrate on-premises data pipelines to Azure cloud environments.

- Monitor, troubleshoot, and optimize data pipelines for performance and reliability.

- Implement data validation, quality checks, and error-handling mechanisms.

- Work with stakeholders to gather requirements and translate them into technical solutions.

- Ensure data security, governance, and compliance standards are followed.

- Create and maintain technical documentation for data workflows and processes.

- Collaborate with cross-functional teams in an Agile/Scrum environment.

Mandatory Skills & Qualifications :

- 4+ years of experience as a Data Engineer or ETL Developer.

- Strong hands-on experience with SQL (T-SQL preferred).

- Extensive experience with SSIS (SQL Server Integration Services).

- Proven experience with Azure Data Factory (ADF) for data orchestration.

- Experience working with SQL Server and relational databases.

- Strong understanding of data warehousing concepts and dimensional modeling.

- Experience in performance tuning and optimization of ETL processes.

- Knowledge of error handling, logging, and scheduling in data pipelines