SSIS / Azure Data Factory Engineer

We are looking for an experienced SSIS Engineer with Azure Data Factory (ADF) experience to design, develop, migrate, and support enterprise grade data integration and ETL solutions. The role focuses on modernising data pipelines, ensuring reliable data movement between on premises and cloud platforms, and supporting data driven initiatives. The ideal candidate has strong hands on experience with SQL Server Integration Services (SSIS) and is comfortable operating, migrating, and orchestrating workloads using Azure Data Factory. Key Responsibilities * Design, develop, maintain, and optimise SSIS packages for data extraction, transformation, and loading (ETL). * Migrate and orchestrate existing SSIS workloads using Azure Data Factory (including SSIS Integration Runtime where applicable). * Build and maintain ADF pipelines, datasets, linked services, and triggers. * Integrate data from multiple sources such as SQL Server, Azure SQL, Data Lake, Blob Storage, APIs, and file systems. * Monitor, troubleshoot, and improve data pipeline performance, reliability, and scalability. * Implement logging, error handling, and monitoring best practices across SSIS and ADF solutions. * Collaborate with data architects, analysts, and application teams to translate business requirements into technical solutions. * Support CI/CD processes and version control for data integration assets. * Ensure compliance with data security, governance, and quality standards. Required Skills & Experience * Strong hands on experience with SQL Server Integration Services (SSIS). * Proven experience with Azure Data Factory, including orchestration of SSIS packages. * Solid knowledge of SQL Server / T SQL for data validation and transformations. * Experience working with cloud and hybrid data integration scenarios. * Familiarity with Azure data services (Azure SQL, Azure Storage, Data Lake). * Ability to troubleshoot complex ETL and data pipeline issues. * Good understanding of ETL best practices, performance tuning, and data quality. Nice to Have * Experience migrating legacy SSIS solutions to cloud native ADF pipelines. * Knowledge of Azure Synapse Analytics, Databricks, or other analytics platforms. * Experience with DevOps / CI CD for data pipelines (Azure DevOps, Git). * Exposure to Power BI and downstream analytics use cases. * Previous experience in enterprise or telecom environments. Soft Skills * Strong analytical and problem solving skills. * Clear communication with both technical and non technical stakeholders. * Ability to work independently and within distributed teams. * Results driven and delivery focused mindset.

Do you have experience in T-SQL?