Job Description

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: 5-7+ years ETL Developer, MS Access, SQL, T-SQL, SSIS, Data Mapping, SQL Stored Procedures, SQL Server database, Data analysis, Data migration, Salesforce Health Cloud, SOQL, PL/SQL scripting
Industry: Healthcare
DESCRIPTION:

• Design, develop, and maintain ETL processes focused on SQL Server for data migration
• 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 using SSIS

• Document ETL processes, data mappings, and migration solutions.
• Be proactive and provide 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

• 5-7+ years of hands-on experience as a 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, Stored Procedures, Performance Tuning, Debugging, Optimizing Stored Procedures
• SSIS
• Data Mapping
• MS Access
• Converting business logic into SQL code

• SQL Server database, Data analysis, Data migration, Salesforce Health Cloud, 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

Tagged as: CI/CD, Data Mapping, Databricks, Developer, DevOps, ETL, ETL Strategy, Excel, GitHub, integration, Jira, MS Access, PL/SQL scripting, PowerShell, Salesforce, snowflake, SSIS

Skills Required