Senior Oracle EPM Engineer
- Montreal, QC, Canada
$45 to $50 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $45 to $50 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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.
- Strong analytical, problem-solving, and documentation skills.
More about this job
Responsibilities
Maintain and optimize Oracle Hyperion Planning and Consolidation systems, including EPM applications, metadata, forms, reports, calculation scripts, and business rules. Develop database and shell-script solutions, manage scheduled workflows, troubleshoot performance and system failures, and document EPM processes and architecture.
Requirements
Requires strong hands-on experience with Oracle EPM/Hyperion Planning and Consolidation, SQL and PL/SQL development, UNIX/Linux shell scripting, and Hyperion calculation scripts and business rules. Candidates should also have scheduling-tool experience, performance-tuning and troubleshooting skills, and strong analytical and documentation abilities; Python is an advantage.
Skills
- Oracle EPM
- Hyperion Planning
- Hyperion Consolidation
- PL/SQL
- SQL
- UNIX/Linux Shell Scripting
- Calculation Scripts
- Business Rules
- Control-M
- Performance Tuning
- Troubleshooting
- Root Cause Analysis
- Python Scripting
- Technical Documentation
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Finance & Accounting
- Data & Analytics
Keywords
- Oracle EPM
- Oracle Hyperion
- Hyperion Planning
- Hyperion Consolidation
- PL/SQL
- SQL
- Stored Procedures
- Functions
- Packages
- UNIX
- Linux
- Shell Scripting
- Calculation Scripts
- Business Rules
- Control-M
- Job Scheduling
- Python
- Performance Tuning
- Troubleshooting
- Root Cause Analysis
- Batch Workflows
- Data Loads
- System Monitoring
- Financial Planning
- Enterprise Consolidation
- Metadata
- Web Forms
- Reports
- Technical Documentation
- Banking