Senior Software Developer – ETL We are hiring a Senior Software Developer – ETL to support the Ministry of Public and Business Service Delivery and Procurement in designing, developing, optimizing, and maintaining enterprise data integration and data warehousing solutions. The successful candidate will have strong hands-on experience in ETL/ELT development, Oracle, PL/SQL, advanced SQL, Azure Data Factory, Azure SQL, data warehousing, dimensional data modeling, data migration, data integration, Python/Unix scripting, and cloud technologies. The role requires expertise in transforming data from complex and highly normalized source systems into scalable, high-quality data assets and analytical structures.
The ideal candidate will also have experience supporting large, complex, mission-critical applications, troubleshooting data and application issues, performance tuning, database administration, Agile/Waterfall SDLC methodologies, and working with public-sector environments.
Role Snapshot Requisition: RQ10840 – Software Developer – ETL – Senior Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 40 St Clair W, Toronto, Ontario – Hybrid Estimated Start Date: September 14, 2026 Estimated End Date: March 31, 2027 Estimated Business Days: 133 Extension: Probable after the initial mandate Work Hours: 7.25 hours per day Security Clearance: No Clearance Required Application Deadline Wednesday, August 12, 2026, at 10:00 AM EST If you are interested and your profile matches the requirements, please submit the mandatory documents below to
[email protected] by the deadline.
Mandatory Submission Documents Updated
Resume in Word format – Mandatory
References – Mandatory
Expected hourly rate – Mandatory
Visa Status – Mandatory
LinkedIn ID – Mandatory Important: Without all mandatory documents, we cannot submit a candidate.
Key Responsibilities Data Warehousing & ETL/ELT Development
Design, implement, expand, automate, and optimize enterprise data pipelines.
Perform data extraction, transformation, cleansing, and loading from multiple source systems.
Design and develop data warehouse solutions using star and snowflake schemas.
Develop complex ETL/ELT processes using PL/SQL and equivalent technologies.
Develop complex procedures, packages, views, scripts, and other database components for:
Data de-normalization
Data extraction
Data transformation
Data cleansing
Data loading
Create denormalized data assets from highly normalized Oracle databases.
Load transformed data assets into different DBMS platforms including Microsoft SQL Server, PostgreSQL, and other relational databases.
Continuously improve existing ETL processes to enhance scalability, maintainability, performance, and reliability.
Azure Data Engineering & Cloud Technologies
Design and develop data solutions using cloud technologies including Azure, AWS, and Google Cloud.
Develop and maintain solutions using Azure SQL Server and Azure Data Factory.
Create Azure Data Factory pipelines using Copy Activity and custom Azure development.
Configure and optimize data pipelines to support enterprise data integration requirements.
Troubleshoot Azure-based ETL and data integration processes.
Support cloud-based data architecture and ensure solutions are scalable and maintainable.
Oracle, SQL & Database Development
Develop advanced SQL and PL/SQL solutions for complex data processing requirements.
Develop database procedures, packages, views, scripts, and other database objects.
Perform query optimization and database performance tuning.
Support relational databases including
Oracle
MySQL
Microsoft SQL Server
PostgreSQL
Perform data replication, database administration, data migration, and integration activities.
Support Oracle environments including Oracle RAC, Data Guard, Exadata, Oracle Enterprise Manager, and Oracle Warehouse Builder.
Use RMAN for database recovery, restore, and refresh activities across production, development, UAT, and test environments.
Support database change tracking and data warehousing using PL/SQL.
Data Migration & Integration
Design and implement data migration and integration solutions across multiple platforms and operating systems.
Perform data migration between Windows and UNIX environments and between heterogeneous database platforms.
Develop transformation logic to ensure source data is accurately converted into target structures.
Investigate data quality and integration issues within ETL pipelines.
Identify potential problems, notify stakeholders, and recommend appropriate solutions.
Ensure migrated and integrated data meets business, technical, and quality requirements.
Data Quality, Analytics & Performance Optimization
Work with business stakeholders to understand data requirements and develop high-quality data solutions.
Perform data analysis and investigate source data to identify potential quality issues.
Support Business Intelligence and data analytics initiatives.
Design and maintain dimensional and relational data models.
Optimize database and web database performance.
Conduct proof-of-technology activities using test data to simulate application load and performance conditions.
Tune data pipelines, databases, and applications to improve performance and reliability.
Support failover, recovery, and operational continuity requirements.
Application Development & Technical Analysis
Translate technical system specifications into working, tested applications and data solutions.
Develop detailed programming specifications and technical designs.
Write, generate, compile, test, debug,
and maintain data-driven programs.
Conduct unit testing and support QA activities.
Develop and maintain system design models, technical documentation, and specifications.
Evaluate technical design options, integration capabilities, tools, utilities, and application configuration requirements.
Perform gap analysis between integration components and technical requirements.
Support complex, multi-tier web applications, microservices architectures, and commercial off-the-shelf solutions.
Technical Troubleshooting & Production Support
Troubleshoot technical problems arising during software and data solution operation.
Provide technical support during implementation, conversion, migration, and production activities.
Investigate application, database, ETL, integration, and performance issues.
Provide application programming support for incident management and application functionality sustainment.
Support post-implementation activities and resolve technical issues.
Conduct performance tuning and recommend technical improvements.
Work with QA teams to code, test, and debug extensions, tools, and integration services.
Agile Delivery & SDLC
Work across the complete Software Development Life Cycle.
Apply Agile/Scrum and Waterfall methodologies as appropriate.
Collaborate with Business Analysts to translate business requirements and functional specifications into technical solutions.
Participate in project planning, work breakdown, resource estimation, technical design, development, testing, and implementation.
Conduct design walkthroughs and technical evaluation sessions.
Work closely with QA teams to ensure solutions are fully tested and production-ready.
Ensure solutions comply with applicable architecture frameworks, system standards, security, privacy, and usability requirements.
Documentation & Technical Governance
Prepare detailed technical and operational documentation for future reference.
Document data architecture, ETL processes, data models, technical specifications, deployment procedures, and support processes.
Ensure technical deliverables comply with applicable standards and architecture frameworks.
Produce documentation using industry-standard practices.
Support Enterprise Architecture and project governance processes.
Ensure deliverables align with applicable Government of Ontario IT standards and methodologies.
Required Skills &
Experience Skill / Experience Requirement / Weight Technical / ETL Skills 40% Core Development & Data Engineering Skills 30% Public Sector Experience 5% General / Communication Skills 25% Data warehousing and ETL/ELT 5+ years Advanced SQL / PL/SQL / T-SQL 5+ years Azure Data Factory / Azure SQL 5+ years Relational & dimensional data modeling 5+ years Oracle database development 5+ years Data migration and integration 5+ years Python / Unix shell scripting Required Cloud technologies Required Agile/Scrum/Waterfall SDLC Required Azure DevOps / JIRA Required GitHub Required Experience & Skill Set Requirements Technical / ETL Skills – 40% 5+ years of experience with: Data warehousing design and development, with a focus on extracting, transforming, and loading data from multiple source systems into star and snowflake schemas.
Designing, building, automating, and optimizing complex ETL/ELT processes using PL/SQL or equivalent technologies.
Writing complex procedures, packages, views, and scripts for data de-normalization, extraction, transformation, cleansing, and loading.
Creating denormalized data assets from highly normalized Oracle databases and loading those assets into other DBMS platforms such as Microsoft SQL Server and PostgreSQL.
Relational databases including Oracle, MySQL, and SQL Server.
Relational and dimensional data modeling.
Advanced SQL, query optimization, data replication, and database administration.
Advanced PL/SQL and T-SQL.
Scripting languages including Python and Unix shell.
Cloud technologies including Azure, Google Cloud, and AWS.
Advanced hands-on experience with Azure SQL Server and Azure Data Factory.
Creating Azure Data Factory pipelines using Copy Activity and custom Azure development.
PL/SQL-based data extraction, transformation, loading, ETL setup, troubleshooting, performance tuning, failover, and recovery.
Elasticsearch for search/reporting and performance optimization.
JIRA and/or Azure DevOps for issue tracking and project delivery.
GitHub for version control and data model changes.
Oracle Enterprise Manager, Oracle RAC, Data Guard, Exadata, Oracle Warehouse Builder, Oracle networking technologies, and related Oracle infrastructure.
PL/SQL programming for database change tracking and data warehousing.
Data migration and integration across different operating systems and database platforms.
RMAN-based database recovery, restore, and refresh for production, development, UAT, and test environments.
Core Skills – 30% 5+ years of experience with: Technical analysis, programming, detailed programming specifications, program design, coding, and unit testing.
Software development across different computing platforms, operating systems, database technologies, communication protocols, middleware, and gateways.
Developing and maintaining system design models, technical documentation, and specifications.
Evaluating technical design options and application configuration requirements.
Assessing integration capabilities, tools, utilities, and technical design alternatives.
Performing gap analysis between integration components and technical requirements.
Business Intelligence, data analytics, data warehouse design, dimensional data modeling, and relational data modeling.
Researching and assessing options for complex technical design issues.
Contributing to project plans, work breakdown structures, and resource estimates.
Working with Business Analysts to translate requirements and functional specifications into appropriate application and data solutions.
Translating technical specifications into working, tested solutions for large, complex, mission-critical applications.
Working with QA teams to code, test, and debug extensions, tools, and integration services.
Analysis, design, and development of complex multi-tier web-based applications, microservices, and off-the-shelf solutions.
Providing technical leadership and identifying opportunities for improvement.
Conducting proof-of-technology activities using test data for application load and performance tuning.
Providing application programming support for incident management, application sustainment, performance tuning, and technical documentation.
Web database performance optimization.
Ensuring compliance with architecture frameworks, system standards, Agile development practices, security, usability, and privacy requirements.
End-to-end SDLC using Agile/Scrum and Waterfall methodologies.
Working with leading-edge technologies and applying appropriate design criteria.
Public Sector Experience – 5%
Experience working on inter-jurisdictional projects involving federal, provincial, and/or municipal governments.
Knowledge of provincial environmental services and the legislative framework governing related data.
Experience with data migration and integration across environmental systems.
Knowledge of OPS Enterprise Architecture artifacts, processes, and practices.
Ability to produce technical documentation in accordance with industry and government standards.
Experience adopting and adhering to OPS Unified I⁢ Project Methodology.
Knowledge of OPS Enterprise Architecture and gating processes.
Experience working with OPS Standard Systems Development Methodologies.
General Skills – 25%
Exceptional analytical, problem-solving, and decision-making abilities.
Robust troubleshooting and critical-thinking skills.
Excellent verbal and written communication skills.
Strong interpersonal and stakeholder-management capabilities.
Ability to listen actively and facilitate effective issue resolution.
Strong consulting skills and proven ability to build productive relationships with stakeholders.
Excellent customer service skills, with tact and diplomacy when managing client needs.
Highly motivated, flexible, detail-oriented, and creative.
Strong organizational and multitasking abilities.
Proven ability to work effectively as part of a technical team.
Demonstrated perseverance and ability to work under pressure.
Proven track record of delivering work within strict deadlines. ETL & Data Engineering Capabilities The Successful Candidate Should Demonstrate The Ability To Gather requirements and understand business processes to transform data according to end-user needs.
Maintain, enhance, and optimize existing ETL processes.
Design scalable and maintainable data architectures.
Work directly with business stakeholders to design and deliver accurate, high-quality data.
Investigate data to identify potential ETL pipeline issues.
Communicate data quality and pipeline issues to end users and stakeholders.
Propose effective technical solutions to data and integration problems.
Prepare detailed technical documentation for future reference.
Support data architecture, integration, migration, and analytics requirements across enterprise environments.
Desirable Skills
Knowledge and experience developing Internet-ready applications.
Experience with Rapid Application Development (RAD) and Agile methodologies.
Knowledge of Information Management principles, concepts, policies, and practices.
Experience with middleware and gateways.
Experience reviewing, analyzing, modifying, encoding, testing, and debugging product installation scripts.
Ability to provide post-implementation support and resolve technical issues.
Experience conducting technical design walkthroughs with project teams.
Knowledge and understanding of AODA and related regulations and standards.
Ability to prepare user and system documentation.
Experience with cloud-native data engineering and modern data integration architectures.
Experience with microservices and multi-tier application environments.
Experience with Elasticsearch and search/reporting optimization.
How to Apply If this opportunity matches your experience and interests, please submit the following mandatory documents to
[email protected] by Wednesday, August 12, 2026, at 10:00 AM EST: Updated Resume in Word format – Mandatory
References – Mandatory
Expected hourly rate – Mandatory
Visa Status – Mandatory
LinkedIn ID – Mandatory Applications submitted without all mandatory documents cannot be processed. If this role is not suitable for you, please feel free to share it with qualified Senior ETL Software Developers / Data Engineers with strong experience in Oracle, PL/SQL, advanced SQL, Azure Data Factory, Azure SQL, data warehousing, ETL/ELT, dimensional modeling, data migration, cloud technologies, Python/Unix scripting, database performance tuning, and enterprise data integration.
📌 Software Developer - ETL - Senior (Toronto)
🏢 S M Software Solutions
📍 Toronto