EPM Cube Data Extraction Technical Developer

Job Title: EPM Cube Data Extraction Technical Developer

Location: NYC, NY (Hybrid)
Duration: 6 months

Role: EPM SME (FCCS, PBCS, ARCS)- EPMAUTOMATE - EPM Cube Data Extraction Technical Developer

Descriptions: Oracle EPM - Financial Consolidation and Close Cloud Service (FCCS)| Enterprise Planning and Budgeting Cloud Service (EPBCS)| Account Reconciliation (ARCS)

Must Have Technical/Functional Skills
Hands on experience with epmautomate, including scripting and automation. Scripting includes Audit logging, error
handling and configuration of automated e-mail notifications (if any).
Hands-on experience of Cloud Data Management/Integration Agent.
Practical exposure to FCCS and EPBCS application modules. Sound knowledge of other applications like ARCS, or other
Oracle EPM application modules will be added advantage.
Understanding of EPM Inox/Outbox folder structure, EPM Data export job types, and file formats.
Groovy Scripting with EPM Automate to call REST API for Data extraction and scheduling using an external orchestrator
(like OIC) will be handy.
Ability to collaborate with EPM functional teams, Snowflake engineers, and cloud admins.
Good communication and documentation habits.


Roles & Responsibilities
1. epmautomate Automation & EPM Cube Data Extraction
Install, configure, and maintain epmautomate on OCI
2.Develop automated scripts to: List Outbox files in EPM environment, Identify latest FCCS/EPBCS/ARCS exports, Push files to OCI Object Storage
3.Manage Full and Incremental cube exports based on business need
4.Configure and maintain EPM Native Scheduler export jobs. Monitor export job success, warnings, and failures through EPM Job Console
5.Move files from EPM Outbox Custom OCI Object Storage
6.Have working knowledge of Oracle EPM application structure Meta