Overview

NOTE: HYBRID work model, 2-days/week in office. Office located in Mississauga, Ontario.

Type: 6 Month Contract, 8 hours/day, 40 hours/week
Work Experience: 7-10+ years ETL Developer, SQL, T-SQL, Data Mapping, SQL Complex Stored Procedures, Data migration to Salesforce, SOQL, PL/SQL scripting
Industry: Healthcare

DESCRIPTION:

  • Design, develop, and maintain ETL processes focused on SQL Server for data migration to Salesforce
  • Perform development lifecycle tasks, including:
    • Analyze and understand data sources and targets to create effective data migration strategies.
    • Develop data migration solutions from scratch or adapt existing components.
    • Implement data pipelines, schedule and orchestrate jobs, and automate migration tasks.
    • Design, code, and debug according to pre-determined standards; participate in code reviews as required.
    • Perform unit testing, integration, and performance testing to ensure data accuracy and integrity.
    • Promote ETL processes to different environments
    • Document ETL processes, data mappings, and migration solutions.
  • Be proactive and provide the status of effort accomplished, estimates of remaining effort, and issues impacting progress
  • Collaborate with internal (architect, analyst, DBA and others) and/or external stakeholders where needed to solve problems
    Participate in the evaluation and identification of new technologies

    REQUIREMENTS:

  • Bachelor’s degree in Computer Science/Computer Engineering
  • 7-10+ years of hands-on experience as an ETL Developer in a data warehouse environment, including ETL design, development, testing, and deployment
  • Solid understanding of database migration and experience and knowledge of Databases and ETL
  • SQL Server, T-SQL, writing Complex Stored Procedures, Performance Tuning, Debugging, Optimizing Stored Procedures
  • SSIS – an asset
  • Data Mapping
  • Converting business logic into SQL code
  • SQL Server database, Data analysis, Data migration, Salesforce SOQL, PL/SQL scripting
  • Ability to work independently or in a group under a limited degree of supervision
  • Ability to work efficiently under pressure and manage multiple assignments

As part of our hiring process, we use AI‑based systems to support initial applicant screening.

Tagged as: Data Mapping, data migration, ETL, etl developer, PL/SQL, SOQL, SQL Stored Procedures, Stored Procedures, T-SQL

Before applying for this position you need to submit your online resume. Click the button below to continue.