TechnoGen
ETL Informatica Developer
TechnoGen, Atlanta, Georgia, United States, 30383
Role:
ETL Informatica Developer-SAP
Location:
Remote
Experience:
11+ Years
Client:
Tech M
Responsibilities
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.
ETL Informatica Developer-SAP
Location:
Remote
Experience:
11+ Years
Client:
Tech M
Responsibilities
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.