Enter a job title or keyword
Senior Software Developer – ETL
Job Location:
Monthly Salary:
Experience Required:
Posted:
3 October 2026 (Yesterday)
Posted:
Application Deadline:
31 December 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
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 Governments 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.
Required Skills:
Dynamics 365 CRM Dynamics 365 Customer Service Microsoft Power Platform Power Apps Dataverse Azure Azure Solution C# JavaScript Web Core Entity Framework Azure SQL DevOps CI/CD Pipelines Customer Service Workspace Case Management Knowledge Management Agent Experience Profiles Session Templates Workstreams Routing Model-Driven Apps Canvas Apps Power Pages PCF Controls Liquid Agile Kanban Task Boards SDLC Unit Testing Technical Troubleshooting Application Integration Technical Documentation Requirements Gathering AODA
Required Education:
Bachelors degree or college/university education in Computer Science Information Technology Software Engineering Computer Engineering Data Analytics or a related field.
