Senior ETL Developer - Informatica IICS /SSIS

Job Summary We are seeking a Senior ETL Developer with strong expertise in Informatica IICS and SSIS to support a data warehousing modernization initiative. This role involves redesigning and optimizing existing ETL processes to integrate new data sources into established warehouse structures. The ideal candidate will have deep hands-on experience in data integration, SQL development, and working closely with cross-functional data teams. Key Responsibilities Rewrite and optimize existing ETL processes to support new data source integration Develop, execute, and optimize complex SQL queries for data extraction, transformation, and validation Design and implement data integration workflows using Informatica Intelligent Cloud Services (IICS) Create, modify, and manage SSIS packages and jobs using Microsoft Visual Studio Ensure data quality, consistency, and performance across data pipelines Collaborate closely with on-site data teams for requirements, development, and validation Troubleshoot ETL processes and resolve performance or data-related issues Support data warehouse enhancements and modernization efforts Required Qualifications Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) Data Integration module Experience with SQL Server Integration Services (SSIS) Strong proficiency in SQL and data transformation logic Experience working with data warehousing concepts and ETL processes Strong analytical and problem-solving skills Ability to work collaboratively in a team-oriented environment Preferred Qualifications Experience with Informatica PowerCenter Experience working in large-scale data migration or modernization projects Familiarity with performance tuning and optimization of ETL pipelines

Education:

Bachelors Degree