Oracle EPM Consultant

Position: Oracle EPM Consultant

Location : Cary, NC OR NYC, NY - Onsite

Type of Hire :- Long Term Contract

Role Description:

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:

• 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 Fast Connect + Direct Connect for secure, non-internet transfers.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.