28 Oct
|
Aptino
|
Montreal
Job Summary We are looking for an experienced Senior Oracle EPM Engineer with robust 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.
• Strong analytical, problem-solving, and documentation skills.
📌 Senior Oracle EPM Engineer (Montreal)
🏢 Aptino
📍 Montreal