Specialized IT Consultant - Senior
Toronto , Ontario , Canada
|
2025-06-12 08:45:57
Summary:
Join our team as a Full Stack Oracle Developer to support enterprise data and infrastructure solutions with a strong focus on Oracle APEX, PL/SQL, and Oracle Data Integrator (ODI). In this hybrid role (3 days onsite, 2 remote), you'll lead the installation, configuration, and support of Oracle EPM/Hyperion Planning 11.2, manage complex ETL processes, and ensure seamless data movement across systems. Ideal candidates will bring 5+ years of infrastructure experience, strong skills in Linux and Windows Server environments, and expertise in developing scalable, load-balanced solutions. This position is suited for highly skilled professionals with deep technical insight and a focus on platform reliability.
Description
Responsibilities:
The main responsibility of this resource is to provide the services of a full stack Oracle developer specialized in APEX, PL/SQL with some exposure to the other Oracle development tools being used in these applications such as ODI and the relational database.
Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organization’s I&IT systems. The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. Provides subject matter expertise in their field and highly expert technical assistance.
General Skills:
Acts as the technical advisor/expert on all aspects of a specific deliverable Provide the quality assurance/quality control of specific deliverables Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations Develops processes and procedures for implementing deliverables Prepares reports and presentations including options, recommendations, implementation plans, etc. Works with clients to define the scope of a project and to determine requirements Defines software, hardware and network requirements Analyzes I&IT requirements giving independent and objective advice on the use of I&IT Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems Familiar with change-management principles and methodology Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience and Skill Set Requirements
Evaluation based on price 30%.
Skills and Experience accounts for 70% apportioned as follows:
Core Technical Skills (35%)
At least five years experience developing and maintaining ETL solutions with at least two years experience using ODI as the ETL tool for loading and extracting data from Essbase cubes. Some experience in Informatica also desirable. Demonstrated experience installing, configuring and maintaining Hyperion Planning (Oracle EPM) software stack with some experience installing Hyperion Planning 11.2, and at least three years of dedicated infrastructure experience or equivalent across a longer time period. Demonstrated experience installing and configuring EPM to work in an OAM single-sign on configuration. Demonstrated experience managing software and infrastructure components in the following environments: Linux, Windows Server.