Lead ODI Developer

Oracle Data Integrator (ODI) Developer

Key Responsibilities

• Design, develop, and maintain

  ODI interfaces, packages, load plans, scenarios, and variables

• Work extensively with

  ODI core components

  : Designer, Topology, Operator, Security, and Agents
• Customize and utilize

  Knowledge Modules (KMs)

  including SQL KM and Java KM
• Manage

  ODI Master and Work Repositories

• Implement

  Change Data Capture (CDC)

  and journalizing for incremental data loads
• Perform

  performance tuning

  of ODI mappings, SQL queries, and ETL jobs
• Handle

  error handling, logging, auditing, and job monitoring

• Develop and optimize

  complex SQL and PL/SQL

  (procedures, functions, triggers)
• Integrate data from multiple sources such as

  Oracle DB, SQL Server, Flat Files, XML, APIs

• Collaborate with data architects, BI teams, and business stakeholders to meet reporting and analytics needs
• Support deployments, troubleshooting, and production issues

Required Skills & Expertise

Oracle Data Integrator (ODI)

• Strong hands-on experience with

  ODI development and administration

• Deep understanding of

  Knowledge Modules customization

• Experience with

  ODI Agents

  and scheduling

• Databases & SQL

• Strong expertise in

  Oracle Database

• Advanced

  SQL & PL/SQL

  skills
• SQL performance tuning using

  EXPLAIN PLAN

Data Warehousing

• Strong understanding of

  OLAP vs OLTP

• Experience in

  Dimensional Modelling

  (Star & Snowflake Schemas)
• Hands-on experience with

  Fact and Dimension tables

Scripting & Automation

• Experience with

  Shell Scripting and/or Python

  for automation and monitoring

BI & Analytics (Plus)

• Exposure to

  OBIEE / Oracle BI

  is an added advantage

Cloud (Good to Have)

• Exposure to

  OCI, AWS, or Azure

Good to Have

• Experience working in

  large-scale data environments

• Strong analytical and problem-solving skills
• Ability to work independently and collaborate across teams