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
Robust 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
Solid 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 settings.
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

📌 Oracle Epm Consultant Bengaluru
🏢 ESSCORP TECH
📍 Bengaluru