EPMAUTOMATE - EPM Cube Data Extraction Technical Developer
Must Have Technical/Functional Skills
Handson 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, noninternet transfers.
Never miss an opportunity! Create an alert based on the job you applied for.
