Senior Software Developer – ETL

Position: Software Developer – ETL – Senior

Client: Labour and Transportation Cluster, Ontario Government

Ministry: Ministry of Public and Business Service Delivery and Procurement

Location: 400 University Ave, Toronto, ON

Work Arrangement: 100% Onsite

Contract: October 5, 2026 – March 31, 2027

Extension: Up to 134 additional days; maximum 1 extension term

Openings: 1

Security Clearance: No clearance required

About the Role

The Ontario Government's Employment and Training Division delivers Employment Ontario, a major program supporting Ontarians in gaining the training, skills, and experience needed to achieve their employment and career goals.

The Employment Ontario Information Systems (EOIS) is the primary IT environment supporting the administration of Employment Ontario programs. The environment includes CaMS, Service Provider lifeCycle (SPL), EO Self Service (EOSS), APPR, Ontario Job Grant (OJG), and APPR Apply Online (AOL).

The successful Senior Software Developer – ETL will support the design, development, testing, maintenance, and enhancement of data warehousing, ETL, business intelligence, reporting, and analytics solutions.

The environment includes JEE, CURAM, Crystal Reports, Oracle SQL/PL/SQL, Oracle Database, Power BI, BusinessObjects Enterprise (BOE), BusinessObjects Universe, WebI, dashboarding, bursting technologies, and Informatica ETL.

Key Responsibilities

• Perform analysis, design, development, unit testing, defect fixing, troubleshooting, and documentation within data warehousing and business intelligence environments.
  
• Design, develop, test, and maintain Informatica mappings.
  
• Design and develop ETL processes/scripts to extract, transform, and load data from OLTP databases into Data Warehouses and Data Marts.
  
• Design, develop, test, and maintain Oracle SQL and PL/SQL solutions.
  
• Design and develop Crystal Reports, Power BI reports, and BOE reports.
  
• Develop and maintain business intelligence, reporting, analytics, and data warehousing solutions.
  
• Work with Data Warehouse architecture, dimensional modelling, reporting, and ETL concepts.
  
• Analyze and design changes to existing web-based software solutions.
  
• Participate throughout the Software Development Life Cycle (SDLC), including Agile development activities.
  
• Perform application design, coding, testing, debugging, deployment, troubleshooting, and technical documentation.
  
• Identify defects and implement appropriate technical fixes.
  
• Communicate development progress, issues, risks, and solutions clearly and in a timely manner to management and project stakeholders.
  
• Collaborate with IT professionals, business stakeholders, and subject matter experts.
  
• Participate in technical discussions and design walkthroughs.
  
• Provide post-implementation technical support and resolve production issues.
  
• Mentor junior developers and contribute to technical direction where required.
  

Requirements

Mandatory Qualifications

Candidates must demonstrate all of the following:

1. Data Warehousing & BI – 5+ Years

• 5+ years of experience performing analysis, design, development, unit testing, defect fixing, and related activities in Data Warehousing and Business Intelligence environments.
  

2. Crystal Reports, Power BI & BOE – 5+ Years

• 5+ years of experience designing and developing:
  
• Crystal Reports
  
• Power BI
  
• BusinessObjects Enterprise (BOE) reports
  

3. Oracle SQL / PL/SQL – 5+ Years

• 5+ years of experience designing, developing, and testing Oracle SQL and PL/SQL.
  
• Strong understanding of Oracle databases and relational database concepts.
  

4. Informatica – 5+ Years

• 5+ years of experience designing, developing, and testing Informatica solutions, including Informatica mappings and ETL processes.
  

5. Data Warehouse Design & ETL

• Experience with:
  
• Data Warehouse design
  
• Reporting
  
• ETL concepts
  
• Data Warehouse architecture
  
• Dimensional modelling
  
• Development and deployment of Business Intelligence systems
  

6. SDLC / Agile

• Complete knowledge of Software Development Life Cycle (SDLC) methodologies.
  
• Working experience with Agile development methodology.
  

7. Software Development & Analysis

• Experience with technology solutions and software development methodologies.
  
• Experience analyzing and designing changes to existing web-based software solutions.
  
• Experience with application design, coding, testing, debugging, documentation, deployment, and troubleshooting.
  

8. RDBMS

• Demonstrated experience with RDBMS design concepts.
  
• Experience working with relational and/or hierarchical database technologies.
  
• Experience using query languages and information retrieval packages.
  

9. Risk & Problem Solving

• Demonstrated experience identifying technical risks and providing solutions.
  
• Strong analytical, problem-solving, and decision-making skills.
  

Communication & Collaboration Skills

• Ability to build and maintain strong working relationships with technical and business stakeholders.
  
• Positive and collaborative team player.
  
• Excellent verbal and written communication skills.
  
• Strong analytical and problem-solving capabilities.
  
• Ability to present technical information effectively to both technical and non-technical audiences.
  
• Ability to elicit and document information from diverse business stakeholders and subject matter experts.
  
• Track record of meeting project deadlines.
  

Leadership & Mentoring

• Ability to mentor junior developers.
  
• Ability to lead and participate in technical discussions.
  
• Experience conducting design walkthroughs with project teams.
  
• Ability to communicate technical risks, issues, dependencies, and proposed solutions effectively.
  

General Technical Experience

The successful candidate should also have experience with:

• Structured methodologies for application development, design, implementation, and maintenance.
  
• Object-oriented and/or third-generation programming languages.
  
• Internet-ready applications.
  
• Application deployment and troubleshooting.
  
• Middleware and gateways.
  
• Reviewing, analyzing, modifying, testing, and debugging product installation scripts.
  
• Post-implementation support and resolution of technical issues.
  
• User and system documentation.
  

Desirable Skills

• Knowledge of Rapid Application Development (RAD) methodologies.
  
• Knowledge and understanding of Information Management principles, concepts, policies, and practices.
  
• Experience with middleware and gateway technologies.
  
• Knowledge and understanding of Accessibility for Ontarians with Disabilities Act (AODA) requirements, regulations, and standards.
  
• Experience providing post-implementation support.
  
• Experience with design walkthrough sessions.
  
• Experience developing and maintaining user/system documentation.
  

Technology Environment

Candidates may be required to work with technologies including:

Oracle SQL | Oracle PL/SQL | Oracle Database | Informatica ETL | Crystal Reports | Power BI | BusinessObjects Enterprise (BOE) | BusinessObjects Universe | WebI | Dashboarding | Bursting Technologies | JEE | CURAM

Candidate Profile

The ideal candidate is a Senior ETL / BI Developer with strong hands-on experience across Informatica, Oracle SQL/PLSQL, Crystal Reports, Power BI, BOE, Data Warehousing, ETL, and Business Intelligence.

Candidates must be able to demonstrate 5+ years of experience specifically in Data Warehousing/BI, Crystal Reports + Power BI + BOE, Oracle SQL/PLSQL, and Informatica. Strong SDLC/Agile experience, RDBMS knowledge, Data Warehouse architecture and dimensional modelling experience, and the ability to communicate effectively with technical and business stakeholders are essential.

This is a 100% onsite position in downtown Toronto, and only one candidate can be submitted. Candidates should therefore be thoroughly screened against every mandatory requirement before submission.