Oracle EPM

iTech US, Inc.
New York, United States of America
26 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

New York, United States of America

Tech stack

Audit Trail
Software as a Service
Cloud Computing
Information Systems
Data Mining
Groovy
Metadata
Cloud Services
Simple Data Format
Software Engineering
Scripting (Bash/Python/Go/Ruby)
Oracle Hyperion
Software Modules
Oracle Enterprise Manager
Snowflake
Information Technology
Data Management
REST
Oracle Cloud Infrastructure

Job description

  • Epm automate Automation & EPM Cube Data Extraction Install, configure, and maintain epmautomate on OCI
  • Develop automated scripts to: List Outbox files in EPM environment, Identify latest FCCS/EPBCS/ARCS exports, Push files to OCI Object Storage
  • Manage Full and Incremental cube exports based on business need
  • Configure and maintain EPM Native Scheduler export jobs. Monitor export job success, warnings, and failures through EPM Job Console
  • Move files from EPM Outbox Custom OCI Object Storage
  • Have working knowledge of Oracle EPM application structure Metadata and Data including cubes and dimensions (custom and Out-of-the-Box).
  • Assist Snowflake teams in understanding cube structures and slice exports.
  • Ensure consistent, scheduled delivery of EPM data to Snowflake ingestion layers.
  • 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.
  • Understand, discuss and review with Client Infra and networking team on networking options such as FastConnect + Direct Connect for secure, noninternet transfers.

Requirements

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

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., Education : At least a bachelor s degree (or equivalent experience) in Computer Science, Software Engineering, Electronics Engineering, Information Systems, or a closely related field is required for the project

Apply for this position