Hyperion ODI Consultant

AscendionHyderabad, TelanganaOn-siteFull-timeStaff, 8–12 yearsListed 1 hour ago

Apply now

About this role

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. - Strong 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.