• Create the design and technical specifications for the ETL process of the project.
• Use Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Work with various stake holders and implement complex mapping, designed slowly changing dimension Type1 and Type2.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Create Workflows containing command, email, session, decision and a wide variety of tasks.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Perform data validation after the successful End to End tests and appropriate error handling in ETL processes.
Work Life Group
Nagarro
Conexess Group
IT Performance
