Job Description & Responsibilities

Ability to design data quality and reconciliation framework using ODI Integrate ODI with multiple Sources /Target
Experience in building/customizing ETLs from Source Systems such as Oracle Database to Data Warehouse.
Exp in Working with ODI Designing, Topology Management, Operator, Security management.
Exp Oracle Data Integrator Designer (ODI) to develop processes for Extracting, Transforming, Integrating, and loading data into Target Systems.
Expertise in configuring the ODI Master and Work Repositories, ODI models etc
Excellent in writing PL-SQL DDL & DML queries and troubleshooting complex stored-procedures
Packaging components, database operations like Aggregate pivot, union, etc. using ODI mappings, error handling, automation using ODI, Loadplans, Migration of Objects.
Must be well-versed and hands-on in using and customizing Knowledge Modules (KM).
Setting up topology, building objects in Designer, Monitoring Operator, different types of KMs, Agents, etc.
Worked with Oracle, XML data, File in ODI.

Oracle Data Integrator|Multiple|6+Years

Job Description & Responsibilities