Oracle EPM / BI Consultant

Job Title: Oracle EPM / BI Consultant
Experience: 8+ years of experience
Job location: Bangalore / Chennai
Position ID: J0626-2578
Work Type: Hybrid
Employment Type: Full Time / Permanent
Qualification: Bachelors or Masters 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.

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
• Advanced SQL
• ODI Expertise
• OAS Reporting & Analytics
• Strong Finance & Controlling Business Knowledge
• Excellent Analytical & Troubleshooting Skill
• Ability to bridge Business and IT teams