Oracle Epm Consultant

Esscorp Tech; Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Esscorp Tech in Bengaluru, India, seeks an experienced Oracle EPM/BI specialist to support and enhance EPM and BI applications. The role requires strong knowledge of Hyperion Planning, Essbase, ODI, and OAS, plus advanced SQL/PLSQL skills to design and optimize data models.

You will collaborate with business and IT teams to deliver robust reporting, analytics, and data integration solutions, contributing to continuous improvement across finance and operations.

Qualifications

• 5+ years of experience in Oracle EPM / BI environments.
• Proven experience with Hyperion Planning, Essbase, ODI, OAS, Oracle SQL, and PL/SQL.
• Strong communication with business and technical teams.
• Analytical and problem-solving abilities; autonomous and proactive.

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

Strong communication skills

Analytical and problem-solving

Autonomous and proactive

Tools

Hyperion Planning

Essbase

Oracle Data Integrator (ODI)

Oracle Analytics Server (OAS)

SQL

PL/SQL

Oracle Database

Job description

Locations: Bengaluru/Hyderabad/Chennai

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