Hyperion ODI Consultant - Essbase

Forward Eye Technologies; Pune District; On-site; INR 1,200,000 - 2,600,000; Full time

Job summary

Forward Eye Technologies invites an experienced ODI Consultant to design, develop, and implement data integration within Hyperion EPM, including ODI workflows and ETL pipelines for Planning and Essbase.

The role emphasizes data accuracy, collaboration with finance and IT, and driving high-performance ODI processes across systems.

Qualifications

• 5+ years of experience in ODI and Hyperion EPM solutions.
• Expertise in ETL, data mappings, transformations, and ODI workflows.
• Hands-on experience with Hyperion Planning and Essbase.
• Strong SQL/PLSQL skills and relational databases knowledge.
• Knowledge of data warehousing concepts and data integration projects.
• Experience in tuning ODI performance and ensuring data integrity.
• Excellent problem-solving, communication, and teamwork.

Responsibilities

• Design, develop, and implement ODI data integration within Hyperion.
• Create ETL pipelines to load data into Hyperion Planning and Essbase.
• Develop data mappings, transformations, and ODI workflows.
• Optimize ODI processes for performance and data integrity.
• Coordinate with Hyperion admins and data architects on best practices.
• Monitor and troubleshoot ODI data integration, including errors.
• Document ODI workflows, mappings, and configurations.
• Support ongoing development and data integration enhancements.
• Ensure data quality, accuracy, and consistency with requirements.
• Collaborate with finance, IT, and business units for solutions.

Skills

ODI & Hyperion EPM

ETL pipelines

Hyperion Planning

Essbase

SQL / PL/SQL

Data warehousing concepts

ODI performance tuning

Troubleshooting

Documentation

Communication with stakeholders

Tools

Oracle ODI

Hyperion EPM

Hyperion Planning

Essbase

Oracle / SQL Server

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