Find work in Canada.

325,804 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 44 mins ago
P
Business Intelligence Data Warehouse Consultant
ProxyLink
Toronto, ON
- Contract
The BI & Data Warehouse Developer will work closely with technical teams, business stakeholders, and project professionals throughout the Software Development Life Cycle (SDLC). The role…
Added 2 hours ago
SI
Senior BI / Data Warehouse Developer
Siri InfoSolutions, Inc.
ON · Ontario, Canada
- Contract
We are looking for an experienced BI / Data Warehouse Developer with strong expertise in Oracle SQL/PLSQL, Informatica, Crystal Reports, Power BI, and Business Objects Enterprise (BOE).
Added 10 hours ago
R
Lead Quality Engineer - Data
RBC
Toronto, ON
- Full-time
Experience in ETL Tools like IICS, Informatica Power Center or similar and ETL scheduler tools
Added 15 hours ago
C
Stage coopératif - Hiver 2027: Développeur BI (4 mois)
CGI
Saguenay, QC
- Full-time
Knowledge of other ETL tools is considered an asset, including SSIS, Talend, Informatica, etc.;
Added 20 hours ago
RB
Lead Quality Engineer - Data
Royal Bank of Canada
Toronto, ON
- Full-time
Experience in ETL Tools like IICS, Informatica Power Center or similar and ETL scheduler tools
Added 1 day ago
BR
Senior Software Engineer
BITS Recruiting
Toronto, ON
- Contract
Our client is seeking a Senior Software Developer – ETL to support the design, development, testing, maintenance, and enhancement of data warehousing, ETL, business intelligence, reporting,…
Added 1 day ago
M
RQ11635 - Software Developer - ETL - Senior
Maarut
Toronto, ON
- Contract
Universe and Dashboarding, WebI, Bursting technologies, and Informatica ETL.
Added 1 day ago
SD
Senior BI Developer
Symbiotic Digital
ON · Downtown Toronto (Central Bay Street), Ontario
- Contract
We are seeking a strong Software Developer – ETL to support
Added 2 days ago
IF
Senior Data Developer
Intact FC
Montreal, QC
- Full-time
We are looking for a Senior Data Developer (Engineer) to help establish the data foundation for Contact Distributor, Intact’s new platform for broker and distributor master data. The…
Added 2 days ago
IS
Senior PL/SQL / DB2 Database Developer
ITMC Systems, Inc
Montreal, QC
- Contract
Practical knowledge of Informatica PowerCenter ETL workflows.
Added 4 days ago
S
Patient Experience iCare Exchange Integrations Engineer
Sanofi
Toronto, ON
- Full-time
Expert-level proficiency in Informatica Intelligent Cloud Services (IICS), Python, Snowflake, and AWS cloud services and architecture.
Added 4 days ago
NV
Senior Business Intelligence Developer (ID#5552)
New Value Solutions
Vancouver, BC · Greater Vancouver, BC
- Contract
Experience with Cognos Report Studio, Cognos TM1, Tableau, Informatica, or similar BI/ETL tools.
Added 4 days ago
B
Senior ETL Developer
Bevertec
Toronto, ON
- Contract
5+ years’ experience in Designing, developing and testing in Informatica.
Added 4 days ago
2I
Senior ETL Developer
2iSolutions Inc.
Toronto, ON
- Contract
5+ years' experience in Designing, developing and testing in Informatica.
Added 4 days ago
W
Microsoft Analytics Developer
Workiy
Vancouver, BC
- Contract
Experience with ETL tools such as SSIS or Informatica
Added 5 days ago
PS
Junior SQL/ ETL Developer
Prodigy Systems Inc.
Toronto, ON
- $35 to $40 CAD / hour
- Contract
We're looking for a Junior SQL/ETL Developer for a 6 months contract with high possibility of extension. Role is hybrid with 2 days a week on site in Downtown Toronto.
Added 6 days ago
Mainframe Developer
Capgemini
Mississauga, ON
Design and support ETL solutions using Informatica PowerCenter/IICS.
Added 7 days ago
ES
ETL Developer (Insurance Domain)
Enterprise Solutions Inc.
Markham, ON
- Contract
Experience in building ETL workflows using Informatica PC
Added 7 days ago
T
Architect
TechDoQuest
Toronto, ON
- Contract
Expertise in design and orchestrating data acquisition pipelines using AWS Glue for ETL/ELT, Snowflake OpenFlow and Apache Airflow for workflow automation, enabling seamless ingestion of…
Added 8 days ago
RB
Senior Data Engineer
Royal Bank of Canada
Vancouver, BC
- Full-time
…Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that power our enterprise data ecosystem. In this critical role, you will design end-to-end data solutions…
Added 8 days ago
R
Senior Data Engineer
RBC
Vancouver, BC
- Full-time
…Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that power our enterprise data ecosystem. In this critical role, you will design end-to-end data solutions…
Added 8 days ago
C
Oracle PL/SQL / Informatica Developer
CGI
Halifax, NS
- Full-time
We are seeking an experienced Senior Database Developer to join a high performing technology team supporting large scale, business critical applications. The successful candidate will bring…
Added 8 days ago
C
Director - Enterprise Data Warehouse and Data Platforms
CGI
Ottawa, ON
- Full-time
Provide technical leadership across enterprise data warehousing, data modelling, ETL/ELT, batch and streaming pipelines, data quality, metadata, governance, security, and analytics.
Added 8 days ago
TT
Senior Data Engineer
Tundra Technical Solutions
Toronto, ON
- $70 to $77 CAD / hour
- Contract
Build and optimize ELT/ETL processes for structured, semi-structured, and unstructured data sources.
Added 9 days ago
H
ETL Tester
Hays
Toronto, ON
- Contract
ETL & Data Integration : Informatica PowerCenter

Closed listing

S M Software Solutions Inc

RQ11635 – Software Developer – ETL – Senior

Toronto, ON, Canada

Internship

This opening has closed.

The original listing is kept below for reference.

Find open jobs More jobs with this employer

About employer

Job details

Job type: Internship
Closing date: Nov 4, 2026
Posting language: English
Posted: Oct 5, 2026

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

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.

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 methods, 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 Modeling
RDBMS Design
Agile Development
Reporting and Analytics
Unit Testing

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
Oracle Database
Data Marts
OLTP
Data Warehouse Architecture
Dimensional Modeling
RDBMS
Employment Ontario Information Systems
EOIS
JEE
CURAM
Business Objects Universe
Dashboarding
Web Intelligence
Bursting Technologies
SDLC
Agile Development
Unit Testing
Defect Fixing
AODA
Application Development

Report this job