Job Summary

We are looking for an experienced Senior Oracle EPM Engineer with strong hands-on expertise in Oracle Hyperion, PL/SQL, and UNIX/Linux Shell Scripting. The ideal candidate will be responsible for maintaining, optimizing, and supporting enterprise financial planning and consolidation systems while ensuring high availability, performance, and reliability.

Key Responsibilities

- Maintain and optimize Oracle Hyperion Planning and Consolidation systems.
- Develop and maintain EPM applications, metadata, web forms, and reports.
- Create, optimize, and troubleshoot Calculation Scripts and business rules.
- Develop complex SQL queries, PL/SQL scripts, stored procedures, functions, and packages.
- Build and maintain UNIX/Linux Shell Scripts for automation, data loads, and system monitoring.
- Manage and monitor batch job workflows using Control-M or similar scheduling tools.




- Perform root cause analysis and resolve system failures and performance issues.
- Follow coding standards, technical best practices, and architectural guidelines.
- Prepare and maintain technical documentation for EPM processes and system architecture.

Required Skills & Qualifications

- Strong experience with Oracle EPM / Hyperion Planning and Consolidation.
- Hands-on expertise in PL/SQL, SQL, stored procedures, functions, and packages.
- Strong UNIX/Linux Shell Scripting skills.
- Experience with Hyperion Calculation Scripts and business rules.
- Knowledge of Control-M or similar enterprise job scheduling tools.
- Experience in performance tuning, troubleshooting, and root cause analysis.
- Python scripting experience is an advantage.
- Solid analytical, problem-solving, and documentation skills.

📌 Senior Oracle EPM Engineer (Montreal)
🏢 Aptino
📍 Montreal