Description

Manage Informatica integration for an SAP ERP implementation project. You will own the ETL lifecycle from design to validation.

Responsibilities

• Create technical specifications and designs for ETL processes.
• Build source/target definitions, mappings, and sessions to load data into staging tables.
• Develop complex mappings using Router, Lookup, Expression, Aggregator, Update Strategy, and Stored Procedure transformations.
• Implement Slowly Changing Dimensions (SCD) Type 1 and Type 2.
• Tune performance at the mapping, session, source, and target levels, including partition creation.

Required Skills

• 5+ years of experience in ETL development.
• Proficiency with Informatica for data extraction, transformation, and loading.
• Hands-on experience with SAP ERP implementation projects.
• Experience designing and implementing SCD Type 1 and Type 2.
• Ability to perform performance tuning and partitioning.
• Strong understanding of data validation and error handling in ETL pipelines.
• Build workflows containing command, email, session, and decision tasks.
• Identify and fix bugs by analyzing data flows and evaluating transformations.

Preferred Skills

• Any Graduate degree.

Key Skills

Education

Any Graduate