Role & responsibilities

We are seeking a highly skilled Oracle ODI & Analytics Developer with strong expertise in Oracle Data Integrator

(ODI 12c/14c), Semantic Modeling (RPD), and SQL/PLSQL development. The ideal candidate will be responsible for

designing, developing, and supporting enterprise data integration, reporting, and analytics solutions across

Oracle's data and analytics ecosystem. Experience in Fusion Data Intelligence (FDI), Oracle Analytics Cloud (OAC),

and Oracle Cloud Infrastructure (OCI) is highly desirable.

Design, develop, and maintain ETL/ELT processes using Oracle Data Integrator (ODI 12c/14c).

Build and optimize complex SQL and PL/SQL scripts for data transformation, validation, and performance tuning.

Develop and maintain Semantic Models (RPD), including semantic model extensions, metadata modeling, and

subject area design.

Design and develop reporting and analytics solutions using Fusion Data Intelligence (FDI) and Oracle Analytics

Cloud (OAC).

Work with OCI-based analytics and data integration components where applicable.





Collaborate with business stakeholders to gather reporting and analytics requirements.

Perform data mapping, data quality validation, and reconciliation activities.

Troubleshoot production issues and implement performance improvements.

Create and maintain technical design documents, deployment guides, and operational runbooks.

Support release management, testing, and production deployments.

Mandatory Skills (Must Have)

1. Oracle Data Integration

Solid hands-on experience with Oracle Data Integrator (ODI 12c/14c).

Expertise in ETL/ELT design, mappings, packages, procedures, load plans, and troubleshooting.

2. Semantic Modeling

Strong experience with Oracle BI Repository (RPD) and Semantic Model development.

Experience with Semantic Model Extensions and dimensional modeling concepts.

3. Database Development

Advanced proficiency in SQL and PL/SQL.

Experience in query optimization, performance tuning, and database design.

📌 ODI Developer (Bengaluru)
🏢 SP Software
📍 Bengaluru