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 Dev Ops-based delivery models.
• Experience with application migration and release management across EPM environments.

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 Free Form, 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,…