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