Oracle Analytics Cloud (OAC) Consultant — (OBIEE Migration & Analytics)

Role Overview

We’re looking for a mid-level Oracle Analytics Cloud (OAC) Consultant with hands-on experience in OBIEE and a proven track record of delivering modern analytics on OAC. The role involves migrating legacy OBIEE reports and RPDs to OAC, building scalable semantic models, enabling self-service data visualization, and optimizing performance and security in cloud environments.

You’ll partner with business stakeholders, data engineers, and project managers to deliver high-quality dashboards, governed data models, and automated data pipelines on Oracle Cloud Infrastructure (OCI).

Key Responsibilities

OAC Development & Modeling

- Build and enhance datasets, semantic models (Semantic Modeler/RPD), dashboards, and visualizations in OAC DV.

- Design and implement row-level and object-level security, usage tracking, and catalog governance.

- Create BI Publisher reports, schedules, and bursting for operational reporting.

OBIEE → OAC Migration

- Migrate OBIEE RPDs, catalog objects, and prompts to OAC; modernize dashboards in DV while maintaining business logic.

- Remediate functional gaps (narratives, custom scripts) and optimize for cloud scalability.

- Use BAR exports/imports, data model conversion tools, and catalog migration best practices.





Required Qualifications & Skills

- 5–9 years in analytics focused on Oracle OAC/OBIEE (minimum 2–4 years in OAC).

- Strong experience in semantic modeling (RPD or OAC Semantic Modeler), joins, hierarchies, time series, calculations, and security.

- Hands-on experience with OAC DV, BI Publisher, and Catalog; ability to design clean, user-centric dashboards.

- Proficiency in SQL (Oracle), performance tuning, and data sourcing (ADW/Autonomous DB, Oracle DB, Excel/CSV, REST).

- Experience migrating from OBIEE 11g/12c to OAC, including RPD and catalog objects.

- Familiarity with OCI services relevant to OAC (Network, Data Gateway, IDCS).

- Solid analytical thinking, problem-solving, and communication skills.

Nice-to-Have (Preferred)

- Experience with ODI, GoldenGate, or Oracle Data Integrator for ETL/ELT.

- Knowledge of Essbase or OAC Enterprise features (if applicable).

- Exposure to CI/CD for analytics (e.g., versioning models, automating BAR deployments).

- Visualization best practices (design standards, accessibility, storytelling, KPI design).

- Scripting (Python/SQL) for data prep, REST API usage for admin/automation.

- Experience with Autonomous Data Warehouse (ADW) and materialized views for performance.

📌 Oracle Analytics Cloud Consultant – OBIEE Migration Specialist (Noida)
🏢 Topcoder
📍 Noida