Exaguru - Oracle Data Integrator [ODI] Certification Training Course
New ODI Batch Launching Soon!
Enroll Now
From ETL Developer to ODI Data Integration Expert

Master Oracle Data Integrator (ODI)

A 40-hour, 100% hands-on program to develop, administer, monitor, troubleshoot and tune enterprise ODI solutions — finishing with an end-to-end real-world project.

Talk to Sales
40
Hours
10
Modules
20
Sessions × 2 hrs
1
Capstone Project

Guided Hands-On Labs

Working ODI objects every module

Break & Fix Practice

Failed loads, restart & recovery

Performance Tuning

Baseline, tune, compare

5-Hour Capstone

Build, run and present

The ODI Way

ELT, Not Just ETL

ODI generates code that runs inside your databases through Knowledge Modules. You learn to design it, control it and tune it.

Source

Datastores & models

LKM

Load to staging

CKM

Check constraints

IKM

Integrate set-based

Target

Loaded & validated

Traditional ETL ODI (ELT)
Where transforms run On a separate ETL server Inside source / target databases
Processing style Often row by row Set-based SQL pushdown
How logic is reused Per-job coding Knowledge Modules & reusable patterns
What you learn here — Pick, configure and tune the right KM

Why ExaGuru

Learn it the way production teams use it

Not just building a mapping — running, monitoring and rescuing it when it breaks.

Duration40 hours
Format20 × 2-hr sessions
MethodDemos + labs
FinaleEnd-to-end project

Real Project Scenarios

Incremental loads and DEV/TEST/PROD promotion, the situations ODI teams face daily.

Develop, Administer, Tune

Agents, scheduling, monitoring, recovery and performance, not only mappings.

Knowledge Modules Demystified

See how generated code moves data, so you design efficient integrations.

Mentorship from Practitioners

Live sessions with working professionals who review your lab work.

Career Support

Guidance on CV preparation and interview readiness for ODI and data integration roles.

Explore Our Syllabus

10 modules • 40 hours. Click a module to expand. Green highlighted items are hands-on labs.

MODULE 1: ODI FUNDAMENTALS & ARCHITECTURE

2 Hours
  • ODI overview and role in data integration
  • ETL vs. ELT and ODI's approach
  • ODI architecture and major components
  • ODI Studio overview and development lifecycle
  • Repositories and project structure
  • Typical enterprise ODI implementation architecture
  • Lab: Architecture walkthrough
  • Lab: Create/connect to a basic ODI environment

MODULE 2: ODI STUDIO, REPOSITORIES & PROJECT SETUP

2 Hours
  • ODI Studio navigation and perspectives
  • Master and Work Repository concepts
  • Projects, folders and objects
  • Security and basic user concepts
  • Import/export and project organization
  • Development standards and naming conventions
  • Lab: Identify development and runtime components
  • Lab: Create a project and folder structure

MODULE 3: TOPOLOGY, PHYSICAL & LOGICAL ARCHITECTURE

4 Hours
  • Topology concepts
  • Contexts and physical schemas
  • Logical schemas and physical mappings
  • Data servers and technology definitions
  • Agents and execution architecture
  • Environment configuration for DEV/TEST/PROD
  • Lab: Work with repository objects
  • Lab: Demonstrate object migration/import-export

MODULE 4: MODELS & DATASTORES

4 Hours
  • Models and reverse engineering
  • Datastores and metadata
  • Columns, keys and constraints
  • Journalizing overview
  • Source/target metadata management
  • Incremental data integration concepts
  • Lab: Configure a source and target technology
  • Lab: Create physical/logical schemas and a reusable context
  • Lab: Create models and reverse engineer tables

MODULE 5: MAPPINGS & KNOWLEDGE MODULES (KMs)

6 Hours
  • Mapping concepts and components
  • Sources, targets, joins, filters and expressions
  • Reusable mapping patterns
  • Knowledge Module architecture
  • LKM, IKM, CKM and related KM usage
  • KM selection and configuration
  • Set-based ELT processing
  • Integration strategies and data movement
  • Lab: Validate datastores and metadata
  • Lab: Build a basic incremental-load scenario
  • Lab: Build source-to-target mappings using joins/filters/expressions
  • Lab: Configure and execute KMs; implement a complete transformation flow

MODULE 6: PACKAGES, PROCEDURES & VARIABLES

4 Hours
  • Packages and orchestration
  • Steps, conditions and sequencing
  • Procedures and reusable logic
  • Variables and variable refresh
  • Passing parameters and dynamic values
  • Error/exception handling within processes
  • Lab: Create an end-to-end package
  • Lab: Use variables for dynamic processing
  • Lab: Build reusable procedure logic and add success/failure paths

MODULE 7: LOAD PLANS, SCHEDULING & AGENTS

4 Hours
  • Load Plan architecture
  • Serial and parallel execution
  • Scenarios and versioning
  • Scheduling concepts
  • Standalone and colocated agent concepts
  • Agent configuration and execution
  • Lab: Generate and execute a scenario
  • Lab: Create a Load Plan and configure scheduling
  • Lab: Run and monitor execution through an agent

MODULE 8: MONITORING, ERROR HANDLING & TROUBLESHOOTING

4 Hours
  • ODI Operator / execution monitoring concepts
  • Session and step-level monitoring
  • Error identification and root-cause analysis
  • Restart and recovery strategies
  • Log analysis
  • Common development and runtime issues
  • Lab: Monitor successful and failed sessions
  • Lab: Troubleshoot a deliberately failed load
  • Lab: Perform restart/recovery and create a troubleshooting checklist

MODULE 9: PERFORMANCE OPTIMIZATION & ADVANCED ODI

5 Hours
  • ODI performance tuning principles
  • KM and integration strategy optimization
  • Source/target pushdown considerations
  • Parallelism and execution optimization
  • Reducing unnecessary data movement
  • SQL and database considerations
  • Advanced ODI design practices
  • Lab: Baseline a load and identify bottlenecks
  • Lab: Tune a mapping/KM configuration
  • Lab: Compare before/after execution results

MODULE 10: END-TO-END REAL-WORLD ODI PROJECT

5 Hours | Capstone
  • Project architecture and requirements
  • Source-to-target data integration design
  • Topology and model setup
  • Mapping and KM implementation
  • Package/procedure/variable orchestration
  • Scenario and Load Plan creation
  • Scheduling and monitoring
  • Error handling and performance tuning
  • Deployment and implementation checklist
  • Lab: Build an end-to-end ODI solution
  • Lab: Execute the full data pipeline
  • Lab: Introduce and resolve a failure scenario
  • Lab: Tune the solution
  • Lab: Present implementation and troubleshooting approach

After this course, you can…

  • Explain ODI architecture, repositories, Studio, topology and runtime components
  • Create and manage models, datastores and source/target metadata
  • Develop mappings using the appropriate Knowledge Modules
  • Build packages, procedures and variable-driven workflows
  • Create scenarios, Load Plans and schedules, and run them through agents
  • Monitor sessions, diagnose failures and apply restart/recovery
  • Apply performance optimization and advanced design practices
  • Implement and troubleshoot an end-to-end ODI solution

Is this for you?

Developers ETL / Data Integration Pros Data Engineers Technical Team Members

Whether you build the integrations, schedule them or support them in production, the course covers the full lifecycle. Basic SQL and database knowledge will help you get the most out of it.

Not sure? Book a free 1:1 profile evaluation

Course at a glance

40
Hours of training
10
Modules
20
Sessions × 2 hrs
1
Capstone project

Enroll

Start Your ODI Journey

Tell us a little about yourself and our team will reach out with batch dates, fees and enrollment options.

  • Upcoming batch dates & timings
  • Fees and enrollment options
  • Guidance on whether the course fits your profile

Contact Sales

We reply with batch & pricing info.

FAQ

Common Questions

What is Oracle Data Integrator?
ODI is Oracle's data integration platform. It uses an ELT approach, pushing transformations down to the source or target database via Knowledge Modules, to move and transform data across enterprise systems.
Who is this training for?
Developers, ETL/data integration professionals, data engineers and technical team members who want to develop, administer, monitor, troubleshoot and tune ODI solutions.
What is the duration and format?
40 hours, delivered as 20 sessions of 2 hours each (or equivalent scheduling). Contact our team for the exact timings of the upcoming batch.
How is the course delivered?
Through concepts, live demos, guided hands-on labs, project scenarios and troubleshooting exercises, so you apply every topic immediately.
Are there labs and a project?
Yes. Every module has practical exercises with a working ODI deliverable, and the course ends with a 5-hour end-to-end project covering design, build, scheduling, monitoring, failure recovery and tuning.
Will I learn troubleshooting and tuning?
Yes. You will troubleshoot a deliberately failed load, perform restart/recovery, baseline a load, identify bottlenecks, tune a mapping/KM configuration and compare before/after results.
Do I need prior ETL experience?
The course starts with ODI fundamentals and architecture. Basic SQL and database knowledge will help. Not sure? Book a free strategy call and we will advise you.
How do I get fees and batch dates?
Fill in the Contact Sales form or download the syllabus, and our team will share batch dates, fees and enrollment options.

Ready to Become an ODI Expert?

Seats are limited for the next batch.

Book Strategy Call