Client: Ministry of Public and Business Service Delivery and Procurement – RQ10575
We are seeking a
Senior Software Developer – ETL with extensive experience in data migration, ETL development, data conversion, database technologies, and digital transformation initiatives. The ideal candidate will have strong expertise in migrating data and document attachments from legacy applications to modernized solutions, developing complex SQL queries, performing data profiling and validation, and working with ETL tools such as Azure Data Factory and Informatica. The successful candidate will oversee end-to-end data migration activities, including extraction, cleansing, transformation, loading, testing, reconciliation, documentation, and post-migration support, while ensuring data integrity, accuracy, scalability, and compliance with information management principles.
Role Snapshot
- Job Title: RQ10575 – Software Developer – ETL – Senior
- Client: Ministry of Public and Business Service Delivery and Procurement
- Work Location: 21 College Street, Toronto, Ontario, Canada
- Work Arrangement: Onsite – 5 Days per Week
- Estimated Start Date: December 3, 2026
- Estimated End Date: October 5, 2027
- Business Days: 250.00
- Extension: 80.00
- Hours: 7.25 hours per day
- Working Schedule: Monday to Friday, between 8:00 AM and 5:00 PM, excluding breaks
- Security Level: CRJMC
Must Have
- 7+ years of experience developing and documenting ETL processes for data conversion and migration projects.
- Extensive experience with:
- Data migration and migration planning for digital transformation initiatives.
- Migrating data from legacy applications to modernized solutions using ETL methodologies.
- Relational databases such as Oracle, MS SQL Server, and Azure SQL Database.
- Complex SQL development, data analysis, data validation, and technical problem resolution.
- Experience with:
- Migrating document attachments from legacy systems to modernized solutions.
- Cloud database technologies, such as Azure SQL.
- ETL tools such as Azure Data Factory, Informatica, or similar technologies.
- Developing ETL and data migration documentation, including ETL mappings, data dictionaries, business cases, data migration strategies, and plans.
- Extensive experience in data migration and migration planning for digital transformation initiatives, including migrating data from legacy applications to modernized solutions using ETL methodologies.
- Extensive experience with various database structures and RDBMS technologies, including Oracle, MS SQL Server, and Azure SQL Database, as well as writing complex SQL queries, conducting data analysis and validation, and solving complex technical problems.
- Experience migrating document attachments from legacy solutions to new modernized solutions.
- Experience working with cloud database technologies, such as Azure SQL.
- Experience working with ETL tools such as Azure Data Factory, Informatica, and similar technologies.
- Experience developing documentation such as ETL mappings, data dictionaries, business cases, data migration strategies, and plans.
- Knowledge and understanding of Information Management principles, concepts, policies, and practices.
- Excellent understanding of master data and transactional data concepts and their interdependencies.
Description
Scope
A Senior Software Developer – ETL is required to provide best-practice migration solutions and oversee all aspects of data and file migration from a legacy application to a new solution.
Assignment Deliverables
- Provide best-practice migration solutions and oversee all aspects of data and file migration from a legacy application to a new solution.
- Establish a strong working relationship with clients, interact effectively at all levels, and analyse legacy data and files stored in a variety of data sources and formats.
- Analyse and complete data profiling and recommend any pre-migration data-cleansing activities.
- Complete the data migration strategy and data mapping, define interfaces, perform mock conversions, define enhancements, and perform actual conversions.
- Translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining programs, and conducting unit tests.
- Resolve and troubleshoot technical problems that arise during the use and operation of software packages, including providing technical assistance with implementation, conversion, and migrations.
- Work with file imports from heterogeneous platforms and coordinate data file migration.
- Define the testing strategy, plan and conduct testing, and ensure data integrity and data comparisons.
- Perform post-migration audits and data reconciliation.
- Generate data migration exception reports and perform data cleansing as required.
- Provide pre- and post-effective-conversion support to business clients.
Desired Skills And Experience
- Full life-cycle data conversion experience with enterprise systems, including deployment experience.
- Experience working with all stages of data migration activities, including data profiling, data mapping, developing data migration solutions, data validation, and auditing.
- Proficiency in query languages such as SQL and PL-SQL.
- Familiarity with and ability to construct complex query statements.
- Knowledge of various database structures and RDBMS technologies, such as Oracle DB, MS SQL Server, and Azure SQL Database, and the ability to write complex SQL queries.
- Knowledge and understanding of mainframe data formats, data types, segments, and non-relational data structures.
- Experience ensuring that data migration solutions are scalable.
- Strong data analysis, investigative, and logical reasoning skills, with high attention to detail.
- Experience migrating file attachments from legacy applications to new solutions.
- Experience with data conversion scripts and ETL tools such as Informatica and Azure Data Factory.
- Experience overseeing and completing all tasks involved in the conversion process, including data extraction, cleansing, transformation, and loading.
- Experience liaising with teams to understand to-be migration requirements.
- Ability to establish strong working relationships with all groups, interact effectively with all levels of client personnel, and provide conversion support.
- Experience completing mapping, interfaces, conversion work, and documentation, and verifying the completeness and accuracy of converted data.
- Experience delivering required system changes and/or working with the development team or a dedicated conversion team to specify load programs.
- Experience providing support throughout the cutover process.
- A team player with a track record of meeting deadlines, managing competing priorities, and maintaining client relationships.
- Strong communication, facilitation, negotiation, consensus-building, and problem-solving skills.
Experience And Skill Set Requirements
Criteria 1: Data Knowledge Expertise Skills - 35 Points
The candidate must demonstrate strong knowledge and expertise in data management, data conversion, migration planning, and related data concepts, including:
- Extensive experience in data migration and migration planning for digital transformation initiatives.
- Experience developing and documenting ETL processes for data conversion and migration projects.
- Understanding of information management principles, concepts, policies, and practices.
- Excellent understanding of master data and transactional data concepts and their interdependencies.
- Experience with data profiling, data mapping, data validation, data cleansing, data reconciliation, and post-migration auditing.
- Knowledge of data migration strategies, plans, documentation, and best practices for legacy-to-modernized-system migration.
- Experience migrating data and document attachments from legacy applications to modernized solutions.
- Strong analytical and investigative skills to assess data quality, identify migration issues, and recommend appropriate solutions.
Criteria 2: Technical Skills - 35 Points
- Experience with industry-leading ETL tools such as Informatica, Azure Data Factory, and cloud technologies.
- Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, and related technologies.
- Exceptional knowledge of relationships between tables and the ability to construct complex query statements using multiple data sources.
- Knowledge of various database structures and RDBMS technologies, including Oracle, MS SQL Server, and Azure SQL Database, and the ability to write complex SQL queries.
- Knowledge and understanding of mainframe data formats, data types, segments, and non-relational data structures.
- Strong data analysis, investigative, and logical reasoning skills, with high attention to detail and the ability to troubleshoot and resolve complex technical problems.
- Experience with data conversion scripts and tools.
- Experience with file migration from different file storage platforms, such as Azure BLOB, Azure File Share, SharePoint, and Oracle BLOBs.
- Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation, and verification of the completeness and accuracy of converted data, including data dictionary development and updates.
- Experience delivering required system changes and/or working with the development team or a dedicated conversion team to specify load programs.
Criteria 3: Communication Skills - 25 Points
- Strong communication, facilitation, negotiation, consensus-building, and problem-solving skills.
- Ability to provide periodic status reports and present data migration strategies and approaches to executives and other stakeholders.
- Ability to establish and maintain effective working relationships with clients, technical teams, business groups, and stakeholders at all levels.
- Ability to communicate technical migration requirements, issues, solutions, and progress clearly and effectively.
Criteria 4: Public Sector Experience - 5 Points
- Previous experience working in government or public sector organizations.
How to Apply
If you are interested and your profile matches the requirements, kindly send the following mandatory documents to
hrsmss@smsoftconsulting.com by
Tuesday, October 27, 2026, at 1:30 PM EST.
Mandatory Documents
- Updated Resume in Word format (Mandatory)
- References (Mandatory)
- Expected Hourly Rate (Mandatory)
- Visa Status (Mandatory)
- LinkedIn ID (Mandatory)
Without the mandatory documents, we cannot submit a candidate.
WhatsApp Group
For daily job updates, you can also join our WhatsApp group using the link below:
Join our WhatsApp Group
Additional Information
This position is currently listed as
Onsite. The resource is expected to work 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM, excluding breaks, Monday to Friday inclusive, unless otherwise identified.
Contract Duration and Extension
The VOR Master Service Agreement expires on April 5, 2027, and includes a six (6)-month survival clause, allowing the Statement of Work (SOW) to continue, if operationally required, until October 5, 2027.
Extension(s) are permitted only using unused days and/or funds remaining on the contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW.
JTS may exercise its option(s) to extend the SOW beyond April 5, 2027, in accordance with the survival clause.
Start Date
The start date is subject to change based on security clearance requirements and contract signing timelines.
Email is the best way to reach us.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
