Find work in Canada.

317,458 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 2 mins ago
HH
Fredericton Registered Nurse Class A (RNCA) PCN 1153775
Horizon Health Network
Fredericton, NB
- Full-time
…Program. This individual will be required to be a clinical lead utilizing a collaborative nursing model to support the educational needs of the nursing staff within the Dr. Everett Chalmers…
Added 2 mins ago
N
Enterprise Acquisition Manager
Naboo
Montreal, QC
- Full-time
…(MSAs) with large companies. You will start by building scalable programs for the enterprise segment as a whole, then progressively move toward more targeted, account-based plays as the…
Added 2 mins ago
LC
Coordinator - System (QMS)
Linamar Corporation
Guelph, ON
- Full-time
…up to closure to ensure compliance and effectiveness of the…
Added 2 mins ago
V
Regional HR Partner Lead Middle East
Vanderlande
AB · Cornwall, ON · Toronto, ON · Quebec, QC · Vancouver, BC · Fort McMurray, AB
- Full-time
Are you passionate about driving people strategy in a fast-growing and entrepreneurial region? As Regional HR Partner Lead Middle East, you will lead the regional HR Partner organization…
Added 2 mins ago
Assistant Store Manager
The Aldo Group Inc / Le Groupe Aldo Inc.
ON · Mississauga, ON
…and a key player in creating an amazing store experience. You lead by example, inspire your team to hit sales goals, and make every customer feel their best walking out the…
Added 2 mins ago
B
Senior Manager, Model & AI Governance
BMO
Toronto, ON · BMOPLACE
- Full-time
…continuously strengthening the first line Model and AI Governance programs across Canadian Personal & Business…
Added 2 mins ago
BP
Hunting Team Lead (FT)
Bass Pro Shops
Halifax, NS
- Full-time
Reporting to the Retail Manager (Hardlines), the Full Time Hunting Lead is responsible for overseeing the successful day to day operation of the Hunting department.
Added 2 mins ago
S
Project Management Specialist
Stantec
Toronto, ON
- Full-time
The Project Delivery & Consulting Specialist will lead or support multidisciplinary engagements across water, wastewater, transportation, facilities, energy, industrial, and other…
Added 2 mins ago
Manager, Customer Energy Management (Large Customers)
Toronto Hydro
Toronto, ON
Lead the delivery of exceptional customer experiences and strategic account management activities for Toronto Hydro's municipal, academic, schools, healthcare (MASH), and industrial…
Added 32 mins ago
AS
Manager of Strategy & Growth
Angler Solutions
St. John's, NL
- Contract
Coordinates strategic priorities with Angler's Commercialization Lead and Innovation & Opportunities function, so MESO commercialization and technical development stay aligned with…
Added 32 mins ago
HR
Technical Specialist, Quality Assurance
Hitachi Rail
Toronto, ON
- Full-time
Certifications: American Society of Quality (ASQ) Certification (CQE, CQA...) , ISO 9001 Lead Auditor
Added 32 mins ago
HR
Technical Specialist, Quality Assurance
Hitachi Rail
Burnaby, BC
- Full-time
Certifications: American Society of Quality (ASQ) Certification (CQE, CQA...) , ISO 9001 Lead Auditor
Added 32 mins ago
TC
3-month Term Certain, Part-Time Overnight Night Youth Worker
The Calgary John Howard Society
Calgary, AB
- Part-time
- Contract
…root causes of crime through housing, education, employment programs and support so that individuals have alternatives to breaking the law. CJHS is committed to restorative justice and an…
Added 1 hour ago
B
QNX Senior Technical Product Manager (Industrial Automation & Robotics)
BlackBerry
Ottawa, ON
- Full-time
Impactful Work: Lead high-impact product initiatives that influence growth and market positioning.
Added 1 hour ago
BQ
QNX Senior Technical Product Manager (Industrial Automation & Robotics)
BlackBerry QNX
Ottawa, ON
- Full-time
Impactful Work: Lead high-impact product initiatives that influence growth and market positioning.
Added 1 hour ago
VA
Veterinary Technician Assistant, Client Care Coordinator, VCA Canada Blue Cross Animal Hospital
VCA Animal Hospitals
Sarnia, ON
- Internship
…organizations whose head offices are located within the province and lead their industries in offering exceptional places to work. Additionally, we were selected as one of Canada's Top…
Added 1 hour ago
RA
Project Manager, Land Development - Ottawa
R.V. Anderson Associates Limited
Ottawa, ON
- Full-time
Lead the growth of the Land Development practice in Eastern Ontario and the Ottawa area through Business Development initiatives and Managing of Land Development Projects
Added 1 hour ago
SC
Customs Compliance Manager
Stoakley-Stewart Consultants Ltd.
Mississauga, ON
- Full-time
…proactively identify opportunities to strengthen client compliance…
Added 1 hour ago
SC
HVAC Service Manager
Stoakley-Stewart Consultants Ltd.
Mississauga, ON
- Full-time
Exposure to preventative maintenance programs, service contracts, repeat business, or client retention
Added 1 hour ago
SC
Inside Sales Representative
Stoakley-Stewart Consultants Ltd.
Mississauga, ON
- Full-time
Employees are supported by competitive compensation, performance-based rewards, comprehensive health-care benefits and wellness programs.
Added 1 hour ago
EW
Addiction Support Practitioner - Shunda
Enviros WSA
Calgary, AB
- Internship
is an innovative social services agency that provides critical, individualized programs to children, youth, adults and families in vulnerable situations to meet their desired outcomes and…
Added 1 hour ago
EW
Wilderness Coordinator - Shunda
Enviros WSA
Calgary, AB
- Full-time
is an innovative social services agency that provides critical, individualized programs to children, youth, adults and families in vulnerable situations to meet their desired outcomes and…
Added 1 hour ago
SC
Health, Safety & Environmental Coordinator
Stoakley-Stewart Consultants Ltd.
Cambridge, ON
- Full-time
As the Health, Safety & Environmental Coordinator, you will help lead the ongoing development, implementation and improvement of the organization’s health, safety and environmental programs.
Added 1 hour ago
PH
Senior Business Analyst, PHIS
Provincial Health Services Authority
Vancouver, BC
- Full-time
Coordinates and implements applications by ensuring documentation, writing and testing of applications and verifying that programs are functional and consistent with specifications.
Added 1 hour ago
SP
Senior Technical Architect
Salesforce Partner Canada
ON · Ontario, Canada
- Full-time
Identify and lead internal strategic initiatives to grow the consulting practice; serving as an active contributor to the community’s overall knowledge base and expertise

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, maintain, and enhance data warehousing, business intelligence, reporting, and analytics solutions for the Employment Ontario Information Systems environment. Build Informatica mappings and ETL scripts, develop Oracle SQL/PL/SQL solutions and BOE reports, fix defects, and communicate progress to management.

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 SDLC and Agile, RDBMS and data warehouse design, strong analytical and communication skills, and the ability to collaborate and mentor junior developers.

Skills

Data Warehousing
Business Intelligence
ETL Development
Oracle SQL
PL/SQL
Informatica
Crystal Reports
Power BI
Business Objects Enterprise
Report Development
Dimensional Modeling
RDBMS Design
Agile
SDLC
Data Warehouse Architecture
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
Oracle Database
Business Objects Universe
Dashboarding
Data Marts
OLTP
Dimensional Modeling
RDBMS
SDLC
Agile
JEE
CURAM
Web-Based Applications
Reporting
Analytics
Data Warehouse Architecture
Unit Testing
Defect Fixing
Accessibility for Ontarians with Disabilities Act
Employment Ontario Information Systems
Application Development
Technical Documentation

Report this job