Oracle Epm Consultant

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