Software Developer - ETL - Senior

If interested, please share your latest resume at /

RQ09018 - Software Developer - ETL - Senior

Client : Ministry of Solicitor General

Location : 21 College Street, Toronto

Period : 10 months

Start Date : 02-06-2025

End Date : 31-03-2026

Working Hrs : 7.25 Hrs. / day

Assignment Type : Hybrid - Candidate MUST work 3 days onsite and 2 days remote

Must haves :

• 7+ years of experience in developing data conversion and migration.
• Extensive experience in data migration in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.
• Experience in migrating document attachments from legacy solution to a new modernized solution.
• Experience working in cloud DB technologies (such as Azure SQL).
• Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
• Excellent understanding of master data and transactional data concepts and interdependencies.

Resumes Evaluation / Criteria :

• 7+ years of experience in developing data conversion and migration
• At least one experience of working with migrating data from different legacy platforms to a new solution.
• Full life-cycle data conversion experience with enterprise systems, including deployment experience.
• Data analysis, investigative and logic skills, including the ability to troubleshoot and solve complex technical problems.
• Experience with overseeing / completing all tasks involved in the conversion process including data extraction, profiling, cleansing, import data, manipulate data, transformation and loading.
• Experience liaising with teams to understand to-be migration requirements.
• Knowledge and understanding of Information Management principles, concepts, policies and practices.
• Experience providing support through the cutover process.
• Knowledge of data model of case management solutions and experience in data migration / conversion of large case management applications.
• Experience with migrating attachment files from legacy applications to new solution.
• Experience with document migration

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, etc.
• Exceptional level of knowledge on relationships between tables to perform and construct complex query statements from multiple data sources.
• Knowledge of various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, etc.
• Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
• Data analysis, investigative and logic skills with high attention to details, including ability to troubleshoot and solve complex technical problems.
• Experience with data conversion scripts and tools.
• Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, Oracle BLOBs.
• Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation and verifying completeness and accuracy of converted data, including data dictionary development and updates.
• Experience delivering the required system changes and / or working with the development team or a dedicated conversion team to specify loads programs.

Criteria 3 : Communication Skills - 25 Points

• Communication, facilitation, negotiation, consensus building, and problem-solving skills
• Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders

Criteria 4 : Public Sector Experience - 5 Points

• Demonstrated experience working within an organization of equivalent size and complexity to the Ontario Public Service
• Experience in working with Architectural artifacts within the OPS would be an asset