Hyperion ODI Consultant - Essbase

Forward Eye Technologies; Dadri; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Forward Eye Technologies is seeking an experienced Hyperion ODI Consultant to design, develop, and implement ODI solutions within the Hyperion EPM suite. The role requires deep ODI, Hyperion Planning, and Essbase knowledge, plus strong ETL and data mapping skills to deliver robust data integration.

You will collaborate with finance and IT teams to ensure data accuracy, optimize ODI processes, and maintain comprehensive technical documentation while supporting ongoing enhancements.

Qualifications

• Minimum 5+ years of ODI and Hyperion EPM experience.
• Expertise in ETL, data mappings, and ODI workflow development.
• Hands-on with Hyperion Planning and Essbase.
• Strong SQL/PLSQL and relational DB knowledge (Oracle/SQL Server).
• Experience in data warehousing concepts and data integration projects.

Responsibilities

• Design, develop, and implement ODI data integration processes in Hyperion.
• Create ETL pipelines to load data into Hyperion Planning and Essbase.
• Develop data mappings, transformations, and integration workflows with ODI.
• Tune ODI processes for performance and data integrity.
• Document ODI workflows and configurations.

Skills

ODI

Hyperion EPM

ETL

SQL/PLSQL

Data warehousing

Data integration

Stakeholder communication

Independent worker

Tools

Oracle Data Integrator (ODI)

Hyperion Planning

Essbase

Job description

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

Location: Anywhere in /Multiple Locations - Delhi / NCR,Bangalore/Bengaluru,Hyderabad/Secunderabad,Chennai,Pune,Kolkata,Ahmedabad,Mumbai