Location:-Cincinnati, Ohio

Duration:- 6 Month

Remote role

Skills: SAP BPC optimized for SAP S4HANA

JD

Informatica integration in SAP ERP implementation project

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