Software Developer - ETL - Senior
- Toronto, ON, Canada
- Greater Toronto Area, Canada, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 7+ years of experience developing and documenting ETL processes for data conversion and migration projects
- Posting language
- English
- Posted
Original job description
Sign in to apply for this position Sign In to Apply
Ref: RQ10575 Contract – 10 Months (Extension Possible) Onsite – Toronto (21 College Street)
Posted Date: 2026-10-22
Location: Onsite – Toronto (21 College Street)
Public Sector Experience: Required – OPS / Public Sector
Contract End Date: 2027-10-05 *
Rate: $101/hour
Overview
Justice Technology Services (JTS), under the Ministry of Public and Business Service Delivery and Procurement, is seeking a Senior Software Developer – ETL to support a critical digital transformation initiative. The successful consultant will provide best-practice migration solutions and oversee all aspects of data and file migration from legacy applications to a modernized solution. This is a hands-on senior technical role requiring deep expertise in ETL development, data profiling, and enterprise-scale data migration.
Key Responsibilities
This is a fully onsite position located at 21 College Street, Toronto. The consultant is expected to work 7.25 hours per calendar day between 8:00 AM and 5:00 PM (excluding breaks), Monday to Friday. A Security Level of CRJMC is required for this role. Please note that the start date is subject to change based on security clearance and contract signing timelines.
Previous Job Job Listings Next Job
Ref: RQ10575 Contract – 10 Months (Extension Possible) Onsite – Toronto (21 College Street)
Posted Date: 2026-10-22
Location: Onsite – Toronto (21 College Street)
Public Sector Experience: Required – OPS / Public Sector
Contract End Date: 2027-10-05 *
Rate: $101/hour
Overview
Justice Technology Services (JTS), under the Ministry of Public and Business Service Delivery and Procurement, is seeking a Senior Software Developer – ETL to support a critical digital transformation initiative. The successful consultant will provide best-practice migration solutions and oversee all aspects of data and file migration from legacy applications to a modernized solution. This is a hands-on senior technical role requiring deep expertise in ETL development, data profiling, and enterprise-scale data migration.
Key Responsibilities
- Design and implement best-practice ETL migration solutions for data and file conversion from legacy systems to new modernized platforms
- Analyze legacy data and files stored across a variety of data sources and formats, completing thorough data profiling activities
- Develop and execute data migration strategy including data mapping, interface definitions, mock conversions, enhancements, and actual conversion runs
- Translate technical system specifications into working, tested applications including detailed programming specifications and unit-tested code
- Work with importing files from heterogeneous platforms and coordinate data file migration activities
- Define testing strategy and conduct testing to ensure data integrity and perform data comparisons
- Generate data migration exception reports and perform data cleansing as required
- Perform post-migration audit and data reconciliation to validate conversion accuracy
- Resolve and troubleshoot technical problems arising during software operation, implementation, conversion, and migration
- Provide pre- and post-effective conversion support to business clients
- Develop and maintain documentation including ETL mappings, data dictionaries, business cases, and data migration strategy and plans
- Establish strong working relationships with clients and interact effectively at all levels of the organization
- 7+ years of experience developing and documenting ETL processes for data conversion and migration projects
- Extensive experience with data migration and migration planning in the context of digital transformation, including migrating data from legacy applications to modernized solutions
- Extensive experience with relational database structures and RDBMS platforms including Oracle, MS SQL Server, and Azure SQL Database
- Ability to write complex SQL queries and conduct data analysis, data validation, and resolve complex technical problems
- Experience migrating document and file attachments from legacy solutions to new modernized platforms
- Experience working with cloud database technologies, specifically Azure SQL
- Experience working with ETL tools such as Azure Data Factory, Informatica, or equivalent enterprise ETL platforms
- Experience developing technical documentation including ETL mappings, data dictionaries, data migration strategies, and migration plans
- Knowledge and understanding of Information Management principles, concepts, policies, and practices
- Strong understanding of master data and transactional data concepts and their interdependencies
- Full life-cycle data conversion experience with enterprise systems, including deployment
- Experience with all phases of data migration including profiling, mapping, developing migration solutions, validation, and audit
- Proficiency in query languages including SQL and PL-SQL, including construction of complex query statements
- Knowledge of mainframe data formats, data types, segments, and non-relational data structures
- Experience ensuring data migration solutions are designed for scalability
- Strong data analysis, investigative, and logic skills with high attention to detail
- Experience with data conversion scripts and a variety of ETL tools such as Informatica and Azure Data Factory
- Experience liaising with cross-functional teams to define and understand to-be migration requirements
- Experience completing mapping, interfaces, conversion work, and verifying completeness and accuracy of converted data
- Experience supporting cutover processes and delivering required system changes in coordination with development or dedicated conversion teams
- Proven track record of meeting deadlines and managing competing priorities in client-facing environments
- Strong communication, facilitation, negotiation, consensus-building, and problem-solving skills
This is a fully onsite position located at 21 College Street, Toronto. The consultant is expected to work 7.25 hours per calendar day between 8:00 AM and 5:00 PM (excluding breaks), Monday to Friday. A Security Level of CRJMC is required for this role. Please note that the start date is subject to change based on security clearance and contract signing timelines.
Previous Job Job Listings Next Job
- Final role details, responsibilities, and terms will be confirmed with shortlisted candidates. Compensation may vary based on experience. Errors and omissions excepted.
More about this job
Responsibilities
Design and implement ETL solutions to migrate data and files from legacy systems to modernized platforms, including profiling, mapping, conversion, validation, and reconciliation. Troubleshoot migration issues, support clients before and after conversion, and maintain migration documentation and plans.
Requirements
Requires at least 7 years of experience developing and documenting ETL processes, with extensive experience in enterprise data migration, relational databases, complex SQL, and Azure SQL. Candidates must also have experience migrating document attachments, using enterprise ETL tools, and applying information management principles.
Skills
- ETL Development
- Data Migration
- Data Profiling
- SQL
- Oracle
- Microsoft SQL Server
- Azure SQL Database
- Azure Data Factory
- Informatica
- Data Mapping
- Data Validation
- Data Reconciliation
- Data Cleansing
- Data Analysis
- Technical Documentation
- Information Management
Visa sponsorship
Not detected in the job text
Categories
- Software
- Technology
- Data & Analytics
- Government & Public Sector
Keywords
- ETL
- Data Migration
- Digital Transformation
- Data Profiling
- Data Mapping
- Data Conversion
- SQL
- PL-SQL
- Oracle
- Microsoft SQL Server
- Azure SQL Database
- Azure Data Factory
- Informatica
- Relational Databases
- Master Data
- Transactional Data
- Data Validation
- Data Reconciliation
- Data Cleansing
- Data Dictionaries
- Information Management
- Legacy Systems
- Mainframe Data Formats
- File Migration
- Mock Conversions
- Cutover Support
- Data Integrity
- Public Sector
- Ontario Public Service
- CRJMC Security Clearance