Back to results

Senior Software Developer – ETL / Data Migration

  • Toronto, ON, Canada

$90 to $96 CAD / hour · Contract

Applications open in a new tab.

Job details

Pay
$90 to $96 CAD / hour
Job type
Contract
Apply by
Experience
7+ years of experience developing and documenting ETL processes for data conversion and migration.
Posting language
English
Posted

Original job description

Contract: December 3, 2026 – October 5, 2027

We are seeking a Senior Software Developer specializing in ETL and data migration to support a digital transformation initiative for a public-sector client. The successful candidate will lead data conversion activities, migrating data and document attachments from legacy applications to modernized systems while ensuring data integrity, accuracy, and consistency.

Key Responsibilities

  • Develop, document, and implement ETL processes for complex data conversion and migration projects.
  • Plan and execute end-to-end data migration from legacy systems to modernized applications.
  • Analyze legacy data, perform data profiling, and identify data cleansing requirements.
  • Develop data mapping, migration strategies, conversion scripts, and technical documentation.
  • Extract, transform, load, validate, and reconcile data across multiple sources.
  • Migrate document attachments and files from legacy systems to new platforms.
  • Develop complex SQL queries and troubleshoot data-related technical issues.
  • Conduct mock conversions, testing, post-migration audits, and exception reporting.
  • Support migration cutover activities and provide pre- and post-conversion assistance.
  • Collaborate with technical teams, business stakeholders, and project managers to ensure successful migration delivery.

Required Qualifications

  • 7+ years of experience developing and documenting ETL processes for data conversion and migration.
  • Extensive experience migrating data from legacy applications to modernized solutions.
  • Strong experience with relational databases, including Oracle, Microsoft SQL Server, and Azure SQL Database.
  • Proficiency in complex SQL queries, data analysis, data validation, and troubleshooting.
  • Experience with ETL tools such as Azure Data Factory, Informatica, or equivalent technologies.
  • Experience migrating document attachments and files between legacy and modernized systems.
  • Experience developing ETL mappings, data dictionaries, migration strategies, and technical documentation.
  • Understanding of master data, transactional data, and information management principles.
  • Strong communication, analytical, problem-solving, and stakeholder management skills.

Preferred Qualifications

  • Full lifecycle data conversion experience with enterprise systems, including deployment and cutover.
  • Experience with data profiling, cleansing, transformation, reconciliation, and migration audits.
  • Knowledge of PL/SQL, mainframe data formats, and non-relational data structures.
  • Experience migrating files from Azure Blob Storage, Azure File Share, SharePoint, or Oracle BLOBs.
  • Experience with large-scale case management system migrations.
  • Previous experience working with government or public-sector organizations.

If you have strong ETL development and data migration experience and are interested in this opportunity, please apply with your updated resume.

AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.

More about this job

Responsibilities

Develop and execute end-to-end ETL and data migration processes, including data profiling, mapping, cleansing, validation, reconciliation, and migration of document attachments from legacy systems to modernized platforms. Lead testing, mock conversions, audits, cutover support, and technical collaboration with stakeholders to ensure accurate and successful migration delivery.

Requirements

Requires at least 7 years of experience developing and documenting ETL processes and migrating data from legacy applications, along with strong SQL and relational database skills. Candidates should have experience with ETL tools, data and document migration, technical documentation, and data management; full lifecycle enterprise conversions and public-sector experience are preferred.

Skills

  • ETL Development
  • Data Migration
  • Data Conversion
  • SQL
  • Oracle
  • Microsoft SQL Server
  • Azure SQL Database
  • Azure Data Factory
  • Informatica
  • Data Profiling
  • Data Cleansing
  • Data Validation
  • Data Reconciliation
  • Data Mapping
  • Technical Documentation
  • Stakeholder Management

Visa sponsorship

Not detected in the job text

Categories

  • Software
  • Technology
  • Data & Analytics
  • Government & Public Sector

Keywords

  • ETL
  • Data Migration
  • Data Conversion
  • Legacy Applications
  • Oracle
  • Microsoft SQL Server
  • Azure SQL Database
  • Azure Data Factory
  • Informatica
  • SQL
  • PL/SQL
  • Data Profiling
  • Data Cleansing
  • Data Mapping
  • Data Validation
  • Data Reconciliation
  • Master Data
  • Transactional Data
  • Information Management
  • Document Attachments
  • Azure Blob Storage
  • Azure File Share
  • SharePoint
  • Oracle BLOBs
  • Mainframe Data Formats
  • Case Management Systems
  • Mock Conversions
  • Migration Audits
  • Cutover
  • Public Sector

Report this job