EPMAUTOMATE - EPM Cube Data Extraction Technical Developer

EPMAUTOMATE

•EPM Cube Data Extraction Technical Developer 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. 10. Understand, discuss and review with Client Infra and networking team on networking options such as FastConnect + Direct Connect for secure, non‑internet transfers. Salary Range•$100,000•120,000 a year #LI-OJ1 Location New York, NY Job Function

TECHNOLOGY

Role Analyst Job Id 411314 Desired Skills Oracle Salary Range $100,000•120,000 a year