Oracle EPM / BI Consultant

We are looking for an experienced Oracle EPM / BI Consultant with strong expertise in Hyperion Planning, Essbase, ODI, OAS, Oracle SQL, and PL/SQL to support budgeting, forecasting, reporting, and management control applications.

Key Responsibilities:

• Support and maintain Oracle EPM, Hyperion Planning, Essbase, ODI, and OAS applications.
• Analyze and resolve functional and technical issues.
• Develop and enhance ODI integrations, mappings, packages, and scenarios.
• Design, optimize, and troubleshoot SQL and PL/SQL components.
• Develop and maintain Essbase calculation scripts, business rules, and metadata management.
• Support Finance users during budgeting, forecasting, and reporting cycles.
• Build and maintain dashboards and reports using Oracle Analytics Server (OAS).
• Identify root causes of data discrepancies and implement solutions.

Required Skills:

• 5+ years of Oracle EPM / Hyperion experience.
• Strong experience with Hyperion Planning (On-Premise and/or Cloud).
• Hands-on expertise in Essbase administration and development.
• Strong Oracle Data Integrator (ODI) experience.
• Experience with Oracle Analytics Server (OAS).
• Advanced SQL and PL/SQL development skills.
• Oracle Database knowledge with performance tuning experience.
• Strong understanding of Finance, Budgeting, Forecasting, and Management Reporting processes.
• Excellent analytical, troubleshooting, and communication skills.

Preferred:

• Ability to work closely with both Business and IT teams.
• Experience supporting Finance and Controlling functions.
• Proactive and self-driven approach to problem-solving.

Pay: Up to ₹3,500,000.00 per year

Work Location: Hybrid remote in Bengaluru, Karnataka