Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowFirst seen 2 days ago

RQ09018 - Software Developer - ETL - Senior

Rubicon Path638 open roles

Where
Toronto, ON, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ09018 - Software Developer - ETL - SeniorRubicon Path · Toronto, ON, Canada

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Rubicon Path's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.8% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.1%1 day
  2. 4.4%3 days
  3. 11.8%7 days
  4. 18.6%14 days
  5. 35.6%30 days
  6. 45.1%60 days
This job: first seen 2 days ago

The posting

Description

A Note on Assignment Type:

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

Scope

  • A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution

Assignment Deliverables

  • Provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.
  • Establish a strong working relationship with clients, interact effectively at all levels and analyses legacy data and files stored in a variety of data sources and formats.
  • Analyze and complete data profiling and suggest any pre migration data cleansing activities.
  • Complete data migration strategy, data mapping, define interfaces, perform mock conversion, define enhancements and perform actual conversion.
  • Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
  • Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations
  • Work with importing files from heterogeneous platforms and coordinates data file migration.
  • Define testing strategy, plan and conducts testing to ensure data integrity and data comparisons.
  • Perform post migration audit and data reconciliation.
  • Generate data migration exception reporting and perform data cleansing as required.
  • Provides pre- and post-effective conversion support to business clients

SkillsExperience and Skill Set Requirements

A Note on the VOR Master Service Agreement:

The VOR Master Service Agreement which expires on April 5, 2026, leaves some Contracts with funding unassigned for fiscal 2026-27. If the current statement of work expires on March 31, 2026, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2026, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2026, and be upon the same terms, conditions, and covenants contained in the SOW.

The start date is subject to change based on security clearances and contract signing timelines.

Experience and Skillset Requirements

Mandatory Requirements

  • 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.
  • Knowledge and experience in development of business case, data migration strategy and plan.
  • Knowledge and understanding of Information Management principles, concepts, policies and practices.
  • Excellent understanding of master data and transactional data concepts and interdependencies.

Desired Skills and Experience

  • Full life-cycle data conversion experience with enterprise systems, including deployment experience.
  • Experience working with all steps of data migration activities such as data profiling, data mapping, developing data migration solutions, data validation and audit.
  • Proficiency in query languages such as SQL, PL-SQL.
  • Familiarity with and construction of complex query statements.
  • Knowledge of various database structures and RDMS like Oracle DB and MS SQL Server, Azure SQL Database, and write complex SQL queries
  • Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
  • Experience ensuring the data migration solution is scalable.
  • Data analysis, investigative and logic skills with high attention to detail
  • Experience with migrating file attachments from legacy applications to new solution.
  • Experience with data conversion scripts and various ETL tools such as Informatica, Azure Data Factory, etc.
  • Experience with overseeing /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.
  • Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
  • Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
  • Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
  • Experience providing support through the cutover process
  • A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience
  • Communication, facilitation, negotiation, consensus building, and problem-solving skills

Resumes Evaluation/Criteria:

Criteria 1: Data Knowledge Expertise Skills - 35 Points

  • 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

Knowledge Transfer

What needs to be KT

  • All documentation relating to the technology designs and technology knowledge specific to the candidates assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented

To whom

  • Manager / Project Manager / Team members

When

  • 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc.

Must have:

  • 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.
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Rubicon Path's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Rubicon Path's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Rubicon Path's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.