• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 24th Apr 2024

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.