We’re Hiring | Oracle EPM / BI Consultant

Location: Bangalore / Chennai / Hyderabad

Work Mode: Hybrid

Employment Type: Full-Time / Permanent

Qualification: Bachelor’s / Master’s in Computer Science, Engineering, or a related field

Experience: 15+ Years

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 have strong Finance & Controlling domain knowledge, excellent analytical and troubleshooting skills, and the ability to work effectively with both business and technical stakeholders.

Key Technical Skills

Oracle EPM / Hyperion

Hyperion Planning – On-Premise and/or Cloud

Essbase Administration & Development

Metadata & Dimension Management

Business Rules & Calculation Scripts

Data Loading & Smart View

Oracle Data Integrator (ODI)

Mappings, Packages, Variables & Scenarios

ODI Monitoring & Troubleshooting

Data Integration Process Development & Maintenance

Reporting & Analytics

Oracle Analytics Server (OAS)

Dashboard & Report Development

Data Analysis & Reporting Support

Database

Advanced SQL

Strong PL/SQL

Oracle Database

Query Optimization & Performance Tuning

Business Skills

Robust understanding of Finance, Budgeting,



Forecasting & Management Reporting

Ability to analyze business requirements and propose functional/technical solutions

Strong analytical and problem-solving skills

Experience supporting business users during budgeting and forecasting cycles

Ability to identify and troubleshoot data discrepancies

Strong communication skills with both Finance and IT teams

Key Responsibilities

Support and maintain Oracle EPM & BI applications

Analyze and resolve functional and technical issues

- Develop and enhance ODI integration processes
- Design and optimize SQL/PLSQL components
- Develop and maintain Essbase calculation scripts and business rules
- Support Finance & Controlling users
- Develop and maintain OAS reporting and analytics solutions
- Participate in enhancement and continuous improvement initiatives
- Ideal Profile
- 15+ years of overall experience
- Strong experience in Oracle EPM / BI environments
- Hands-on experience with
- Hyperion Planning, Essbase, ODI, OAS, SQL & PL/SQL

Strong Finance & Controlling business knowledge Excellent analytical and troubleshooting abilities Ability to effectively bridge Business & IT teams Autonomous, proactive, and solution-oriented Work Location: Hybrid remote in Bengaluru, Karnataka 560000

📌 Oracle EPM (Bengaluru)
🏢 Testunity
📍 Bengaluru