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.
Strong data warehousing concepts.
ETL development using Informatica IICS.
Snowflake data warehouse experience and strong SQL skills.
Knowledge of various Informatica transformations, performance tuning, and development of ETLs for Facts and dimension tables using SCD Type-I & SCD Type-II.
Experience in understanding requirements, ETL designing, and development planning.
Tech Lead experience preferable, able to discuss and get ETL design approval from Client Tech leads.
Solid analytical and problem-solving skills, experience with Oracle, ODS/EDW.
UNIX shell scripting experience will be an advantage.
Experience in writing ETL specification documents.
Good communication skills with the ability to participate in discussions with business users and other IT stakeholders.