Find work in Canada.

319,837 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 7 mins ago
B
QA Analyst/Content Migration(OpenText to SharePoint)
BeachHead
Toronto, ON
- $41.28 to $49.54 CAD / hour
- Contract
Test the functionality of the new intranet platform to confirm seamless operation
Added 7 mins ago
KG
Loader Operator - Crushing
Kode Group
Prince George, BC
- Full-time
Ability to pass a drug and alcohol test, subject to applicable laws, human rights obligations, and the collective agreement.
Added 7 mins ago
E
Environmental Scientist Project Manger
Englobe
Toronto, ON · Etobicoke, ON
- Full-time
Coordinate and supervise field programs, including drilling, test pitting, groundwater monitoring, soil and groundwater sampling, and subcontractor activities;
Added 7 mins ago
ZS
Python Developer – Data Engineering
Zodiac Solutions, Inc
Toronto, ON
- Full-time
Understanding of test coverage, mocking, test automation, and quality assurance practices.
Added 8 mins ago
BC
Class 1 Driver NEEDED
Blackline Civil
Edmonton, AB
- Full-time
Applicants must be able to pass a pre-employment drug and alcohol test and provide work-related references.
Added 8 mins ago
CE
Expression Of Interest
Critical Environment Technologies Canada Inc.
Delta, BC
- Full-time
- Temporary
Test firmware and hardware on live gas detection instruments. You'll build test cases, run benches, and log and verify defects. This is a great fit for engineering/ applied science students.
Added 8 mins ago
L
DevOps Intern / Stagiaire DevOps
Ludia
Montreal, QC
- Internship
As a DevOps Intern, you’ll learn how the tools, infrastructure, and automation behind our games help our teams build, test, and deliver content efficiently.
Added 21 mins ago
CO
Sponsorship Program - Police Officers
City of Saint John
Saint John, NB
- Full-time
Must be able to pass the Physical Abilities Requirement Evaluation (PARE) test to police standards
Added 21 mins ago
TC
Process Engineering Specialist
Toromont Cat
Bradford, ON
- Full-time
Develop, test, and troubleshoot robot programs for automated production tasks. Rapidly prototype tooling and fixturing to support automation, improve safety and turnaround time. Assist with…
Added 22 mins ago
YG
Quality Control Coordinator
York Group
Edmonton, AB
- Full-time
Develop and manage Inspection and Test Plans (ITPs) for each project, coordinating with various parties required for hold points and inspections.
Added 22 mins ago
CI
Geotechnical Engineer/Project Manager
Cambium Inc.
Barrie, ON · Whitby, ON
- Full-time
Lead and support geotechnical field investigations, including borehole drilling, test pit excavation, in situ testing, instrumentation installation, and construction observation services.
Added 22 mins ago
DG
Software Developer I
Dahrouge Geological Consulting Ltd.
AB · Edmonton, AB
- Full-time
· Use AI coding tools responsibly: review, test and be able to explain every line they produce.
Added 36 mins ago
DM
Apprentice Heavy Duty Equipment Technician
Discovery Mining Ltd
South Porcupine, ON
- Full-time
Test repaired equipment for proper performance and ensure all work meets manufacturer specifications.
Added 36 mins ago
S
System Architect
SLMCON
Canada
- Full-time
Define the technical validation strategy, review test coverage for integrations, custom components, performance, resilience, and security, assess defects and architectural risk, and confirm…
Added 36 mins ago
SI
Web Developer
Spait Infotech
Canada
- Full-time
Test, debug, and resolve website issues and performance problems.
Added 36 mins ago
HP
Pharmacist (Provincial Pharmacy Services – System Application Pharmacist)
Health PEI
PE · Prince Edward Island, Canada
- $60.07 to $69.41 CAD / hour
- Full-time
Test and validate relevant CIS functionality changes.
Added 36 mins ago
P
Electronic Hardware Engineer
Percucision
Montreal, QC · Greater Montreal Metropolitan Area
- Full-time
Integrate and validate sensors and embedded components, troubleshooting issues across electronics, wiring, firmware, mechanical integration, and test setups.
Added 36 mins ago
EC
Risk Analyst
Experis Canada
Toronto, ON
- Contract
Test both control design adequacy and operating effectiveness.
Added 36 mins ago
LA
Sales Consultant (Yorkdale Volkswagen)
Leeder Automotive Inc.
Toronto, ON · North York, ON
- Full-time
Added 36 mins ago
Q
Head of Product Development- Diffuser Hardware
Quikr
Vancouver, BC
- Full-time
…hardware, firmware, software, connectivity, and production-test requirements remain aligned • Oversee engineering change control, BOM revisions, specifications, approved components, and…
Added 38 mins ago
C
Financial Services Representative II
CIBC
Salmon Arm, BC
- Full-time
We may ask you to complete an attribute-based assessment and other skills test (such as simulation, coding, French proficiency).
Added 38 mins ago
C
Client Service Representative - Contract - Part-time (20hours/week)
CIBC
Salisbury, NB
- Part-time
We may ask you to complete an attribute-based assessment and other skills test (such as simulation, coding, French proficiency).
Added 38 mins ago
C
Sr. Client Service Representative
CIBC
Charlottetown, PE
- Full-time
We may ask you to complete an attribute-based assessment and other skills test (such as simulation, coding, French proficiency).
Added 38 mins ago
C
Senior Information Security Specialist
CIBC
Toronto, ON
- Full-time
Added 38 mins ago
C
Manager, Finance Governance & Controls (12 months)
CIBC
Toronto, ON
- Full-time
…policies and procedures. The role is also responsible for the test of controls, deficiency management, and assertion process for Finance…

S M Software Solutions Inc

RQ11635 – Software Developer – ETL – Senior

Toronto, ON, Canada

Internship

Apply About employer

Applications open in a new tab.

Job details

Job type: Internship
Apply by: Nov 3, 2026
Posting language: English
Posted: Oct 4, 2026

Original job description

Client: Ministry of Public and Business Service Delivery and Procurement - RQ11635

We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal Reports, Power BI, and Business Objects Enterprise (BOE). The successful candidate will support the design, development, testing, maintenance, and enhancement of data warehousing, BI, reporting, and analytics solutions within the Employment Ontario Information Systems (EOIS) environment.

Role Snapshot

Job Title: RQ11635 – Software Developer – ETL – Senior
Client: Ministry of Public and Business Service Delivery and Procurement
Work Location: 400 University Ave, M5G 1S5, Toronto, Ontario, Canada
Work Arrangement: Onsite
Estimated Start Date: October 5, 2026
Estimated End Date: March 31, 2027
Business Days: 125.00
Extension: 134.00
Hours: 7.25 hours per day
Security Level: No Clearance Required

Must Have

5+ years’ experience with analysis, design, developing, unit testing, defect fixing and other necessary tasks in data warehousing, BI environment.
5+ years’ experience in designing and developing Crystal Reports, Power BI, and BOE reports.
5+ years’ experience in designing, developing and testing Oracle SQL and PL/SQL.
5+ years’ experience in designing, developing and testing in Informatica.
Experience with technology solutions and development methodologies.
Experience in analysing and designing changes to existing web-based software solutions.
Complete knowledge of SDLC methodologies, e.g. Agile development.
Experience in RDBMS design concepts.
Experience with Data Warehouse design, Reporting and ETL concepts.
Experience with Data Warehouse architecture, design, dimensional modelling, development and deployment of business intelligence systems.

Description

‘Employment Ontario’ is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training, Colleges and Universities. Employment Ontario helps the citizens of Ontario gain the training, skills and experience to achieve their goals.

The Employment Ontario Information Systems (EOIS) is the major IT system that supports the administration of these programs. Application subsystems under EOIS include Ca MS (Case Management System), Service Provider life Cycle (SPL), EO Self Service (EOSS), APPR (Apprenticeship), OJG (Ontario Job Grant), and APPR AOL (Apply On Line).

The operating Environment includes JEE, CURAM, Crystal Reports, Oracle SQL/PL SQL, Power BI, Oracle Database, Business Objects Universe and Dashboarding, Web I, Bursting technologies, and Informatica ETL.

Responsibilities

This request is for strong developers to help in designing and developing data warehousing, BI, reporting and analytics.
Perform analysis, design, developing, unit testing, defect fixing and other necessary tasks in a data warehousing and BI environment in Oracle PL/SQL.
Design, develop and test Informatica mappings.
Develop ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Data marts.
Develop and maintain BOE reports.
Communicate your progress clearly and timely to the management team.
Must have skills in Crystal Reports, Informatica, Power BI and BOE reporting.

General Skills

Experience in programming and analysis; specialized software package support at the specified experience level.
Ability to collaborate with IT Professionals throughout the Software Development Life Cycle.
Experience in structured methodologies for the development, design, implementation and maintenance of applications.
Experience in design, code, test, debug and document applications.
Experience in the use of object and/or third generation language development tools.
Experience in one or more programming languages.
Experience in application design, latest design patterns, deployment and troubleshooting.
Experience with relational and hierarchical database technologies.
Experience in the use of information retrieval packages using query languages.
Experience with one or more communications protocols.
Experience in structured methodologies for the design, development, implementation and maintenance of applications.
Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts.
Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.
A team player with a track record for meeting deadlines.

Desirable Skills

Knowledge and experience with programming Internet-ready applications.
Knowledge and experience in rapid application development (RAD) methodologies.
Knowledge and understanding of Information Management principles, concepts, policies and practices.
Experience with middleware and gateways.
Experience reviewing, analysing, and modifying product installation scripts including encoding, testing, debugging.
Ability to provide post-implementation support and resolve any post-implementation technical issues.
Experience conducting design walkthrough sessions with project team.
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
Ability to provide user and system documentation as required.

Experience And Skill Set Requirements

Technical Skills – 70%

The role requires strong technical expertise in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal Reports, Power BI, Business Objects Enterprise (BOE), database technologies, and related software development practices.

Communication & Other Skills – 20%

Ability to build good working relationships.
Positive team player.
Good verbal and written communication skills.
Good analytical and problem-solving skills.
Excellent ability to present to a technical and non-technical audience.

Knowledge of Methodologies – 10%

Working knowledge of SDLC and the Agile development methodology.
Demonstrated knowledge and experience with RDBMS design concepts.
Demonstrated experience in identifying risk and providing solutions.
Strong analytical and problem-solving skills.
Ability to mentor junior developers and lead technical discussions.

How to Apply

If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Friday, October 9, 2026, at 10:00 AM EST.

Without mandatory documents, we cannot submit a candidate.

Mandatory Documents

Updated Resume in Word format
References
Expected Hourly Rate
Visa Status
LinkedIn ID

WhatsApp Group

For daily job updates, you can also join our WhatsApp group using the link below:

Join our WhatsApp Group

Note

Onsite

Email is the best way to reach us.

You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.

Apply About employer

More about this job

Responsibilities

Design, develop, test, and maintain data warehousing, business intelligence, reporting, and analytics solutions for the Employment Ontario Information Systems environment. Build Informatica mappings and ETL scripts to move and transform data from OLTP systems into data warehouses and data marts, and develop and maintain Business Objects Enterprise reports.

Requirements

Requires at least five years of experience in data warehousing and BI development, Crystal Reports, Power BI and BOE reporting, Oracle SQL/PL/SQL, and Informatica. Candidates should also have knowledge of data warehouse architecture and dimensional modeling, RDBMS design, SDLC and Agile, along with strong communication, analytical, and problem-solving skills.

Skills

Data Warehousing
Business Intelligence
ETL Development
Oracle SQL
PL/SQL
Informatica
Crystal Reports
Power BI
Business Objects Enterprise
Data Warehouse Design
Dimensional Modeling
RDBMS Design
Agile
SDLC
Reporting
Data Analytics

Visa sponsorship

Not detected in the job text

Keywords

Data Warehousing
Business Intelligence
ETL
Oracle SQL
PL/SQL
Informatica
Crystal Reports
Power BI
Business Objects Enterprise
BOE
Data Warehouse
Data Marts
OLTP
Oracle Database
Business Objects Universe
Dashboarding
Web Intelligence
Bursting Technologies
Dimensional Modeling
RDBMS
JEE
CURAM
Agile
Application Design
Unit Testing
Defect Fixing
Data Analytics
Employment Ontario Information Systems
Accessibility for Ontarians with Disabilities Act

Report this job