Job Title: Consultant | Oracle Analytics Cloud Service / FAW, ODI | Mumbai | Oracle

Job requisition ID :: 107887

Date: Jul 1, 2026

Location: Mumbai

Designation: Consultant

Entity: Deloitte Touche Tohmatsu India LLP

# Oracle Analytics Cloud/ OBIEE /OAC Consultant (3+ Years Experience)

## Job Summary

We are seeking an experienced Oracle Analytics Consultant with 3+ years of expertise in designing, developing, and implementing Oracle Analytics solutions. The ideal candidate should possess strong experience in Oracle Analytics Cloud (OAC), Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle BI Publisher, SQL, Oracle Database, and data warehousing concepts. The candidate will work closely with business stakeholders to deliver scalable reporting and analytics solutions.

## Key Responsibilities

* Design, develop, and maintain Oracle Analytics Cloud (OAC) dashboards, reports, and data visualizations.

* Develop and support OBIEE/OAS analyses, dashboards, KPIs, scorecards, and BI Publisher reports.

* Design and manage RPD repositories, including Physical, Business Model, and Presentation layers.

* Build subject areas, logical dimensions, hierarchies, and security models.

* Develop and optimize SQL queries for reporting and analytics.

* Perform data modeling and integrate multiple data sources into Oracle Analytics.

* Configure and manage Data Flows, Data Sets, Semantic Models, and Machine Learning features in OAC.

* Optimize report performance and troubleshoot production issues.

* Collaborate with business users to gather requirements and translate them into technical solutions.

* Perform impact analysis, unit testing, system integration testing, and production deployment.

* Support migration activities across Development, Test, UAT, and Production environments.

* Implement row-level security, application roles, and object-level security.

* Create technical documentation, deployment guides, and knowledge transfer documents.

* Mentor junior team members and conduct code reviews.

* Participate in Agile/Scrum ceremonies and collaborate with cross-functional teams.

## Required Skills

* 3+ years of experience in Oracle BI technologies.

* Strong experience with Oracle Analytics Cloud (OAC).

* Hands-on experience with OBIEE 11g/12c and/or Oracle Analytics Server (OAS).

* Expertise in Oracle BI Publisher.

* Strong knowledge of Oracle SQL and PL/SQL.

* Experience in Oracle Database.

* Strong understanding of data warehousing concepts and dimensional modeling (Star Schema/Snowflake Schema).

* Experience in RPD development and repository migration.

* Knowledge of Data Visualization, Data Flows, and Semantic Models.

* Experience with performance tuning and query optimization.

* Experience integrating REST APIs, Excel, CSV, and database sources.

* Familiarity with Oracle Cloud Infrastructure (OCI) is an advantage.

* Experience with Git, Jenkins, or CI/CD tools is desirable.

* Knowledge of ETL tools such as Oracle Data Integrator (ODI) or Informatica is preferred.

## Preferred Qualifications

* Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

* Oracle Analytics Cloud or Oracle BI certifications are preferred.

* Experience working in Agile environments.

## Soft Skills

* Strong analytical and problem-solving skills.

* Excellent communication and stakeholder management.

* Ability to work independently and lead technical discussions.

* Strong mentoring and team collaboration skills.

## Nice-to-Have

* Oracle Fusion Analytics Warehouse (FAW) experience.

* Oracle Autonomous Database.

* Oracle Cloud Infrastructure (OCI).

* Power BI or Tableau exposure.

* Python or Shell scripting knowledge.