Good Knowledge of Informatica ETL jobs development.
Experience of Extraction, Transformation, and Loading of data from various data sources into Data Marts and Data Warehouse using Informatica PowerCenter components.
Good experience in creating Transformations and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources to targets.
Good experience creating complex mappings in Informatica BDM.
Awareness of any one scheduler tool - CA7/ESP for Job monitoring
Basic knowledge of Ab Initio dependency analysis and lineage.
Basic JCL knowledge
Good knowledge of Unix Commands and work experience in Unix Shell Scripting
Good knowledge of SQL - Teradata/Oracle
Knowledge of Hadoop, HIVE, Parquet, Avro
Good analytical and problem solving skills
Good understanding of Data warehousing and SCD
Good knowledge in ETL process, standards, and best practices.
