- 6+ years ETL Lead / developer experience and a minimum of 3- 4 Years experience in Oracle Data Integrator (ODI)

- Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI

- Minimum 2-3 end to end DWH Implementation experience.

- Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.

- knowledge of ODI Master and work repository

- Knowledge of data modelling and ETL design

- Design and develop complex mappings, Process Flows and ETL scripts

- Must be well versed and hands-on in using and customizing Knowledge Modules (KM)

- Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc.

- Packaging components, database operations like Aggregate pivot, union etc.

- Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects

- Design and develop complex mappings, Process Flows and ETL scripts

- Must be well versed and hands-on in using and customizing Knowledge Modules (KM)

- Experience of performance tuning of mappings

- Ability to design ETL unit test cases and debug ETL Mappings

- Expertise in developing Load Plans, Scheduling Jobs

- Integrate ODI with multiple Source / Target

- Experience in Data Migration using SQL loader, import/export