Description

Design and maintain enterprise-scale Oracle data integration, semantic modeling, and analytics solutions.

This role is on-site.

Responsibilities

• Design and build ETL/ELT processes using Oracle Data Integrator (ODI 12c/14c).
• Develop and optimize complex SQL and PL/SQL scripts for data transformation and performance tuning.
• Build and maintain Semantic Models (RPD), including extensions and subject area design.
• Create reporting and analytics solutions using Fusion Data Intelligence (FDI) and Oracle Analytics Cloud (OAC).
• Troubleshoot production issues and implement performance improvements for data pipelines.

Required Skills

• 8+ years of hands-on experience with Oracle Data & Analytics technologies.
• Expertise in Oracle Data Integrator (ODI 12c/14c), including mappings, packages, and load plans.
• Strong experience with Oracle BI Repository (RPD) and Semantic Model development.
• Advanced proficiency in SQL and PL/SQL, including query optimization.
• Experience with enterprise-scale data integration and reporting implementations.

Preferred Skills

• Experience training, mentoring, or enabling technical teams on ODI, RPD, and SQL.
• Knowledge of Fusion Data Intelligence (FDI) development and administration.
• Familiarity with Oracle Cloud Infrastructure (OCI) services.

Key Skills

Education

Bachelor's degree