Role: Essbase Developer

Location: Toronto, ON(Hybrid)

Duration: Fulltime Permanent

Job description :

Experience working with migrating and establishing Essbase 19c/21c onto the Oracle Cloud Instance (OCI)

Experience in creating ASO cubes with Partitions, MaxL and MDX Scripting and optimize the cubes for performance.

Experience using ETL tools (preferably SQL, PL/SQL) to migrate data from legacy on-prem databases to the cloud

Experience maintaining and supporting Oracle databases using SQL and PL/SQL

Development duties within the Essbase 21C and SQL Server 2019 environments (such as current state improvements and the creation of new applications).

Production support for the Essbase and SQL Server 2012, 2019 environments (such as security, scheduled job maintenance, general close/trouble shooting and performing quality control steps to ensure the accuracy of data).

The ability to maintain and support existing Essbase code in an Oracle database environment is also required. After the migration to Essbase 19C/21c is complete

"L!-CEIPAL"