We are seeking an experienced ETL Developer with solid expertise in Informatica IICS (Intelligent Cloud Services) and PowerCenter to design, develop, and optimize data integration solutions. The ideal candidate will have a solid understanding of data warehousing concepts , performance tuning, and SQL, along with experience in scheduling tools and agile methodologies. Key Responsibilities: Develop ETL workflows using Informatica IICS and PowerCenter Implement performance tuning strategies for ETL processes Design and develop ETLs for fact and dimension tables using SCD Type-II Write and optimize SQL queries for Oracle, DB2, Teradata Prepare ETL specification documents and collaborate with testers and PMO Work with scheduling tools like ESP, Control-M,
Autosys Participate in discussions with business users and IT stakeholders Provide support for ODS/EDW environments and troubleshoot issues Essential Technical Skills: Strong ETL background , preferably with IICS experience Proficient in SQL and database concepts Knowledge of Informatica transformations and performance tuning Experience with Oracle , DB2 , Teradata Familiarity with UNIX shell scripting and utilities Exposure to Business Objects , Tableau (preferred) Understanding of data warehousing concepts and SDLC