Specialized IT Consultant - Senior

2iSolutions Inc.; Ontario; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading company is seeking an experienced infrastructure specialist for a hybrid role. The ideal candidate will have extensive experience with Hyperion Planning and Oracle EPM, focusing on installations and configurations. Responsibilities include providing strategic IT guidance and ensuring quality deliverables. This role requires strong technical skills in ETL solutions and collaboration with clients to enhance IT systems.

Qualifications

• At least three years of dedicated infrastructure experience.
• Five years of ETL solutions development with ODI.

Responsibilities

• Provide services as a full-stack Oracle developer, specialized in APEX and PL/SQL.
• Partner with clients to advise on IT to meet business objectives.

Skills

Infrastructure Management

Technical Advisory

Quality Assurance

Problem Solving

Change Management

Information Management

Tools

Hyperion Planning

Oracle EPM

ODI

Informatica

APEX

Oracle RDBMS

OBIEE

VBA/Excel Macros

Job description

Client : Ministry of Natural Resources and Forestry

Period : 12 Months

Start Date : 2025-04-02

End Date : 2026-03-31

Working Hrs. : 7.25 Hrs. / day

Location : 777 Bay St. W. Suite 423 Toronto

Hybrid role - 3 days on site and 2 remote

Looking for experience with infrastructure-related roles, including setting up software in operating environments, installing, and configuring software. Not primarily a developer. Also seeking experience with ETL, focusing on ODI.

MUST HAVES :

Experience installing, configuring, and maintaining Hyperion Planning (Oracle EPM) software stack, including Hyperion Planning 11.2, with at least three years of dedicated infrastructure experience or equivalent.

At least five years of developing and maintaining ETL solutions, with experience using ODI as the ETL tool. Some experience with Informatica is desirable.

Description : Responsibilities :

The primary responsibility is to provide services as a full-stack Oracle developer, specialized in APEX, PL/SQL, with some exposure to other Oracle development tools such as ODI and relational databases.

• Partner with clients to advise on IT to meet business objectives and improve organizational IT systems.
• Provide strategic guidance on Information Management, IT infrastructure, and enabling major business processes through IT enhancements.
• Offer subject matter expertise and technical assistance in their field.

General Skills :

• Act as a technical advisor and expert on deliverables
• Ensure quality assurance and control of deliverables
• Anticipate and resolve problems to ensure timely, high-quality completion
• Develop processes and procedures for implementation
• Prepare reports and presentations with options, recommendations, and plans
• Work with clients to define project scope and requirements
• Define software, hardware, and network requirements
• Analyze IT requirements and provide independent advice
• Design, test, install, and monitor new systems
• Familiar with change management principles
• Understand Information Management principles and policies

Evaluation based on price (30%) and skills/experience (70%), divided as follows:

Core Technical Skills (35%) :

• Experience with Hyperion Planning and Oracle EPM stack, including installation and configuration
• Experience managing software in Linux and Windows Server environments
• Experience with APEX, Oracle RDBMS, OBIEE (BI Publisher), and WordPress in load-balanced environments
• Network management in complex, load-balanced setups
• At least five years developing and maintaining ETL solutions, with ODI and some Informatica experience

Application-Specific Experience (35%) :

• Experience working in load-balanced, highly available environments
• Configuring solutions for financial applications like payments and funds allocation
• Configuring infrastructure for hybrid applications involving Hyperion Planning, APEX, ODI, VBA/Excel Macros
• Experience with external access via Proxy Server
• Designing and implementing complex computing platforms
• Developing detailed documentation for infrastructure implementations
• Collaborating with data center staff across multiple OS and tools