Developed complex informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router.
- Implemented Type 1 and Type 2 methodologies in ODS tables loading to keep historical data in data warehouse.
- Designed Incremental loading process to load data into staging tables.
- Created Worklets, Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
- Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs. Also involved in migration/conversion of ETL processes from development to production.
- Created reusable email tasks in Workflow manager for process exception handling.
- Participated in user meetings, gathered Business requirements & specifications for the data warehouse design. Translated the user inputs into ETL design docs.