We are seeking an experienced ETL Developer with strong 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 wi...