Hyperion ODI Consultant (Hyderabad)

Hyperion ODI Consultant (Hyderabad)

16 Nov
|
Ascendion
|
Hyderabad

16 Nov

Ascendion

Hyderabad

About the Role
*
* We are seeking a Senior ODI and PL/SQL Integration Specialist to design, build, and maintain data integration pipelines supporting an enterprise Oracle EPM environment. This role is responsible for architecting robust ETL processes, writing complex PL/SQL procedures, and ensuring seamless data flows between legacy databases, staging environments, and downstream EPM applications. Job Title Senior ODI and PL/SQL Integration Specialist. Responsibilities
• Design, build, and support complex ODI packages, interfaces, mappings, procedures, and load plans.
• Write, optimize, and debug complex Oracle SQL queries, PL/SQL stored procedures, functions, triggers, and cursors for ETL data staging and transformation.
• Maintain and enhance data integration flows connecting legacy source systems and databases to Oracle EPM modules, including Essbase, Planning, HFM, and FDM or FDMEE.
• Perform deep-dive performance tuning on long-running SQL and PL/SQL scripts, database queries, and ODI integration jobs.
• Monitor automated batch loads, troubleshoot integration failures, and participate in technical on-call rotations to support month-end close operations. Required Skills




• 8+ years of hands-on experience in Oracle PL/SQL development and ODI implementation.
• Deep experience in setting up ODI topologies, Master and Work Repositories, Knowledge Modules, and load plan automation.
• Proven track record of supporting data pipelines that integrate with Oracle EPM or Hyperion stacks, including Essbase, HFM, or Planning.
• Solid capability in database troubleshooting, performance tuning, including execution plans and indexing strategies, and data validation.
• Familiarity with Linux or Unix shell scripting and automated scheduling tools. Desirable Skills
• Experience with Oracle EPM integration best practices.
• Exposure to production support and incident management processes.
• Knowledge of data reconciliation and control framework design.
• Experience working in month-end or financial close environments. Education Qualification
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• Equivalent practical experience in Oracle data integration and PL/SQL development may also be considered.

📌 Hyperion ODI Consultant (Hyderabad)
🏢 Ascendion
📍 Hyderabad

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: hyperion odi consultant (hyderabad) / hyderabad

Subscribe to this job alert:

Get the latest job offers by email for: hyperion odi consultant (hyderabad) / hyderabad