Hyperion Analyst

Job Overview

Job description

• You will be #LI-hybrid based in Hyderabad and reporting to manager.
• This is individual contributor (Non-Managerial) role
• Must have experience working on High-Availability and Load-Balanced EPM Infrastructure environments.
• Should possess analytical and development experience on Oracle EPM Hyperion Product suite, including Essbase, Planning, FDMEE, Financial reports, Hyperion Financial Management, DRM, Oracle Data Integrator.
• Familiarity with Oracle cloud products, such as EDMCS, FCCS, and EPBCS and migration from on-premise to EPM cloud.
• Support on-premise migration to EPM cloud, data integrations to cloud applications.
• Lead in the design, development, testing and implementation activities relating to project deliverables
• Expected to lead process improvement initiatives.
• Perform periodic maintenance such as loading, clearing and copying data in HFM
• Provide application production support, analyze, design, develop, code, and implement programs to support Hyperion/Business Intelligence systems.
• Ability to translate requirements to high quality set of technical requirements
• Experience with diverse source systems and relational databases in EPM and BI space
• Experience handling the windows and Unix batch scripting
• Support the EPM applications and work on enhancements in a distributed global environment
• Experience supporting the following Hyperion applications: Hyperion Financial Management, Hyperion Planning, Hyperion Financial Reports, Essbase, Hyperion Financial Data Management and EPM cloud
• Analyse and Manage the ELT process using ODI (12c) to support the Actual, Plan and Forecast processes for Sales Reporting and ensure data is available to Essbase for month end reporting.
• Define the rule files to manage the metadata and data load cube build processes using Hyperion Essbase
• Manage partitions and customized aggregations on the multidimensional Essbase cubes
• Experience handling the installation and configuration of Oracle EPM Hyperion products
• Must have excellent understanding of PSU's and CPU's patches in relation to the Hyperion and OAS Products.
• Familiarity with MAXL for automating the Essbase tasks and EPM automate for cloud applications
• Support EDMCS batch processing for the import and export operations
• Automation of windows batch scripts and Linux scripts for Hyperion applications
• Expected to assist and mentor less experienced team members.
• Expected to support and streamline daily Batch Jobs/scheduled jobs and automate the same.