AS

Hyperion ODI Consultant

ascendion
Hyderabad Posted 17 Nov 2026
FULL TIME
Oracle Sql
Unix Shell Scripting
Odi
Essbase
Hfm
+4 more

Job Description

About the Role**

We are looking for a Senior ODI and PL/SQL Integration Specialist to design, build, and maintain data integration pipelines for an enterprise Oracle EPM landscape. In this role, you will architect reliable ETL solutions, develop advanced PL/SQL logic, and ensure accurate, uninterrupted data movement between legacy systems, staging environments, and downstream Oracle EPM applications.

**Job Title**

Senior ODI and PL/SQL Integration Specialist.

**Responsibilities**

  • Design, develop, and provide ongoing support for sophisticated ODI packages, interfaces, mappings, procedures, and load plans.
  • Write, optimize, and troubleshoot complex Oracle SQL queries, PL/SQL stored procedures, functions, triggers, and cursors to support ETL data staging and transformation.
  • Support and improve data integration workflows that connect legacy source databases and systems to Oracle EPM modules, including Essbase, Planning, HFM, and FDM or FDMEE.
  • Conduct in-depth performance tuning for long-running SQL and PL/SQL scripts, database queries, and ODI integration jobs.
  • Oversee automated batch loads, investigate and resolve integration issues, and take part in technical on-call rotations to help support month-end close activities.

**Required Skills**

  • 8+ years of practical experience in Oracle PL/SQL development and ODI implementation.
  • Extensive experience configuring ODI topologies, Master and Work Repositories, Knowledge Modules, and automated load plan execution.
  • Demonstrated experience delivering data pipelines that connect with Oracle EPM or Hyperion environments, including Essbase, HFM, or Planning.
  • Strong skills in database troubleshooting and performance tuning, including execution plan review, indexing strategies, and comprehensive data validation.
  • Familiarity with Linux or Unix shell scripting and automated scheduling tools.

**Desirable Skills**

  • Experience applying Oracle EPM integration best practices.
  • Experience with production support and incident management procedures.
  • Knowledge of data reconciliation and control framework design.
  • Experience supporting month-end or financial close operations.

**Education Qualification**

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
  • Equivalent hands-on experience in Oracle data integration and PL/SQL development will also be considered.
foundit: Feeling underpaid? Find jobs that pay you what you are worth. Find jobsSponsored
Join WhatsApp Channel