RQ11635 – Software Developer – ETL – Senior

S M Software Solutions Inc; Toronto; On-site; CAD 110,000 - 140,000; Full time

Job summary

Ministry of Public and Business Service Delivery and Procurement seeks a Senior Software Developer – ETL to design, develop and test data warehousing, BI reporting and ETL solutions for EOIS. The role requires strong Oracle SQL/PL/SQL, Informatica and BOE expertise.

You will work onsite at 400 University Ave, Toronto, with a 7.25-hour day, 125 business days, and a March 31, 2027 end date. The assignment starts Oct 5, 2026, with Agile development and SDLC experience essential.

Qualifications

• 5+ years in data warehousing, BI, and ETL lifecycle.
• 5+ years designing Crystal Reports, Power BI, and BOE reports.
• 5+ years Oracle SQL/PLSQL development and testing.
• 5+ years Informatica mappings design, development and testing.
• Solid SDLC and Agile development experience.

Responsibilities

• Design and develop data warehousing, BI, reporting and analytics.
• Develop ETL scripts to transfer data to Data Warehouse and Data Marts.
• Design, develop and test Informatica mappings.
• Develop and maintain BOE reports.
• Collaborate with IT and management; communicate progress clearly.
• Must have skills in Crystal Reports, Informatica, Power BI and BOE reporting.

Skills

Data warehousing

BI environment

Crystal Reports

Power BI

BOE reporting

Oracle SQL

PL/SQL

Informatica

SDLC

Agile development

RDBMS concepts

ETL development

Data Warehouse design

Tools

Crystal Reports

Power BI

Informatica

BOE

Oracle SQL

PL/SQL

Job description

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

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.