ETL Informatica Developer

Viedtech is seeking an ETL Informatica Developer with 8-10 years of experience in Informatica Intelligent Cloud Services, API, and data modeling. The ideal candidate will have experience with data warehousing solutions using Informatica, relational and dimensional data modeling, and SQL on various databases.

Requirements

• 8-10 years of experience as 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
• Manage 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