Oracle Data Integrator Skills needed to become a good ETL Developer

The recruiter will look for the following skills while searching for an ETL or ODI developer. Particular positions may need different skills but these are the general ODI skills needed.

1. Know everything about ODI architecture and ODI components.
2. Working knowledge with creating different interfaces, packages, constraints, procedures, SQL joins functions and agents etc.
3. Extend the base ODI Knowledge Modules to create customized versions that will be re-usable across the company's data integration projects.
4. Map business rules into Oracle Data Integrator Interfaces, Packages, and Load Plans source to target mappings .
5. Take care of business rules using ODI Constraints and Data quality functions.
6. Know the differences between Oracle Data Integrator versions like 10g, 11g and 12c.
7. Working knowledge with Change Data Capture (CDC). 
8. Knowledge on Data warehouse concepts such as Dimensional modelling, Entity relationship.

Apart from knowing the tool, the developer must be aware of data warehouse concepts in depth. SQL skills are also must.

What are the Oracle Data Integrator GUI components ?

Oracle Data Integrator is made up of the following graphical user interface (GUI) components.
In the current releases of ODI all of these Graphical User Interface components are combined into Oracle Data Integrator Studio.

What is an agent in Oracle Data Integrator (ODI) ?

We know that there are run time and design time components in Oracle Data Integrator.

ODI agent is a run time component.

What is ODI agent ?

Oracle Data Integrator agent is a java program which will listen on a particular TCP/IP port. Agent can execute the scenarios when it is invoked from one of the ODI GUI modules or schedule these executions when it is started as a scheduler.

There are two types of ODI Agents available.

1. Standalone Java Agent :When request is received for a scenario execution, it start arranging the scenario and updates the status to work repository. A parent and child standalone agents can be configured in ODI studio to do the load balancing if there is a need to load balance between stand alone agents.
2. JavaEE agent : This agent is part of web logic and listens on a particular port. When request is received for a scenario execution, it start arranging scenario and updates the status to work repository. Load balancing is supported to through web logic clusters for a Java EE Agent.

Difference between Oracle Data Integrator features 10g, 11g and 12c

Differences between Oracle Data Integrator 12c and 11g: 

ODI 12c is the latest version of ODI.

1. loading multiple target tables as part of a single interface. Interface is termed as mapping in ODI 12c on wards.
2. Redesigned declarative flow-based user interface, reusable mappings, runtime performance enhancements, Oracle GoldenGate integration improvements, Big Data and XML improvements, Oracle Warehouse Builder integration.

complete change log is here
Oracle Data Integrator 11g and 10g:

1. ODI 11g has all the ODI components(Designer, Operator, Topology and Security) integrated together as Oracle Data Integrator Studio.
2. ODI 11g provides a Java API to manipulate both the design-time and run-time artifacts of the product. This API allows you for example to create or modify interfaces programmatically, create your topology, perform import or export operations, launch or monitor sessions. This API can be used in any Java SE and Java EE applications, or in the context of Java-based scripting languages like Groovy or Jython.
3. External Password Storage, to have source/target data servers (and contexts) passwords stored in an enterprise credential store. External Authentication, to have user/password information stored in an enterprise identity store (e.g.: LDAP, Oracle Directory, Active Directory), and ODI authenticating against this store. These two features let you optionally store critical information in dedicated storages and not within the ODI repository. The ODI Console may also use Oracle's single-sign on systems with ODI.

Oracle Data Integrator (ODI) Interview questions

1) What components make up Oracle Data Integrator?

"Oracle Data Integrator" comprises of the following

1. Oracle Data Integrator + Topology Manager + Designer + Operator + Agent. 
2. Oracle Data Quality for Data Integrator.
3. Oracle Data Profiling.

2) What is a model in ODI ?

A data model corresponds to group of tabular data structure stored in a data server and is based on a Logical Schema defined in the topology and contain only metadata.

3) What are User Parameters in Oracle Data Integrator?

Oracle Data Integrator saves user parameters such as default directories, windows positions etc. User parameters are saved in the userpref.xml file in /bin.

Oracle Data Integrator 11g Certified Implementation Essentials Syllabus

Introduction to Oracle Data Integrator (ODI)

1. Describe the benefits of ODI (including ODI architecture - Extract Load Transform) and it's typical use cases 
2. Describe the ODI components and their uses 
3. Architecture Overview 
4. Describe ODI Architecture 
5. Install and Configure the physical and logical architecture 
6. Explain the Fusion Middleware Components - Upgrade Assistant, Repository Creation Utility and Java Enterprise Edition (JEE) Components and High Availability