Senior Oracle EPM Engineer
- Montreal, QC, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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
More about this job
Responsibilities
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.
Skills
- 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
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Finance & Accounting
- Engineering
Keywords
- Oracle EPM
- Hyperion
- Hyperion Planning
- Financial Consolidation
- Financial Planning
- PL/SQL
- SQL
- Python
- Shell Scripting
- UNIX/Linux
- Control-M
- EPM Applications
- Metadata
- Web Forms
- Reports
- Calculation Scripts
- Business Rules
- Stored Procedures
- Functions
- Packages
- Data Loads
- Batch Processes
- Job Scheduling
- System Automation
- Operational Monitoring
- Root Cause Analysis
- Performance Optimization
- System Architecture
- Coding Standards
- Software Development