Oracle Data Integrator

Key Skills: Oracle Data Integrator (ODI), Oracle Data Integrator Designer, Data warehousing, Design, Flow PL-SQL DDL & DML etc

Job Description:

Hands-on 6+ year exp in designing complex ODI Oracle Data Integrator packages, ODI Scenarios, Mappings, Variables.

Strong exp in in Analysis, Design, Development, Implementation of Data Warehousing in ETL process using ODI 12c/11g.

Expertise in Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake Schema modeling.

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.