Senior Oracle EPM Engineer

Job summary

Manage, optimize, and scale Hyperion financial planning and consolidation systems, including EPM applications, metadata, forms, reports, and calculation scripts. Develop and maintain database code and automated batch workflows, monitor system reliability, investigate failures, and document architecture and operational best practices.

Job details

Job Summary We are seeking a Senior Oracle EPM Engineer with strong PLSQL and Shell Scripting skills You will manage optimize and scale our Hyperion financial planning and consolidation infrastructure You will use Python Shell scripting and PLSQL to maintain enterprise grade financial systems Key Responsibilities Ensure high availability and performance of Hyperion Planning and Consolidation systems Design develop and maintain EPM applications metadata web forms and reports Write optimize and troubleshoot complex Calculation Scripts Calc Scripts and business rules Develop SQL and PLSQL scripts stored procedures functions and packages for data manipulation and transformation Develop and maintain robust batch processes using Shell Scripting UNIXLinux to support data loads system automation and operational monitoring Utilize ControlM or similar enterprise job scheduling tools to design manage and monitor complex job workflows ensuring optimal performance and reliability Perform comprehensive root cause analysis RCA on performance degradation and system failures developing and implementing longterm preventative solutions Develop and enforce best practices coding standards and architectural patterns Create and maintain detailed documentation for Oracle EPM processes system architecture and performance improvements Note Working hours Mondays to Fridays Flexibility to work during nonstandard working hours days as requested Working from home voluntary basis for up to 2 days per week after 3 months of joining subject to managers discretion Calendar Holiday to follow USA

What you’ll do

Manage, optimize, and scale Hyperion financial planning and consolidation systems, including EPM applications, metadata, forms, reports, and calculation scripts. Develop and maintain database code and automated batch workflows, monitor system reliability, investigate failures, and document architecture and operational best practices.

Requirements

The role calls for strong PL/SQL and shell scripting skills, along with experience supporting enterprise financial planning and consolidation systems. Python, SQL, UNIX/Linux, job scheduling tools such as Control-M, performance troubleshooting, and root cause analysis are also relevant to the work.

Listed skills

• SQL · Preferred
• Root Cause Analysis · Preferred
• System monitoring · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Oracle EPM
• Hyperion Planning
• Hyperion Consolidation
• PL/SQL
• Shell Scripting
• Python
• SQL
• Calculation Scripts
• Business Rules
• UNIX/Linux
• Control-M
• Batch Processing
• Root Cause Analysis
• Performance Optimization
• Data Transformation
• System Monitoring

Job areas

• Technology
• Software
• Finance & Accounting
• Engineering

More jobs from Ardent SoftSol Inc.