Oracle EPM Developer - NYC,NY - hybrid

[Rohit kumar]

Role – Oracle EPM Developer
Location – NYC,NY - hybrid
Type – Contract

 

 

 

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 Metadata and Data including cubes and dimensions (custom and Out-of-the-Box).

7. Assist Snowflake teams in understanding cube structures and slice exports.

8. Ensure consistent, scheduled delivery of EPM data to Snowflake ingestion layers.

9. Manage audit and logging systems: epmautomate execution logs, OS audit logs, OCI Object Storage audit logs Manage OCI VM audit logs for rclone command execution.

5. Understand, discuss and review with Client Infra and networking team on networking options such as FastConnect + Direct Connect for secure, non‑internet transfers.

 

Skills: Digital : SaaS EPM Oracle Enterprise Planning & Budgeting Cloud

(EPBCS)

Experience Required: 4-6