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
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.
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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLInformatica Intelligent Cloud Services (IICS)SQLTeradataOracleSQL ServerAWS RedshiftData warehousingPower CenterShell scripting

Soft Skills

analytical skillsproblem-solving skillsrequirement gatheringrequirement analysistask managementdeadline management