Oracle EPM Integration Consultant

About the Role

We are looking for experienced Oracle EPM Integration Consultants to join a client-facing team supporting and developing integrations across the Oracle EPM Cloud ecosystem.

This role is ideal for someone with strong hands-on experience building Oracle EPM Cloud integrations from scratch, troubleshooting complex data loads, and supporting critical financial processes such as month-end close, planning, forecasting, and allocations.

What You’ll Do

• Design, develop, and maintain Oracle EPM Cloud integrations from scratch.
• Build and support integrations using EPM Data Exchange and EPM Integration Agent.
• Develop and maintain integrations leveraging Oracle EPM REST APIs and automation scripts.
• Support end-to-end data integration processes, including extraction, transformation, loading, validation, and reconciliation.
• Troubleshoot failed integrations and perform root cause analysis.
• Work with middleware and ETL technologies such as Oracle Integration Cloud (OIC), Informatica, ODI, or SSIS.
• Manage SFTP-based integrations, including encryption, key handling, and file retention.
• Support integration activities related to financial close, planning, forecasting, and allocation cycles.
• Troubleshoot Smart View issues related to integration outputs.
• Maintain technical documentation and follow Incident, Problem, and Change Management processes.

What We’re Looking For

• 3–6+ years of experience developing Oracle EPM Cloud integrations, including hands-on experience building integrations from scratch.
• 2+ years of experience supporting Oracle EPM Cloud integration operations.
• Strong hands-on experience with:
• Oracle EPM Cloud Data Exchange
• Oracle EPM Integration Agent
• Oracle EPM Cloud REST APIs
• Automation/scripting using Groovy and/or Python
• OIC and/or ETL tools such as Informatica, ODI, or SSIS
• SFTP, encryption, key management, and file handling
• Strong understanding of the full data load lifecycle: extract, transform, load, validate, and reconcile.
• Understanding of dimensional intersections and validation logic.
• Knowledge of financial data concepts including Chart of Accounts (COA), entities, scenarios, and periods.
• Familiarity with IP allowlists and Smart View troubleshooting.
• Experience supporting time-sensitive month-end close and/or planning cycles.
• Strong troubleshooting, analytical, and root cause analysis skills.
• Strong written and verbal communication skills with the ability to work directly with clients.
• Ability to work independently in a remote/offshore delivery model.

Nice to Have

Experience supporting Oracle EPM processes or modules such as:

• FCC / FCCS
• ARCS
• TRC
• Planning / PBC
• PCM

Education

Bachelor’s degree in Information Systems, Computer Science, Finance, Accounting, or a related field.

Work Expectations

Candidates should be comfortable overlapping with North American business hours, particularly during critical periods such as month-end close, budget/forecast cycles, and allocation runs. Some extended-hours support may occasionally be required during critical business windows.