Work from Client location in Montreal 5 days a week for first 3 monthsWe are seeking a Senior Oracle EPM engineer with solid 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 systemsDesign develop and maintain EPM applications metadata web forms and reportsWrite optimize and troubleshoot complex Calculation Scripts Calc Scripts and business rulesDevelop SQL and PLSQL scripts stored procedures functions and packages for data manipulation and transformationDevelop and maintain robust batch processes using Shell Scripting UNIX Linux to support data loads system automation and operational monitoringUtilize Control M or similar enterprise job scheduling tools to design manage and monitor complex job workflows ensuring optimal performance and reliabilityPerform comprehensive root cause analysis RCA on performance degradation and system failures developing and implementing long term preventative solutionsDevelop and enforce best practices coding standards and architectural patternsCreate and maintain detailed documentation for Oracle EPM processes system architecture and performance improvements