Technical/Functional Skills:
- Solid 3+ years in Informatica ETL process
- Design and develop mappings, Workflows from various Transformations like re-usable transformations, Mappings/ Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
- Create Informatica mappings, workflows with source as mainframe, Databases and multiple files.
- Good understanding on PL/SQL store procedures/functions to incorporate in ETL for data load.
- Strong experience in Dimensional Modelling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modelling using Erwin and ER-Studio
- Create informatica mappings using CDC flow.
- Create Dimension/Fact with all types of SCD concepts.
- Experience on Unix Shell Scripts which would be used in ETL to do other activities.
- Good understanding on deploying ETL workflows in QA and Production using Bitbucket, Bamboo and RA tools.
- Experience in Performance tuning of targets, sources, mappings and sessions.
- Good understanding of development methodologies like Waterfall and Agile model
- Good communication skill is a must