ASascendion
Hyperion ODI Consultant
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**
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.
- 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.
- 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.
- 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.
