Oracle Data Integrator Developer

Key Responsibilities

Design and develop ODI interfaces, packages, scenarios, and load plans.

Work with stakeholders to gather requirements and translate them into ODI solutions.

Implement mappings and transformations to load data from heterogeneous sources (RDBMS, flat files, cloud, REST/SOAP APIs).

Optimize ETL/ELT processes for performance and scalability.

Implement and maintain custom Knowledge Modules (KM) as needed.

Integrate ODI with Oracle DB, GoldenGate, SOA, OIC, and cloud platforms.

Conduct unit testing, system integration testing, and support UAT.

Work with ODI Admins to deploy, monitor, and tune integration jobs.

Mentor junior developers and review code for quality assurance.

Required Skills

Strong expertise inODI interfaces, procedures, packages, load plans, and scenarios.

Experience withSQL/PLSQL, Oracle DB, and performance tuning.

Good understanding of data warehouse design, star/snowflake schema, and ETL/ELT best practices.

Knowledge of custom KMs development and API integration (REST/SOAP).

Experience withOracle Integration Cloud (OIC), SOA,or MuleSoft is an advantage.

Strong problem-solving, analytical, and communication skills.