Role & responsibilities

Job Title: Oracle ODI / Oracle Analytics Developer
Experience: 8+ Years(Relevant) Overall 12+ years
Location: Bangalore
Employment Type: (C2H)

Full time with Sp software hiring for Product based MNS

Initial 3 months all 5days WFO, then Hybrid)

Job Summary
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.
Candidates with prior experience in technical training, mentoring, or enabling teams on ODI, Semantic Modeling, and Oracle Analytics technologies will be considered favorably.

Key Responsibilities
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

📌 Senior Principal Software Engineer (Bengaluru)
🏢 SP Software
📍 Bengaluru