Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

RQ10575 - Software Developer - ETL - Senior I Toronto ON - Onsite I 1+ year

Analyst Technical Solutions


Job Title: RQ10575 - Software Developer (ETL) Senior

Organization: Justice Technology Services

Location: Toronto ON , Onsite 5 days a week

Pay Rate:95-101/hr incorp

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

Skills

Experience and Skill Set Requirements

A Note on the VOR Master Service Agreement:

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 only allowed 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.

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 and documenting ETL for data conversion and migration

Extensive experience in data migration and migration planning in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.

Extensive experience with various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, conduct data analysis, data validation, and solve complex technical problems

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 with ETL tools such as Azure Data Factory, Informatica, etc.

Experience in development of documentation such as ETL mappings, data dictionaries, 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.

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

Previous experience working in Government or Public Sector organizations

Must haves:

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 (e.g., 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

Vacancy posted 26 days ago
Similar jobs that could be interesting for youBased on the RQ10575 - Software Developer - ETL - Senior I Toronto ON - Onsite I 1+ year in Toronto, ON vacancy
  •  ...RQ11598 - Software Developer - Senior I Toronto ON - Onsite I 1+ year Job Title: 11598 - Software Developer - Senior Organization: Community Services Cluster Location: Toronto ON , Onsite 5 days a week Pay Rate:80-85/hr incorp Title: RQ11598 - Software... 
    Senior
    Flexible hours

    Analyst Technical Solutions

    Toronto, ON
    26 days ago
  •  ...RQ11713 - Software Developer - ETL - Senior Organization: Central Agencies Cluster Ministry: Ministry of Treasury Board Secretariat Location: Toronto, ON Onsite Pay rate: 95-101/hr incorp Title Software Developer - ETL Description Role... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...Job Title: RQ11720 - Software Developer - Senior Organization: Government Services Integration Cluster Location: Toronto ON , Onsite 5 days a week Pay Rate:95-101/hr incorp Title: BOR - One Senior Software Developer Description Develops, configures... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    26 days ago
  •  ...RQ11754 - Software Developer - Senior Government Services Integration Cluster Responsibilities • Required to translate technical systems specifications into working, tested applications. This includes: developing detailed programming specifications... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    29 days ago
  •  ...Job Title: 11658 - Software Developer - Senior Organization: Government Services Integration Cluster Location: Toronto ON , Onsite 5 days a week Pay Rate:95-101/hr incorp Title: Full Stack Software Developer  Responsibilities: Technical Leadership... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    26 days ago
  •  ...RQ11745 - Software Developer - Senior Organization: Justice Technology Services Ministry: Ministry of Public and Business Service Delivery and Procurement location: Toronto ON -Onsite Pay Rate:95-101/hr incorp Description Qualifications:... 
    Senior
    Temporary work
    Local area

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ10953 - Software Developer - CRM - Senior Justice Technology Services Ministry of Public and Business Service Delivery and Procurement Pay...  ...Software Developer – CRM / Microsoft Dynamics 365 Location: Toronto, Ontario Work Arrangement: Onsite Position Overview... 
    Senior
    Work at office

    Analyst Technical Solutions

    Toronto, ON
    7 days ago
  •  ...We are seeking an experienced Senior Software Developer - ETL to lead and oversee the end-to-end data and document migration strategy for enterprise modernization initiatives. In this role, you will be responsible for analyzing, profiling, cleansing, and transforming legacy... 
    Senior
    Contract work

    Randstad Canada

    Toronto, ON
    7 days ago
  •  ...Job Title: RQ11736 - Software Developer- Front End - Senior Organization: Government Services Integration Cluster Location: Toronto ON , Onsite 5 days a week Pay Rate:90-100 /hr incorp Title:  Senior Software Developer - Front End Description Description... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    26 days ago
  •  ...Software Developer - CRM - team lead Organization: Government Services Integration Cluster Ministry: Ministry of Public and Business Service Delivery and Procurement Location: Toronto - ON - Onsite  Pay rate: 95-101/hr incorp  Description Responsibilities... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11499 - Software Developer - CRM - Senior Organization: Government Services Integration Cluster Ministry: Ministry of Public and Business Service...  ...experience and understanding of data warehouse, ETL methodologies and OBIEE • Demonstrated work experience... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11661 - Software Developer - CRM – Senior Client: Government Services Integration Cluster Location: Toronto ON Duration: 1 + year Pay rate: 95-103/hr incoro Title Software Developer - MS Dynamics 365 CRM Description The Ontario Ministry... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11686 - Software Developer - Senior I Toronto ON I 1+ year  Overview • Client: Cyber Security Division / Ministry of Public and Business Service Delivery and Procurement • Requisition ID: RQ11686  • Duration: 1+ year • Location: Toronto, ON Onsite... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11685 - Software Developer - Back End - Senior Organization: Labour and Transportation Cluster location: Toronto ON -Onsite Title Software Developer - Back End Pay Rate: 95-100/hr incorp Description Responsibilities / Deliverable / Skill Set... 
    Senior
    Internship

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11508 - Software Developer - Senior Client: Government Services Integration Cluster Pay Rate: 95-101/hr incorp Location: Toronto ON - Onsite Description Must Have: 10+ years of experience as a designer and developer in the large-scale multi-client... 
    Senior
    Manual labor

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11755 - Software Developer - Full Stack - Senior Organization: Community Services Cluster Ministry: Ministry of Public and Business Service Delivery and Procurement location: Toronto ON -Onsite Pay Rate:95-103/hr incorp Title: Software Developer... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11718 - Software Developer - Intermediate Organization: Central Agencies Cluster Ministry...  ...Developer Description Onsite Work Requirement: The successful candidate...  ...tests. Mandatory Skills: 7+ years’ experience in developing n-tier Enterprise... 
    Work at office
    Monday to friday

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...Job Title: RQ11715 - Business Analyst - Senior Organization: Government Services Integration Cluster Location: Toronto ON , Onsite 5 days a week Pay Rate:90-95 /hr incorp...  ...Systems Development Methodologies •Develops strategies, prepares business cases and cost... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    26 days ago
  •  ...data for reporting consumption. Design develop and release deploy Power BI reports and dashboards...  ...arise during the use and operation of software packages including technical assistance in...  ...Set Requirements: Must Haves: ~6 years experience as Azure technologies including... 
    Senior
    Full time

    Maarut

    Toronto, ON
    6 days ago
  •  ...RQ11691 - Software Developer – Senior Client: Justice Technology Services Location: Toronto ON Onsite CJDD DIR - 2 Soft. Dev. (Snr) - 244 + 362 Days Description The Digital Information and Repository (DIR) is a first of its kind in Canada solution... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11507 - Software Developer- Front End - Senior Title: Software Developer- Front End pay rate: 95-100/hr incorp Location: Toronto ON 1+ year Duration: 1 Year + Description Responsibilities: Designing, developing and implementing front end code including... 
    Senior
    Internship

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...We are seeking a skilled and detail-oriented Intermediate Software Developer - ETL for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a key business intelligence, data modeling, and reporting enablement capacity, specializing in designing... 
    Contract work

    Randstad Canada

    Toronto, ON
    7 days ago
  •  ...RQ11502 - Product Manager - Senior Organization: Government Services Integration...  ...Delivery and Procurement location: Toronto ON , Onsite Pay rate: 95-103/hr incorp Title...  ...internally and with key external partners •Develop product pricing and positioning... 
    Senior
    Internship
    Work at office

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...The Senior Software Developer - ETL will design, build, and maintain scalable data pipelines, integrations, and reusable data services that enable enterprise AI, analytics, and data initiatives. The role will help improve access to trusted data across enterprise systems... 
    Senior

    P@thlion Staffing Careers

    Toronto, ON
    13 days ago
  •  ...RQ11668 - Business Analyst - Senior Organization: Government Services Integration...  ...Delivery and Procurement location: Toronto ON -Onsite Pay Rate:90-95/hr incorp Title...  ...facing portal). Azure DevOPS is used to develop user stories. This position is to... 
    Senior
    Internship
    Work at office
    Monday to friday

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11714 - Business Analyst - Senior Organization: Central Agencies Cluster Ministry...  ...Board Secretariat Location: Toronto ON - Onsite Pay rate: 90-95/hr incorp Title...  ...etc. to meet business objectives. Develop options and implications for potential procurement... 
    Senior
    Contract work

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11775 - Software Developer - Senior I Toronto ON I 2+ year Client: Justice Technology Services Location: Toronto ON onsite Pay Rate- 95-101/hr incorp OPP Level 4 Clearances: This position requires an OPP Level 4 security clearance Scope... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    27 days ago
  •  ...RQ11648 - Business Analyst - Senior Organization : Government Services...  ...Development Methodologies Develops strategies, prepares business...  ...Experience in the use of Computer Aided Software Engineering (CASE) tools to...  ...and Skill Set Requirements 1. Data & Business Analysis &... 
    Senior
    Internship

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11518 - Business Analyst - Senior Organization: Government Services Integration...  ...Delivery and Procurement Location: Toronto - Onsite Pay rate: 90-95/hr incorp Title...  ...Standard Systems Development Methodologies Develops strategies, prepares business cases and... 
    Senior
    Long term contract
    Manual labor

    Analyst Technical Solutions

    Toronto, ON
    a month ago
  •  ...RQ11452 - Data Scientist - Senior Organization: Community Services Cluster Ministry...  ...rate: 100- 114/hr incorp Location: Toronto ON - Onsite Description “CSC may exercise...  ...contained in the SOW.” Responsibilities 1. Analyze complex data sets to generate... 
    Senior

    Analyst Technical Solutions

    Toronto, ON
    more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to RQ10575 - Software Developer - ETL - Senior I Toronto ON - Onsite I 1+ year. Be the first to apply!