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.
n
Key Responsibilities:
n
n
- Develop ETL workflows using Informatica IICS and PowerCenter
n
- Implement performance tuning strategies for ETL processes
n
- Design and develop ETLs for fact and dimension tables using SCD Type-II
n
- Write and optimize SQL queries for Oracle, DB2, Teradata
n
- Prepare ETL specification documents and collaborate with testers and PMO
n
- Work with scheduling tools like ESP, Control-M, Autosys
n
- Participate in discussions with business users and IT stakeholders
n
- Provide support for ODS/EDW environments and troubleshoot issues
n
n
Essential Technical Skills:
n
n
- Strong ETL background, preferably with IICS experience
n
- Proficient in SQL and database concepts
n
- Knowledge of Informatica transformations and performance tuning
n
- Experience with Oracle, DB2, Teradata
n
- Familiarity with UNIX shell scripting and utilities
n
- Exposure to Business Objects, Tableau (preferred)
n
- Understanding of data warehousing concepts and SDLC
n