Senior Oracle ODI Developer

SystemBender • ernakulam, kerala, in

1 day ago

Job description

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 in ODI interfaces, procedures, packages, load plans, and scenarios.

Experience with SQL / 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 with Oracle Integration Cloud (OIC), SOA, or MuleSoft is an advantage.

Strong problem-solving, analytical, and communication skills.

Senior Odi Developer • ernakulam, kerala, in