Description

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.

Qualifications:
Nice to Have – Training & Enablement Experience

• Candidates who have demonstrated experience in training, mentoring, or enabling technical teams will be highly preferred.

Examples include:

• Conducting formal training sessions/workshops on ODI, RPD/Semantic Modeling, SQL, and PL/SQL.
• Developing training materials, technical documentation, and knowledge-sharing content.
• Mentoring junior developers and analytics engineers.
• Leading enablement programs or establishing best practices for Oracle Analytics and Data Integration technologies.
• Supporting onboarding and skill development initiatives within project teams.
• This experience would be especially valuable in helping the broader team accelerate adoption, improve knowledge transfer, and build long-term technical capability.

Mandatory Skills (Must Have)

Oracle Data Integration

• Strong hands-on experience with Oracle Data Integrator (ODI 12c/14c).
• Expertise in ETL/ELT design, mappings, packages, procedures, load plans, and troubleshooting.

Semantic Modeling

• Strong experience with Oracle BI Repository (RPD) and Semantic Model development.
• Experience with Semantic Model Extensions and dimensional modeling concepts.

Database Development

• Advanced proficiency in SQL and PL/SQL.
• Experience in query optimization, performance tuning, and database design.

Preferred Skills (Good to Have)

• Fusion Data Intelligence (FDI) development and administration.
• Oracle Analytics Cloud (OAC) reporting and dashboard development.
• Knowledge of Oracle Cloud Infrastructure (OCI) services.
• Experience with Python and Shell Scripting for automation.
• Knowledge of Oracle Fusion SaaS data models and integrations.
• Experience working in Agile delivery environments.

Required Experience

• 8+ years of experience in Oracle Data & Analytics technologies.
• Proven hands-on experience in:
  • Oracle Data Integrator (ODI 12c/14c)
  • RPD / Semantic Modeling
  • SQL & PL/SQL Development
• 8+ years of strong hands-on experience with Oracle Data Integrator (ODI 12c/14c).
• Specializing in ETL/ELT development, Oracle BI Repository (RPD) and Semantic Model design, with advanced expertise in SQL and PL/SQL programming.
• Experience with enterprise-scale data integration and reporting implementations

Key Skills

Education

Bachelor's degree