Oracle EPM Consultant

Posted 23 Days Ago
Be an Early Applicant
San Diego, CA, USA
In-Office
Senior level
Information Technology • Software
The Role
Designs, develops, configures, tests, deploys, and supports Oracle EPM and ODI solutions. Responsibilities include Hyperion Planning, Essbase, EPBCS, EDMCS, Narrative Reporting, metadata management, enterprise integrations, SQL and PL/SQL development, automation, data quality, production support, incident resolution, application migrations, and stakeholder collaboration.
Summary Generated by Built In

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.



Skills Required

  • Technical consulting or team experience 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
  • Hands-on experience with Oracle EPM EPBCS and EPM FreeForm
  • Hands-on experience with Hyperion Planning and Essbase
  • Hands-on experience with Oracle EDMCS and Narrative Reporting
  • Hands-on experience with Oracle Data Integration, Data Exchange, Data Management, and FDMEE
  • Hands-on experience with Oracle Data Integrator
  • Experience with EPM Automate, EPM Agents, MaxL, Essbase calculation scripts, Business Rules, and Groovy Rules
  • Strong SQL and PL/SQL development and query optimization skills
  • Experience with SQL Server and relational databases
  • Experience with metadata management, hierarchy maintenance, and data quality controls
  • Experience with data integration and ETL processes
  • Experience with shell scripting and batch scripting
  • Strong analytical, troubleshooting, communication, and problem-solving skills
  • Oracle EPM Cloud certification
  • Oracle Data Integrator certification
  • Experience with Oracle Cloud Infrastructure
  • Experience with enterprise financial planning and reporting processes
  • Experience with Agile and DevOps delivery models
  • Experience with application migration and release management across EPM environments
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
Hyderabad
140 Employees
Year Founded: 2005

What We Do

SoftClouds | IT, Cloud, CRM & CX Solutions Provider. Oracle | Salesforce | DevOps | Cloud | Mobility – Innovative Solutions. SoftClouds is an IT, Cloud, CRM & Customer Experience (CX) solutions provider headquartered in San Diego, CA. Our mission is to guide our customers through their digital transformation journey by delivering innovative, creative, and consultative solutions. We enable them to be successful by embracing their vision and providing high-quality solutions. This deepens their customer relationships, improves corporate profitability, and provides in-depth business performance easily and efficiently. SoftClouds is built on 5 Mantras: Honesty, Integrity, Respect, Innovation, and Creativity, with a strong focus on our most important asset, our employees. With decades of experience and deep industry-specific expertise, our expert consultants architect innovative solutions to help your business find the best and most intelligent way to achieve your goals. Our People | Our Passion | Our Pride

Similar Jobs

Micron Technology Logo Micron Technology

GEL Site Lead

Artificial Intelligence • Hardware • Information Technology • Machine Learning
In-Office
San Jose, CA, USA
45000 Employees
139K-266K Annually

HRL Laboratories Logo HRL Laboratories

Technical Program Manager

Artificial Intelligence • Hardware • Software • Nanotechnology • Semiconductor • Quantum Computing • Defense
Hybrid
Malibu, CA, USA
850 Employees
194K-248K Annually

Spectrum Logo Spectrum

Sales Representative

eCommerce • Information Technology • Internet of Things • Mobile • On-Demand • Retail • Software
In-Office
Los Angeles, CA, USA
100000 Employees
33K-55K Annually

Spectrum Logo Spectrum

Sales Representative

eCommerce • Information Technology • Internet of Things • Mobile • On-Demand • Retail • Software
In-Office
San Diego, CA, USA
100000 Employees
30K-55K Annually

Similar Companies Hiring

Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account