Oracle EPM

ob Title: Oracle EPM / BI Consultant
Experience: 15+ years of experience
Job location: Bangalore / Chennai / Hyderabad
Work Type: Hybrid
Employment Type: Full Time / Permanent
Qualification: Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.

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.

• 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.

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.

• Strong experience with Oracle Data Integrator (ODI).

• Development and maintenance of mappings, packages, variables, and scenarios.

• Monitoring and troubleshooting of ODI data integration processes.

• Strong experience with Oracle Analytics Server (OAS).

• Dashboard and reporting development.

• Data analysis and reporting support.

• Advanced SQL skills.

• Strong PL/SQL development skills.

• Oracle Database expertise.

• Query optimization and performance tuning.

• 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.

• 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.

• 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

Work Location: Hybrid remote in Bangalore City, Bengaluru, Karnataka