Oracle EPM Consultant

Overview : We are seeking an experienced Oracle EPM Hyperion and ODI
professional with strong technical expertise in Oracle EPM Cloud, Hyperion
Planning, Essbase, EDMCS, Narrative Reporting, Oracle Data Integrator, and
enterprise data integrations.

The candidate will be responsible for designing, developing,
maintaining, supporting, and enhancing Oracle EPM applications and
integrations. The role requires strong analytical, troubleshooting, SQL,
metadata management, and stakeholder communication skills.

Experience Expectations

· Experience
working as a technical consultant or team member in Oracle EPM and/or Oracle
Data Integration projects.

· Experience
delivering technical solutions of moderate to high complexity.

· Experience
supporting production environments and resolving critical incidents.

· Experience
working directly with business users and stakeholders.

· Experience
with end-to-end development, testing, deployment, and production support
activities.

Preferred Qualifications

· Oracle
EPM Cloud certifications.

· Oracle
Data Integrator certifications.

· Experience
with Oracle Cloud Infrastructure (OCI).

· Experience
with enterprise financial planning and reporting processes.

· Experience
with Agile and DevOps-based delivery models.

· Experience
with application migration and release management across EPM environments.

Requirements

Key Responsibilities – Oracle EPM / Hyperion

· Work
closely with business stakeholders to analyze and clearly document business
requirements, processes, functional requirements, and business rules.

· Design,
develop, configure, test, and deploy solutions using Oracle EPM EPBCS, EPM
FreeForm, Hyperion Planning, Essbase, EDMCS, Narrative Reporting, and related
Oracle EPM technologies.

· Create
and maintain Planning forms, business rules, calculation scripts, task lists,
dashboards, reports, Smart View templates, and other EPM artifacts.

· Develop
and maintain Essbase calculation scripts, member formulas, allocations,
aggregations, and data load processes.

· Design
and develop EPM Automate scripts, MaxL scripts, shell scripts, and batch
scripts to automate operational and administrative activities.

· Develop
and maintain EPM integrations using Data Integration, Data Exchange, Data
Management, EPM Agents, and other Oracle integration capabilities.

· Configure
and maintain EDMCS applications, viewpoints, hierarchies, subscriptions,
validations, requests, and metadata integrations with EPBCS and other systems.

· Support
metadata management activities, including member creation, hierarchy
maintenance, validation, and metadata synchronization across source and target
systems.

· Troubleshoot
application, calculation, data load, metadata, integration, and reporting
issues.

· Support
production deployments, application migrations, release activities, and
post-production validation.

· Identify
opportunities for process automation and continuous improvement to improve
application stability, performance, and operational efficiency.

· Establish
and maintain data standards, naming conventions, consistent data definitions,
and data quality controls.

· Monitor
and audit data quality to ensure data is accurate, complete, consistent, and
reliable for operational and strategic decision-making.

· Assist
in resolving technical infrastructure, security, connectivity, and
environment-related issues.

Key Responsibilities – Oracle Data Integrator (ODI)

· Design,
develop, maintain, and support integrations using Oracle Data Integrator (ODI).

· Develop
and maintain ODI mappings, packages, scenarios, load plans, procedures, and
schedules.

· Analyze,
troubleshoot, and resolve ODI integration failures and performance issues.

· Develop
and optimize SQL and PL/SQL queries, procedures, and routines.

· Analyze
data and metadata-related issues involving source systems, staging
environments, and target applications.

· Design
and support integrations across multiple data sources and target systems,
including ERP systems, EPM applications, databases, flat files, and other
enterprise applications.

· Develop
and maintain data extraction, transformation, validation, and loading
processes.

· Support
integrations with downstream reporting and analytical applications such as
Mainframe systems, SAP, Business Objects, FMIS, Essbase, PBCS/EPBCS, and other
enterprise reporting platforms.

· Work with FDMEE, Data Integration, load rules, SQL routines, ODI,
and other technologies to support enterprise data

integration requirements.

· Perform
root cause analysis for data load, transformation, metadata, and integration
issues and implement permanent corrective actions.

Required Technical Skills: The candidate should have hands-on
experience with:

· Oracle
EPM EPBCS and EPM FreeForm

· Hyperion
Planning and Essbase

· Oracle
EDMCS

· Oracle
Narrative Reporting

· Oracle
Data Integration / Data Exchange / Data Management

· Oracle
Data Integrator (ODI)

· FDMEE
and EPM load rules

· EPM
Automate

· EPM
Agents

· MaxL
scripting

· Essbase
calculation scripts

· Business
Rules and Groovy Rules

· SQL
and PL/SQL

· SQL
Server and relational databases

· Metadata
management and hierarchy maintenance

· Data
integration and ETL processes

· Shell
scripting and batch scripting

Functional and Professional Skills:

· Strong
analytical and problem-solving skills.

· Ability
to analyze complex business and technical requirements.

· Strong
SQL query development and query optimization skills.

· Ability
to troubleshoot complex data, metadata, calculation, and integration issues.

· Strong
attention to detail and commitment to data quality.

· Ability
to communicate technical concepts effectively to both technical and
non-technical stakeholders.

· Ability
to work independently while also collaborating effectively within a team.

· Strong
ownership, accountability, and delivery orientation.

· Ability
to manage multiple priorities in a fast-paced consulting or support
environment.