ETL Developer - Informatica Intelligent Cloud Services (IICS)

• Critical Skillset Requirements
  • Deep IICS Experience is critical for this role.
  • Experience with Informatica Migration efforts (specifically from Power Center to IICS) is critical.
  • Some experience with QA of these type of migration efforts is also important.

• Job Description/Skillset Requirements

·         8-10 Years of experience as Strong ETL- Informatica Intelligent Cloud Services (IICS) along with API experience. 

·         Solid experience with Informatica cloud migration projects.

·         Good knowledge of SQL - Teradata/Oracle/SQL Server/AWS Redshift

·         Assess requirements for completeness and accuracy.

·         Technical lead experience is beneficial, they will be involved in managing tasks and deadlines for the dev team.

·         Should be familiar with Requirements gathering and Requirements Analysis, will need to do Data discovery. 

·         Sound concepts of Relational and dimensional data modelling with good DW concept.

·         Good working exposure in Star and Snowflake Schemas

·         Good working exposure in implementing end-to-end Data warehousing solutions using Informatica.

·         Head complex ETL requirements and design. Identify, recommend, and implement ETL process and architecture improvements.

·         Determine if requirements are actionable for ETL team

·         Sound Informatica Power Center knowledge.

·         Good Knowledge on Power Center jobs implementation along with Sound SCD concepts

·         Good knowledge on defines data collection methods, data models, types, and outlines the transformation process.

·         Understanding concepts of Cloud and good exposure with Amazon Redshift would be an added advantage.

·         Good knowledge of writing shell scripts

·         Ability to design, test, debug and migrate Informatica code.

·         Ability to develop test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance, and scalability.

·         Good analytical and problem-solving skills

·         Good communication skills