Oracle Analytics Cloud (OAC) Consultant

Job Overview

We are seeking an experienced Oracle Analytics Cloud (OAC) Consultant with strong expertise in Enterprise Performance Management (EPM). The ideal candidate will play a key role in designing, developing, and maintaining data analytics solutions while ensuring seamless integration between OAC and EPM platforms.

Key Responsibilities

• Develop dashboards, reports, and visualizations using Oracle Data Visualization (DV)
• Design and manage the OAC RPD model (Physical, BMM, and Presentation layers)
• Integrate OAC with Oracle EPM Cloud modules (Planning, FCCS)
• Translate business requirements into scalable analytics solutions
• Implement role-based security in OAC and EPM
• Optimize SQL queries with views, materialized views, and indexes
• Create KPIs, advanced calculations, and time series metrics
• Support ETL using Oracle Data Integrator (ODI)
• Troubleshoot issues, enhance performance, and document technical specs
• Provide end-user support and training

Required Skills & Qualifications

• Bachelor’s/Master’s in Computer Science, Engineering, or relevant field
• 7+ years in analytics / business intelligence
• Proficiency in:
• OAC RPD Development (Physical, BMM, Presentation)
• Oracle SQL & performance tuning
• OAC DV for data visualization
• Star schema modeling & DW concepts
• Logical columns, catalog folders
• Hierarchies (level-based & parent-child)
• Aggregation rules & time series logic
• OAC DV security setup & admin
• Good exposure to Oracle EPM Cloud (Planning, FCCS)
• Excellent communication & stakeholder management skills

Preferred / Nice to Have

• Oracle Certifications: OAC and/or EPM
• Experience with REST APIs for OAC/EPM integrations
• Knowledge of Power BI, Power Apps, Power Automate, and Snowflake

Interested?

Apply now or share your updated resume at 7418140598.

Job Type: Full-time

Pay: ₹2,000,000.00 - ₹2,500,000.00 per year

Application Question(s):

• How many years of experience you have in Business Intelligence/Analytics ?

Experience:

• Business intelligence: 7 years (Preferred)

Work Location: In person