ETL Informatica Developer

Job Description

Essential Technical Skills

• Take initiative and show ownership and able to drive projects to closure • Strong ETL background, IICS experience will be preferred

• Strong DB/SQL skills

• Experience in Snowflake development

• ESP or any similar scheduling tool experience

Experience:

• 8+ years’ experience in DW/ETL projects.

• Should have strong data warehousing concepts. • Experienced in ETL development using Informatica IICS

• Experienced in Snowflake data warehouse, Strong SQL skills

• Good knowledge in various informatica transformations, informatica performance tuning, development of ETLs for Facts as well as dimension tables using the SCD Type-I & SCD type-II.

• Experience in understanding requirement, ETL designing, Development Planning etc

• Tech Lead experience preferable, should be able to discuss and get ETL design approval from Client Tech leads

• Solid analytical, problem solving skills, experience with Oracle, ODS/EDW

• Experience in UNIX shell scripting will be advantage

• Exp in writing ETL specification documents

• Should have good communication skills with ability to participate in discussions with business users and other IT stakeholders.

• Understanding of Agile way of working

• Prior experience with Banking will be preferred.