Hyperion ODI Consultant - Essbase

We are looking for an experienced Hyperion ODI Consultant to join our team, responsible for designing, developing, and implementing Oracle Data Integrator (ODI) solutions within the Hyperion EPM suite.

The ideal candidate will have in-depth knowledge of Hyperion Planning, Essbase, and Oracle Data Integrator (ODI) with experience in data integration, ETL processes, and data transformations.

This role will involve managing end-to-end data integration processes, ensuring data accuracy, and collaborating with various stakeholders to align integration solutions with business objectives.

Key Responsibilities :

• Design, develop, and implement ODI data integration processes within the Hyperion environment.

• Work with stakeholders to understand data requirements and develop effective ETL pipelines to load data into Hyperion Planning and Essbase.

• Develop data mappings, data transformations, and integration workflows using Oracle Data Integrator.

• Optimize ODI processes to ensure high performance and data integrity across systems.

• Coordinate with Hyperion administrators and data architects to implement data integration best practices.

• Monitor and troubleshoot ODI data integration processes, including error handling, data mapping issues, and performance bottlenecks.

• Create and maintain technical documentation for ODI workflows, data mappings, and integration configurations.

• Support ongoing development and enhancements for Hyperion data integration and transformation initiatives.

• Ensure data quality, accuracy, and consistency in accordance with business and technical requirements.

• Collaborate with cross-functional teams, including finance, IT, and other business units, to deliver comprehensive data solutions.

Required Skills and Experience :

• 5+ years of experience in Oracle Data Integrator (ODI) and Hyperion EPM solutions.

• Expertise in ETL processes, data mappings, transformations, and ODI workflow development.

• Hands-on experience with Hyperion Planning and Essbase.

• Strong SQL and PL/SQL skills, with a deep understanding of relational databases (Oracle, SQL Server).

• Knowledge of data warehousing concepts and experience in data integration projects.

• Experience in performance tuning and optimization of ODI processes.

• Excellent problem-solving and troubleshooting skills with a focus on data accuracy and integrity.

• Ability to work independently and collaboratively in a team environment.

• Strong communication skills to work with technical and non-technical stakeholders.

Preferred Skills :

• Oracle Data Integrator (ODI) certification.

• Knowledge of Hyperion Financial Management (HFM).

• Experience with cloud