JOB DESCRIPTION:
Experience: 8-10 years
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.
Job Type: Fixed term contract
Contract length: 12 months
Pay: $30.00-$50.00 per hour
Expected hours: 40 per week
Schedule:
8 hour shift
Monday to Friday
Morning shift
Experience:
ETL Development: 10 years (preferred)
Informatica IICS: 5 years (preferred)
UNIX shell scripting: 5 years (preferred)
SCD Type-I & SCD type-II: 5 years (preferred)
SQL: 5 years (preferred)
Work Location: Remote