RQ09328 - Specialized IT Consultant - Senior

S M Software Solutions Inc; Toronto; Hybrid; CAD 100,000 - 125,000; Part time

Job summary

S M Software Solutions Inc is seeking a Senior Information Technology Consultant in Toronto to support the Ministry of Treasury Board Secretariat. The role requires expertise in ETL solutions, particularly with Oracle tools, and involves significant interaction with clients to improve IT infrastructures. The successful candidate will work in a hybrid environment, ensuring both onsite and remote operations are efficiently managed.

Qualifications

• Five years’ experience developing and maintaining ETL solutions with ODI as a tool.
• Experiences with Hyperion Planning 11.2 installation and configuration.
• Critical experience with Linux and Windows Server environments.

Responsibilities

• Provide full stack Oracle development services specializing in APEX and PL/SQL.
• Advise clients on IT strategies to enhance business processes.
• Deliver subject matter expertise and high-level technical assistance.

Skills

Infrastructure experience

ETL

Oracle APEX

PL/SQL

Job description

2 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Client : Ministry of Treasury Board Secretariat

Estimated End Date : 2026-03-31

Business Days : 156.00

Extension : Probable after the initial mandate

Security Level : No Clearance Required

Must Haves

• Looking for : experience with Infrastructure related roles - set up the software in operating environments, stalling and configuring software properly. Not so much a developer. Also looking for ETL with a focus on ODI.
• At least five years’ experience developing and maintaining ETL solutions with some experience using ODI as the ETL tool. 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.

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.
• Demonstrated experience installing and configuring Word Press in a Linux load-balance environment.
• Demonstrated experience managing network components in a complex, load-balance environment.

Application-Specific Experience (35%) :

• Demonstrated expertise in loading and extracting data from Hyperion applications that utilize a large number of Plan Types.
• Demonstrated experience working in a load-balanced, highly available hardware and software configuration.
• Demonstrated experience working with applications exposed to external access via a Proxy Server.
• Demonstrated experience designing, specifying and implementing complex computing platforms.
• Demonstrated experience developing high quality documentation of complex infrastructure implementations.
• Demonstrated experience working with data centre staff to manage a complex platform extending across multiple operating systems and integrating multiple application development tools.

Note

Hybrid Work Environment : The successful candidate is expected to work onsite at 222 Jarvis St 3 days per week, and may work remotely up to 2 days per week.

• Hybrid - 3 days on site and 2 remote

Eligibility and Application Steps

If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents : [emailprotected]

Without mandatory documents, we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)
• LinkedIn ID (Mandatory)

Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role!

If you have any questions or need further clarification, feel free to call or text at [phone].

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Part-time

Job function

Job function

Information Technology

IT Services and IT Consulting

Referrals increase your chances of interviewing at S M Software Solutions Inc by 2x

Sign in to set job alerts for “Senior Information Technology Consultant” roles.

Manager Information Technology Administration

Intermediate Digital Transformation Specialist

OneStream Consultant - Toronto - Growing Org

Senior Data Solutions Consultant, Technology Services Group

information technology development vice-president - financial, communications and other business services

Mississauga, Ontario, Canada $40.00-$50.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr

Create a job alert for this search

Senior It Consultant • Toronto, ON, Canada