Oracle EPM Consultant

Job Description: OverviewWe are seeking an experienced Oracle EPM Hyperion and ODIprofessional with strong technical expertise in Oracle EPM Cloud, HyperionPlanning, Essbase, EDMCS, Narrative Reporting, Oracle Data Integrator, andenterprise data integrations. The candidate will be responsible for designing, developing, maintaining, supporting, and enhancing Oracle EPM applications andintegrations. The role requires strong analytical, troubleshooting, SQL, metadata management, and stakeholder communication skills. Experience ExpectationsExperienceworking as a technical consultant or team member in Oracle EPM and/or OracleData Integration projects. Experiencedelivering technical solutions of moderate to high complexity. Experiencesupporting production environments and resolving critical incidents. Experienceworking directly with business users and stakeholders. Experiencewith end-to-end development, testing, deployment, and production supportactivities.

Preferred Qualifications: OracleEPM Cloud certifications. OracleData Integrator certifications. Experiencewith Oracle Cloud Infrastructure (OCI). Experiencewith enterprise financial planning and reporting processes. Experiencewith Agile and DevOps-based delivery models. Experiencewith application migration and release management across EPM environments.

Requirements: Key Responsibilities – Oracle EPM / HyperionWorkclosely with business stakeholders to analyze and clearly document businessrequirements, processes, functional requirements, and business rules. Design, develop, configure, test, and deploy solutions using Oracle EPM EPBCS, EPMFreeForm, Hyperion Planning, Essbase, EDMCS, Narrative Reporting, and relatedOracle EPM technologies. Createand maintain Planning forms, business rules, calculation scripts, task lists, dashboards, reports, Smart View templates, and other EPM artifacts. Developand maintain Essbase calculation scripts, member formulas, allocations, aggregations, and data load processes. Designand develop EPM Automate scripts, MaxL scripts, shell scripts, and batchscripts to automate operational and administrative activities. Developand maintain EPM integrations using Data Integration, Data Exchange, Data Management, EPM Agents, and other Oracle integration capabilities. Configureand maintain EDMCS applications, viewpoints, hierarchies, subscriptions, validations, requests, and metadata integrations with EPBCS and other systems. Supportmetadata management activities, including member creation, hierarchymaintenance, validation, and metadata synchronization across source and targetsystems. Troubleshootapplication, calculation, data load, metadata, integration, and reportingissues. Supportproduction deployments, application migrations, release activities, andpost-production validation. Identifyopportunities for process automation and continuous improvement to improveapplication stability, performance, and operational efficiency. Establishand maintain data standards, naming conventions, consistent data definitions, and data quality controls. Monitorand audit data quality to ensure data is accurate, complete, consistent, andreliable for operational and strategic decision-making. Assistin resolving technical infrastructure, security, connectivity, andenvironment-related issues.

Key Responsibilities: Oracle Data Integrator (ODI) Design, develop, maintain, and support integrations using Oracle Data Integrator (ODI). Developand maintain ODI mappings, packages, scenarios, load plans, procedures, andschedules. Analyze, troubleshoot, and resolve ODI integration failures and performance issues. Developand optimize SQL and PL/SQL queries, procedures, and routines. Analyzedata and metadata-related issues involving source systems, stagingenvironments, and target applications. Designand support integrations across multiple data sources and target systems, including ERP systems, EPM applications, databases, flat files, and otherenterprise applications. Developand maintain data extraction, transformation, validation, and loadingprocesses. Supportintegrations with downstream reporting and analytical applications such asMainframe systems, SAP, Business Objects, FMIS, Essbase, PBCS/EPBCS, and otherenterprise reporting platforms. Work with FDMEE, Data Integration, load rules, SQL routines, ODI, and other technologies to support enterprise data integration requirements. Performroot cause analysis for data load, transformation, metadata, and integrationissues and implement permanent corrective actions. Required Technical SkillsOracleEPM EPBCS and EPM FreeForm HyperionPlanning and Essbase FDMEEand EPM load rules Essbasecalculation scripts BusinessRules and Groovy Rules SQLand PL/SQL SQLServer and relational databases Metadatamanagement and hierarchy maintenance Dataintegration and ETL processes Shellscripting and batch scripting Functional and Professional SkillsStronganalytical and problem-solving skills. Abilityto analyze complex business and technical requirements. StrongSQL query development and query optimization skills. Abilityto troubleshoot complex data, metadata, calculation, and integration issues. Strongattention to detail and commitment to data quality. Abilityto communicate technical concepts effectively to both technical andnon-technical stakeholders. Abilityto work independently while also collaborating effectively within a team. Strongownership, accountability, and delivery orientation. Abilityto manage multiple priorities in a fast-paced consulting or supportenvironment.