RQ00328 - Specialized IT Consultant - Senior

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

Job summary

A leading IT consulting firm in Toronto is seeking a Senior IT Consultant to focus on ETL projects, design data pipelines, and provide production support. The ideal candidate should have 8-10 years of relevant experience with IICS, Oracle 19G, and Azure SQL Database. This role combines remote and in-office work, offering a dynamic environment for skilled professionals. Interested candidates should apply with their updated resume and essential documents.

Qualifications

• 8-10 years of experience in ETL processes and data integration.
• Proficiency in designing and managing data warehouses.
• Experience with Azure cloud technologies.

Responsibilities

• Design, implement, and expand data pipelines for ETL projects.
• Monitor ETL jobs and provide production support.
• Troubleshoot technical problems in software packages.

Skills

IICS (Informatica Intelligent Cloud Services)

Oracle 19G

Azure SQL Database

Linux 8 – Shell Scripting

SQL optimization

Scripting (shell / python / Perl)

Job description

2 days ago Be among the first 25 applicants

RQ00328 - Specialized IT Consultant - Senior

Start Date

2025-06-16

Client

Supply Ontario

End Date

2025-12-10

Work Location :

Toronto, Ontario, Canada

Business Days : 125.00

Job Type

7.25 hours per day (5 Days)

• 8-10 years’ experience with the following :
• Oracle 19G

Job Title

RQ00328 - Specialized IT Consultant - Senior

Start Date

2025-06-16

Client

Supply Ontario

End Date

2025-12-10

Work Location :

525 University Avenue , Toronto, Ontario, Canada

Business Days : 125.00

Job Type

Hybrid

Hours Per Day Or Week

7.25 hours per day (5 Days)

Must Haves

8-10 years’ experience with the following :

IICS (Informatica Intelligent Cloud Services)

Oracle 19G

Azure SQL Database

Linux 8 – Shell Scripting.

Description

Background Information

The purpose of this requisition is to procure a Specialised IT Consultant contingent resource for six months. The technical skilled resource will be initially required to focus on the Design and Development and QA & Production Support for our ETL Projects.

Responsibilities

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

Provide production support by monitoring ETL jobs, investigating failures and providing detailed reports on the resolution for issues faced in managing multiple data pipelines and QA support.

Translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and / or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Desired Skills

Experience at the specified experience level setting up user access and user profiles, backup and recovery, and day-to-day computer systems operations.

Experience in Building and maintaining data pipelines (ETL / ELT processes).

Experienced in building and managing Cloud Data Integration (CDI) pipelines for ETL / ELT processes.

Proficient and experienced in designing and managing data warehouses (IICS) and databases(Oracle 19g)

Experienced in data ingestion from cloud storage, on-premises systems, and streaming sources and API’s

Proficient in designing and developing data integration solutions using Informatica Intelligent Cloud Services (IICS).

Experienced in system management and administration on Windows and Linux operating systems.

Strong understanding of ETL concepts, data transformation logic, and data quality best practices.

Proficient in writing and optimizing SQL queries across various relational databases (Oracle, SQL Server).

Familiar and proficient on Azure Cloud and Azure Storage technologies such as Azure Data Lake Storage, Azure SQL Database, and Azure Data Lake Analytics.

Skilled in monitoring, troubleshooting, and resolving IICS job failures and performance issues.

Experienced in incident management, root cause analysis, and implementing preventive measures.

Familiar with version control systems (e.g., Git) and CI / CD pipelines for deployment automation.

Knowledgeable in managing support tickets and change requests.

Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills

A team player with a track record for meeting deadlines.

Proficient in scripting (shell / python / Perl).

CRM technologies (e.g. Oracle Siebel CRM), Oracle OBIEE, Informatica (PowerCenter and / or IICS).

Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Required Skills

IICS – Informatica Intelligent Cloud Services.

Oracle 19G,

Azure

Azure SQL Database

Linux 8 – Shell Scripting

GIT Version Control

Excellent Communication, Collaboration Skills and contributes effectively to team objectives.

Required Experience / Evaluation Criteria

IICS – Development & Production Support - 35pts

Oracle 10g - 35 pts

Azure – SQL Server - 10 pts

Linux 8 – Shell Scripting - 10 pts

Git - 10 pts

Total Capabilities Evaluation Criteria - 100 points

Deliverables

Deliverables Include :

Provide end to end software design, development and QA / Production support and documentation services for all ongoing and upcoming ETL and data projects at Ontario Health on the cancer care programs team.

Design Documents (LSTM, Tickets in ADO).

Source Code (PL / SQL, SQL, Shell Scripting, ETL, Python).

ETL / Production Support Runbooks

Project / Work Estimates

ReadME.md

Technical / Conceptual specification documents

Notes

Assignment Type : This position is currently listed as "Hybrid". The resource under this request will be required to work onsite as per Hiring Manager sole discretion.

Ontario Health assets including laptops and related equipment cannot be removed from the province of Ontario without prior written approval from Ontario Health.

Term : The term of this position is 125 Business Days, with an option to extend for an additional 40 days at Ontario Health's discretion.

Location : Hybrid – up to 3 days max in office per month, subject to change

Public Sector Experience : No

Eligibility and Application Steps

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

Without mandatory documents, we cannot submit a candidate.

Updated Resume in word format (Mandatory)

Skills Matrix and References (Mandatory)

Expected hourly rate (Mandatory)

Visa Status (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

Industries

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

Business Consultant - (Technology / Payment Systems)

Senior Data Solutions Consultant, Technology Services Group

Information Technology (IT) Operations Manager - WEINS Corporate

Mississauga, Ontario, Canada $40.00-$50.00 17 hours ago

Richmond Hill, Ontario, Canada 8 months ago

Toronto, Ontario, Canada CA$65.00-CA$80.00 16 hours ago

business systems specialist - computer systems

Senior Manager (Children, Youth and Social Services Information and Information Technology Cluster)

North York, Ontario, Canada CA$105,307.00-CA$148,429.00 2 weeks ago

Consulting Intern (4 month term - Toronto, Montreal or Ottawa)

Richmond Hill, Ontario, Canada 8 months ago

Senior Advisor, IT Governance - IT Business Services

Mississauga, Ontario, Canada 23 hours 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