- 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
- 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 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.