Our client is seeking an Oracle EPM Developer with strong finance knowledge, and solution expertise to effectively integrate technology into their business environment to achieve client expected business results. The incumbent would be individually accountable for achieving results through own efforts.

QUALIFICATIONS AND CERTIFICATIONS:

• Bachelor's Degree in IT, IS or related field
• Enterprise Performance Management Certifications| Oracle Cloud Certifications | Oracle University

EXPERIENCE AND SKILLS:

• Minimum of 5 – 8 years in IT environment, with a focus on financial application development; understanding key integration points between business knowledge and process design skills is essential

TECHNICAL KNOWLEDGE:

• 5 – 8 years of hands-on experience with Hyperion Planning, Essbase development (including calculation scripting), and the broader Oracle EPM suite. Proven capability in designing, implementing, and supporting enterprise performance management solutions. (Non-negotiable)
• 5 – 8 years of experience in SQL development and data integration, with strong proficiency in managing complex data environments, optimising queries, and ensuring seamless data flow across systems
• Problem-Solving Skills: Ability to analyse complex issues and drive effective solutions
• Communication Skills: Excellent written and verbal communication, with the ability to convey technical information to non-technical stakeholders
• Time Management: Strong organisational skills and ability to prioritise tasks in a fast paced environment

PREFERRED EXPERIENCE:

• Experience working in financial services sectors, especially cost allocations and product fund accounting
• Previous experience in a similar Development Lead role within an Agile environment
• Previous experience in the “Group Finance” function of a financial services company
• Previous experience with “Oracle EPM application”

TECHNOLOGY STACK:

Core Skills

• Essbase Scripting – Advanced proficiency in developing and maintaining Essbase applications, including calculation scripts and automation
• SQL Scripting – Strong expertise in writing and optimising SQL queries for data extraction, transformation, and integration across complex environments
• Java JDK
• Jython

Platform and Infrastructure

• Windows Server
• WebLogic Server – Application server for EPM components
• Java Runtime Environment (JRE) – Required for EPM services
• Oracle Database – Backend data storage for metadata and transactional data

Oracle EPM Application Suite

• Foundation Services
• Core infrastructure for user provisioning, shared services, and lifecycle management
• Includes Workspace, Shared Services, and Lifecycle Management
• Essbase
• Multidimensional OLAP engine
• Supports complex calculations and fast data retrieval
• Used by Planning, Profitability, and Reporting modules
• Planning and Profitability
• Hyperion Planning: Budgeting and forecasting
• Profitability and Cost Management: Allocations and profitability analysis
• Financial Performance Management
• Hyperion Financial Management (HFM): Consolidation and reporting
• Financial Close Management: Task orchestration for close processes
• Account Reconciliation: Automates reconciliation workflows
• Financial Reporting
• Hyperion Financial Reporting: Pixel-perfect report generation
• Supports Essbase, Planning, and Profitability data sources
• Smart View for Office
• Excel-based interface for interacting with EPM data
• Supports ad hoc analysis, form submissions, and reporting
• Data Management
• Financial Data Quality Management Enterprise Edition (FDMEE)
• ETL tool for integrating source systems with EPM applications
• Supports mapping, validation, and transformation
• Data Integration (EPM Integration Agent)
• Master data management
• DRM (Data Relationship Management) or
• Enterprise Data Management Cloud (EDMCS) or
• EPMWare
• Analytics / Reporting apps
• Oracle Analytics Server (OAS)
• Microsoft Power BI