Sr Specialized IT Consultant (Hyperion Planning)

Description

• Design, update the existing integration solution to move data both ways between EPM Cloud and on-premises databases.
• Assess options and feasibility, integrate, and implement a solution on EPM Cloud with on-premises OBIEE and APEX applications for reporting and provisioning access, respectively.
• Assess and conduct performance tuning on integration model and process to ensure overnight ETL fits within a tight application maintenance window, with the consideration of future application and data growth.
• Document all new system integration process and design, deliver knowledge transfer sessions to EPM Application and Technical Team on the model design and process maintenance.

Experience and Skill Set Requirements

• Expert level knowledge in Hyperion Planning and Enterprise Performance Management. 15%
• Leadership experience in designing and implementing an integrated solution that brings data both ways between EPM Cloud and on-premises Oracle EBS application and Reporting databases. - 20%
• Experience with middleware and gateways include middle, application, and database tiers. - 10%
• Knowledge and experience integrating EPM Cloud solution with external reporting solution, such as on-premises OBIEE and Oracle APEX applications. - 15%
• Expert level knowledge of Oracle 12c/19c database administration, maintenance, database performance tuning, sizing, and capacity planning. - 10%
• Experience preparing conceptual, logical and/or physical processes and data models that ITS can use to provision hardware requirements and enable system integration using webservices, REST technologies between on-premises and applications on the Cloud. - 10%
• Knowledge of UNIX OS (Operating System) and Linux OS, utilities, shell scripting. - 10%
• Ability to work with EPM Application and Technical Teams to lead integration design discussions and integrate the EPM Cloud Solution within the existing applications and OPS footprint. - 10%