Hyperion Solution Designer 7203-1410

HM Note: This hybrid role is three (3) days in office.

Description:

• Design update the existing integration solution to move data both ways between EPM Cloud and onpremises databases.
• Assess options and feasibility integrate and implement a solution on EPM Cloud with onpremises 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.

Skills

Experience and Skill Set Requirements

1. Expert level knowledge in Hyperion Planning and Enterprise Performance Management. 15%
2. Leadership experience in designing and implementing an integrated solution that brings data both ways between EPM Cloud and onpremises Oracle EBS application and Reporting databases. 20%
3. Experience with middleware and gateways include middle application and database tiers. 10%
4. Knowledge and experience integrating EPM Cloud solution with external reporting solution such as onpremises OBIEE and Oracle APEX applications. 15%
5. Expert level knowledge of Oracle 12c/19c database administration maintenance database performance tuning sizing and capacity planning. 10%
6. 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 onpremises and applications on the Cloud. 10%
7. Knowledge of UNIX OS (Operating System) and Linux OS utilities shell scripting. 10%
8. 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%

Must Haves:

• Expert level knowledge in Hyperion Planning and Enterprise Performance Management.
• Leadership experience in designing and implementing an integrated solution that brings data both ways between EPM Cloud and onpremises Oracle EBS application and Reporting databases
• Knowledge and experience integrating EPM Cloud solution with external reporting solution such as onpremises OBIEE and Oracle APEX applications. and nbsp;
• 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 onpremises and applications on the Cloud. and nbsp;

Nice to Have:

• Previous Public Sector
• IFIS OCI Hyperion