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
- 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
- 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
More about this job
Responsibilities
Manage, optimize, and scale Hyperion financial planning and consolidation systems, ensuring their availability and performance. Develop and maintain EPM applications, scripts, data processes, job workflows, documentation, and preventative solutions for system issues.
Requirements
The role calls for strong Oracle EPM, PL/SQL, and shell scripting skills, with experience supporting enterprise financial systems. Relevant capabilities include Python, SQL development, UNIX/Linux batch processing, enterprise job scheduling, performance troubleshooting, and root cause analysis.
Skills
- Oracle EPM
- PL/SQL
- Shell Scripting
- Hyperion Planning
- Hyperion Consolidation
- Python
- EPM Application Development
- Metadata Management
- Web Forms and Reports
- Calculation Scripts
- Business Rules
- SQL
- Stored Procedures
- UNIX/Linux
- Control-M
- Root Cause Analysis
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Finance & Accounting
- Engineering
Keywords
- Oracle EPM
- Hyperion
- Financial Planning
- Financial Consolidation
- PL/SQL
- SQL
- Python
- Shell Scripting
- UNIX/Linux
- EPM Applications
- Metadata
- Web Forms
- Reports
- Calculation Scripts
- Business Rules
- Stored Procedures
- Functions
- Packages
- Data Loads
- Batch Processes
- Control-M
- Job Scheduling
- Workflow Management
- System Automation
- Operational Monitoring
- High Availability
- Performance Optimization
- Root Cause Analysis
- Coding Standards
- System Architecture