Oracle Data Integration Training

SKU: 1059
11 Lesson
|
30 Hours
igmGuru offers best Oracle Data Integration (ODI) Course worldwide. Our training program covers essential key topics such as ODI basics, data mapping, integration, automation and many more. The course content of our Oracle Data Integrator online training is created by industry experts, having 15+ years of experience. Our training program is aligned with latest Oracle Data Integration 12c Essentials (1Z0-448) exam.
Enroll Now
Oracle Data Integration Training

Oracle Data Integration Training Overview

Prerequisites

  • Basic Knowledge of SQL
  • Familiarity with Database
  • Understanding of Data Integration / ETL Concepts

What You Will Learn

  • Key use cases and architectural components
  • Creating Master and Work Repositories
  • Configuring connections between repositories
  • Understanding Master/Work Repositories
  • Building Projects and Interfaces (Mappings)
  • Importing and selecting appropriate KMs
  • Defining Datastores and Models
  • Designing transformation flows with KMs
  • Generating, executing & scheduling Scenarios

Key Features

Oracle Data Integrator Training Modules

1. Overview of ETL vs. ELT paradigms
2. Introduction to Oracle Data Integrator
3. Key use cases and architectural components
1. ODI installation walkthrough
2. Creating Master and Work Repositories
3. Configuring connections between repositories
1. Overview of ODI Studio: Designer, Operator, Topology, Security
2. Understanding Master/Work Repositories
3. Physical vs. Logical architecture
4. Data Servers, Schemas, Agents, Contexts configuration
1. Reverse-engineering source/target metadata
2. Defining Datastores and Models
3. Building Projects and Interfaces (Mappings)
4. Use of joins, filters, expressions, lookups, set ops
1. Overview: LKM, IKM, CKM, JKM, SKM
2. Importing and selecting appropriate KMs
3. Designing transformation flows with KMs
1. SCD types (1, 2, 3)
2. Variables, Sequences, User‑Defined Functions
3. Incorporating procedures, global variables
4. Advanced expressions and transformations
1. Building and orchestrating Packages
2. Creating reusable Load Plans
3. Generating, executing & scheduling Scenarios
4. Monitoring execution via Operator
1. Security Navigator fundamentals
2. Managing Users, Roles, Profiles, and Objects
3. Securing Repositories and Agents
1. Setting up and tuning ODI Agents (Standalone/JEE)
2. Monitoring sessions and logs
3. Troubleshooting workflows and error recovery
1. Optimizing Knowledge Modules
2. Tuning mappings and SQL performance
3. Error-handling strategies and logging
1. Creating custom KM components (substitution methods, Java)
2. ODI automation using Groovy scripts
3. Working with complex file formats
4. Integrating CI/CD and SOA patterns
5. Integrating with Oracle GoldenGate (overview)
Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)
+91 7240740740 (India)
Drop Us a Query
Fields marked * are mandatory

Request For Live Demo Class

ODI Training Course Fees

Online Class Room Program

US $ 799.00
100% Money Back Guarantee
  • Duration : 30 Hrs
  • Plus Self Paced

Classes Starting From

  • Fast Track Batch 01 Jun 2026
  • Weekday Batch 01 Jun 2026
  • Weekend Batch 06 Jun 2026

Corporate Training

Corporate Training
  • Customized Training Delivery Model
  • Flexible Training Schedule Options
  • Industry Experienced Trainers
  • 24x7 Support
Contact Us

Trusted By Top Companies Worldwide

MITSUBISHI
Emirates
BECHTEL
Tech Mahindra
Techmill
metacube
Fareportal
Trelleborg
Capgemini
AU Small Finance Bank
United Nations
Inter Mid
SoftFlex
align
utthunga
Rimini Street
EJADAH
Yash Technologies
suyati
Hettich
APPCINO

Want to know Today's Offer

X

Oracle Data Integration Certification Exam

The Official Oracle Data Integration 12c Essentials (1Z0-448) exam details are below:

Exam Format:

  • Duration: 120 Minutes
  • Number of Questions: 79
  • Passing Score: 71%
  • Type: Multiple Choice
  • Mode: Proctored Online

Exam Cost:

Exam cost is around $245, plus applicable taxes.

Oracle Data Integration Certification Exam

Reviews

Login
Forgot Password?
Don't have an account?
Sign Up

Our Alumni works at

HCL
FAI
YOKAGAWA
Tech Mahindra
SOCIETE GENERALE
SAMSUNG
EMIDS
DHL
FedEx
PayPal
BOSCH
asian paints
MICRO FOCUS
hgs
eClerx
Nasdaq
Persistent
CSS CORP

Explore Other Courses

×

Your Shopping Cart


Your shopping cart is empty.
Checkout

View Cart

Continue Shopping