Oracle has developed an Extract, Load and Transform tool (ELT) called Oracle Data Integrator. This tool offers a graphical environment to build, manage and maintain a data integration process in the business intelligence systems.

If you are looking for any ODI jobs opportunity, then make sure that you follow the tips mentioned in this article before you attend an interview.

A recruiter will check for various skills in an ODI developer based on the positions. But, there are the few basic points to keep in mind while attending the Oracle Data Integrator Job interview which is mentioned in the further part of this article.


  1. Know the basics of the Oracle Data Integrator architecture and what components it relies on to fully leverage the WebLogic Application Server. Know in-depth regarding the ODI components like ODI console, ODI Studio and user interfaces, Repositories and Management pack for the ODI.
  2. You must also have the working knowledge with creating different packages, constraints, interfaces, SQL joint functions, agents and constraints, etc., this is one of the critical areas where the recruiter emphasises on.
  3. One must know the primary differences between the Oracle Data Integrator versions like 10g, 11g and 12c. For example, you can load multiple targets in 12c as a part of the single interface. Also, the interface is termed as mapping in ODI 12c.Unlike 10g, ODI 11g has all the ODI components integrated together as the Oracle Data Integrator Studio. Also, ODI 11g provides a Java API to manipulate both the runtime and design time of the artefacts of the product.

    This kind of basic differences would help you to go through interview smoothly.

  4. You must be able to extend the base ODI knowledge for creating a customised version that can be used across the company’s data integration projects.

Few more points where the Recruiter might test you are Business rules using Oracle Data Integrator, knowledge on CDC (Change Data Capture), Dimensional Modelling and Entity relationship (fundamentals of Data warehouse concepts).

On a final note, there are many ODI Jobs Opportunity available. But, the only thing you need to make sure is, you are technically sound with the fundamentals of the Oracle Data Integrator, and you must be able to answer the recruiter if questions are asked in depth.


You May Also Like