Find work in Canada.

318,860 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 3 mins ago
S
Rotating Equipment Manager
Shell
Scotford, AB
- Full-time
The Rotating Equipment Manager provides technical leadership across rotating equipment disciplines, driving the implementation of programs that enhance equipment performance and…
Added 3 mins ago
Compliance Assurance Lead
Government of Alberta
Peace River, AB
Lead various compliance program enhancement initiatives and projects on behalf of the District compliance team, ranging from assisting with the development of the operational plan to…
Added 32 mins ago
C-
Commercial HVAC Service Technician
Captiveaire - Region 114 Western PA
Rivière-Saint-Jean, QC
- Full-time
Leader in the industry for over 40 years with innovative technologies, unmatched service, competitive pricing, and rapid lead times.
Added 32 mins ago
C-
Commercial HVAC Service Technician
Captiveaire - Region 114 Western PA
PE · Prince, PE
- Full-time
Leader in the industry for over 40 years with innovative technologies, unmatched service, competitive pricing, and rapid lead times.
Added 32 mins ago
C-
Technical Sales Intern- Mississauga
Captiveaire - Region 114 Western PA
Mississauga, ON
- Volunteer
NOTE: Excellent performance may lead to full-time employment opportunities in sales, field service or other engineering roles upon graduation.
Added 32 mins ago
C-
Commercial HVAC Service Technician
Captiveaire - Region 114 Western PA
Montreal, QC
- Full-time
Leader in the industry for over 40 years with innovative technologies, unmatched service, competitive pricing, and rapid lead times.
Added 47 mins ago
FA
Maintenance Control Supervisor
Flair Airlines Ltd.
Toronto, ON
- Full-time
Join Flair’s Maintenance team, where real-time technical oversight supports aircraft safety, availability, and operational reliability. Reporting to the Manager, Maintenance Control, the…
Added 47 mins ago
T
Staff Software Engineer
Twilio
Remote, Canada
- Full-time
- Remote
As a Staff Software Engineer (P4), you will be a key technical leader for a platform that processes millions of requests. You will build innovative solutions while working closely with…
Added 1 hour ago
HJ
CAMO ENGINEER
Hongkong Jet
Engineer, BC
- Full-time
Lead and manage engineering projects related to fleet upgrades, modifications, and other technical improvements.
Added 1 hour ago
BC
Sales Development Representative (SDR)
Boast Capital LP
Toronto, ON · Vancouver, BC
- $60,000 to $70,000 CAD / year
- Full-time
…streamlined, scalable engine for growth. By combining deep technical and R&D tax expertise with purpose-built AI, Boast helps companies across Canada and the U.S. unlock critical funding…
Added 1 hour ago
WL
Application Specialist
Wainbee Limited
Saguenay, QC
- Full-time
Looking for a career where technical expertise meets project leadership?
Added 1 hour ago
WL
Application Specialist
Wainbee Limited
Pointe-Claire, QC
- Full-time
Looking for a career where technical expertise meets project leadership?
Added 1 hour ago
S&
Mechanical Project Designer - Nuclear
Sargent & Lundy
Toronto, ON · North York, ON
- Full-time
Under the direction of the Mechanical Project Lead, this position will offer you the opportunity to work with multi-disciplined engineering and design project teams in developing mechanical…
Added 1 hour ago
S&
Mechanical Engineer 2 - Nuclear
Sargent & Lundy
Toronto, ON · North York, ON
- Full-time
Technical specifications and procurement documents for plant equipment
Added 1 hour ago
PSR Catalog & TM Forum Enterprise Architect
Prodapt
Canada
We are seeking a PSR Catalog & TM Forum Enterprise Architect to lead the architecture, governance, and end-to-end design of the Product-Service-Resource (PSR) catalog model across the…
Added 1 hour ago
KM
(sr) Branch Service Manager/Gestionnaire de succursale, Service (Maritimes)
Konica Minolta Business Solutions (Canada) Ltd.
Dartmouth, NS
- Full-time
At KMBS, we don’t just provide technical service - we create an exceptional customer experience. We are looking for a passionate leader, capable of guiding a team of customer-focused…
Added 1 hour ago
FH
Data Engineer
Fraser Health
Surrey, BC
- Full-time
As a Data Engineer, you will lead the team in data strategy, analysis, integration, and management. Your work will significantly impact the delivery and utilization of our data products…
Added 1 hour ago
FH
Senior Data Engineer
Fraser Health
Surrey, BC
- Full-time
Provides leadership to staff assigned to lead small to medium scale projects by providing guidance on project requirements, budget management, or technical issues; rec
Added 1 hour ago
G
Senior Claims Handler
Gallagher
BC · Surrey, British Columbia
- Full-time
…believe that when businesses are protected, they’re free to grow, lead, and innovate. You’ll be backed by our digital ecosystem: a client-centric suite of consulting tools making it easier…
Added 1 hour ago
G
Account Manager, Entertainment
Gallagher
Toronto, ON
- Full-time
…believe that when businesses are protected, they’re free to grow, lead, and innovate. You’ll be backed by our digital ecosystem: a client-centric suite of consulting tools making it easier…
Added 1 hour ago
K
Senior Manager, Turnaround & Restructuring - Deal Advisory
KPMG
ON · Toronto, Ontario
- Full-time
Lead formal insolvency filings, including managing a variety of stakeholders and external advisors, preparing reports to the court as court officer, securing assets, and supervising a team…
Added 1 hour ago
K
Senior Manager, Transaction Services
KPMG
Vancouver, BC
- Full-time
As a Senior Manager in Transaction Services, you will lead complex engagements and multidisciplinary teams, work closely with Partners and senior client executives, and apply both strong…
Added 1 hour ago
K
Enterprise Architect, AI Engineering – Security & Compliance
KPMG
Toronto, ON · ON
- Full-time
…management and production readiness. You will manage high-level technical architecture, ensure alignment with KPMG enterprise standards, and help establish the controls, patterns and…
Added 1 hour ago
AC
Early Careers: Actuarial Intern, Retirement Consulting - Winter 2027
Aon Corporation
Calgary, AB
- Full-time
Provide routine technical and analytical support to ensure the continuous efficient operation of our clients' pension plan arrangements;
Added 2 hours ago
PC
Risk Modelling Services, Actuarial P&C Director (Bilingual FR/EN)
PwC Canada
Toronto, ON
- Full-time
Lead, manage and grow our Quebec P&C Actuarial Services team, including team development, client service delivery and business growth

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 2, 2026
Posting language: English
Posted: Oct 3, 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. Develop Informatica mappings and ETL scripts, work with Oracle SQL/PL/SQL, maintain Business Objects Enterprise 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
Data Warehouse Design
Dimensional Modelling
RDBMS Design
Agile
SDLC
Reporting
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 Modelling
RDBMS
SDLC
Agile
JEE
CURAM
Web Intelligence
Bursting Technologies
Employment Ontario Information Systems
Data Warehouse Architecture
Reporting
Analytics
Unit Testing
Defect Fixing
Accessibility for Ontarians with Disabilities Act

Report this job