Oracle EPM / BI Consultant

Test Unity; Bengaluru; Hybrid; INR 6,000,000 - 8,000,000; Full time

Job summary

Test Unity in Bengaluru is seeking an experienced Oracle EPM / BI Consultant to support budgeting, forecasting, reporting, and management control applications within an Oracle ecosystem.

The ideal candidate should combine strong business understanding with analytical and problem-solving skills and collaborate with Finance and IT stakeholders.

Qualifications

• Minimum 5 years of experience in Oracle EPM / BI environments.
• Proven experience with Hyperion Planning, Essbase, ODI, OAS, Oracle SQL, and PL/SQL.
• Strong communication skills and ability to work with business and technical teams.
• Autonomous and proactive professional.
• Experience in budgeting cycles, forecasting, and reporting processes.

Responsibilities

• Support and maintain Oracle EPM and BI applications.
• Analyze and resolve functional and technical issues.
• Develop and enhance ODI integration processes.
• Design and optimize SQL and PL/SQL components.
• Develop and maintain Essbase calculation scripts and business rules.
• Support Finance and Controlling users.
• Contribute to reporting and analytics solutions within OAS.
• Participate in enhancement and continuous improvement initiatives.

Skills

Finance & Controlling

Analytical mindset

Problem-solving

Communication

Autonomous

Tools

Oracle EPM / Hyperion

Hyperion Planning

Essbase

ODI

OAS

SQL

PL/SQL

Oracle DB

Job description

Job Title: Oracle EPM / BI Consultant

Experience: 15 years of experience

Job location: Bangalore / Chennai / Hyderabad

Work Type: Hybrid

We are looking for an experienced Oracle EPM / BI Consultant to support and enhance budgeting, forecasting, reporting, and management control applications within an Oracle ecosystem.

The ideal candidate should combine strong business understanding with excellent analytical and problem-solving skills and be able to interact effectively with both Finance and IT stakeholders.

Business Skills

• Strong understanding of Finance, Budgeting, Forecasting, and Management Reporting processes.
• Ability to analyze business requirements and propose functional and technical solutions.
• Strong analytical mindset and troubleshooting capabilities.
• Ability to support business users during budgeting cycles, forecasting exercises, and reporting activities.
• Ability to investigate and identify root causes of data discrepancies.

Technical Skills (Mandatory)

• Oracle EPM / Hyperion
• Strong experience with Hyperion Planning (On-Premise and/or Cloud).
• Good knowledge of Essbase administration and development.
• Metadata and dimension management.
• Business Rules and Calculation Scripts development.
• Data loading processes and Smart View.

Oracle Data Integration

• Strong experience with Oracle Data Integrator (ODI).
• Development and maintenance of mappings, packages, variables, and scenarios.
• Monitoring and troubleshooting of ODI data integration processes.

Reporting & Analytics

• Strong experience with Oracle Analytics Server (OAS).
• Dashboard and reporting development.
• Data analysis and reporting support.

Database

• Advanced SQL skills.
• Strong PL/SQL development skills.
• Oracle Database expertise.
• Query optimization and performance tuning.

Main Responsibilities

• Support and maintain Oracle EPM and BI applications.
• Analyze and resolve functional and technical issues.
• Develop and enhance ODI integration processes.
• Design and optimize SQL and PL/SQL components.
• Develop and maintain Essbase calculation scripts and business rules.
• Support Finance and Controlling users.
• Contribute to reporting and analytics solutions within OAS.
• Participate in enhancement and continuous improvement initiatives.

Profile

• Minimum 5 years of experience in Oracle EPM / BI environments.
• Proven experience with Hyperion Planning, Essbase, ODI, OAS, Oracle SQL, and PL/SQL.
• Strong communication skills and ability to work with business and technical teams.
• Excellent analytical and problem-solving abilities.
• Autonomous and proactive.

Key Skills

• Hyperion Planning & Essbase
• Hyperion EPM / Oracle EPM
• Advanced SQL
• ODI Expertise
• OAS Reporting & Analytics
• Strong Finance & Controlling Business Knowledge
• Excellent Analytical & Troubleshooting Skill
• Ability to bridge Business and IT teams