Job DescriptionWe are seeking an experienced ETL Developer with robust 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.
nKey Responsibilities:
n
- n
- Develop ETL workflows using Informatica IICS and PowerCentern
- Implement performance tuning strategies for ETL processesn
- Design and develop ETLs for fact and dimension tables using SCD Type-IIn
- Write and optimize SQL queries for Oracle, DB2, Teradatan
- Prepare ETL specification documents and collaborate with testers and PMOn
- Work with scheduling tools like ESP, Control-M, Autosysn
- Participate in discussions with business users and IT stakeholdersn
- Provide support for ODS/EDW environments and troubleshoot issuesn
nEssential Technical Skills:
n
- n
- Strong ETL background, preferably with IICS experiencen
- Proficient in SQL and database conceptsn
- Knowledge of Informatica transformations and performance tuningn
- Experience with Oracle, DB2, Teradatan
- Familiarity with UNIX shell scripting and utilitiesn
- Exposure to Business Objects, Tableau (preferred)n
- Understanding of data warehousing concepts and SDLCn