- 8-10 Years of experience as Strong ETL- Informatica Intelligent Cloud Services (IICS) along with API experience.
- Good experience with Informatica cloud migration projects.
- Good knowledge of SQL - Teradata/Oracle/SQL Server/AWS Redshift
- Assess requirements for completeness and accuracy
- Responsible for managing tasks and deadlines for the ETL teams.
- Requirement gathering and requirement Analysis.
- 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
All your information will be kept confidential according to EEO guidelines.
