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