Senior Software Developer ETL

4 weeks ago

Toronto, Ontario, Canada Foilcon Full time
Data Migration Specialist

The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer – ETL to perform data migration activities from the existing OPGT legacy applications to the new Dynamics 365 OPGT solution and data warehouse/lakehouse. The successful candidate will be responsible for migrating data from the existing legacy applications to the new Dynamics 365 OPGT solution and the new data warehouse/lakehouse.

Key Responsibilities:
  • Analyze the existing data in the legacy applications, understand its structure, quality, and relationships and help in designing an appropriate migration strategy;
  • Map the data elements from the legacy application to the corresponding entities and fields in Dynamics 365 CE, F&O and Data Lakehouse. Handle necessary data transformations, ensuring compatibility and consistency between the legacy data and the target system;
  • Help extract the required data from the legacy application, develop and implement extraction processes to retrieve data from various sources, such as databases, files, APIs, or other relevant legacy systems;
  • Cleanse and validate the extracted data to ensure its accuracy, completeness, and consistency. Help with identifying and resolving data quality issues, performing deduplication, and applying business rules to ensure the integrity of the migrated data;
  • Review the present migration strategy that outlines the overall approach, sequence, and timeline for migrating the data from the legacy application to Dynamics 365 using a delta-load approach; execute the migration plan efficiently, managing data transfers and ensuring minimal disruption to ongoing operations;
  • Conduct thorough testing to verify the accuracy and integrity of the migrated data; define test cases, perform data reconciliation, and address any issues or discrepancies that arise during the testing phase; develop KPIs to report on the progress, completeness and quality of the data migration effort;
  • Document the entire data migration process, including data mapping rules, transformation logic, migration scripts, and any specific configurations;
  • Provide post-migration support, analyze and address data-related issues or questions; help optimize data management processes in the new environment;
  • Help expand the current data lakehouse implementation and help build a gold layer for reporting; conduct data analysis and profiling; develop data transformation and cleansing pipelines; implement data integration and harmonization;
  • Other duties as assigned;

Requirements:
  • 5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns;
  • Proficiency in Azure Data Factory, Azure Synapse workspaces, PolyBase, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring;
  • Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies;
  • Proficiency in scripting languages like Python, experience with Azure-specific scripting using PowerShell or Azure CLI;
  • Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning;
  • Knowledge of integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs;
  • Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces;
  • Familiarity with data warehousing concepts and experience working with Azure Synapse Analytics or similar platforms for building and managing large-scale data warehousing/lakehouse solutions;
  • Experience with SSIS, SSRS, PowerBI;

Preferred Qualifications:
  • Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate);
  • Experience with PowerApps platform, Power Automate, Dynamics CE and F&O;

  • Senior Software Developer ETL

    4 weeks ago

    Toronto, Ontario, Canada Foilcon Full time

    Job Title: Senior Software Developer ETLFoilscon is seeking a highly skilled Senior Software Developer ETL to join our team. As a key member of our data migration team, you will be responsible for designing and implementing data migration strategies, developing and maintaining ETL processes, and ensuring data quality and integrity.Key Responsibilities:Design...

  • Senior Software Developer ETL

    4 weeks ago

    Toronto, Ontario, Canada Foilcon Full time

    Job Title: Senior Software Developer ETLFoilocn is seeking a highly skilled Senior Software Developer ETL to join our team. As a key member of our data migration team, you will be responsible for migrating data from our legacy applications to our new Dynamics 365 solution and data warehouse/lakehouse.Key Responsibilities:Migrate data from legacy applications...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Bevertec Full time

    Job Title: Senior ETL DeveloperJob Summary: We are seeking a highly skilled Senior ETL Developer to join our team at Bevertec. As a Senior ETL Developer, you will be responsible for designing, implementing, and maintaining large-scale data transformation pipelines using Azure Data Factory.Key Responsibilities:Design and implement ETL pipelines using Azure...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Job Title: Senior ETL DeveloperJob Description:Arthur Grand Technologies Inc is seeking a highly skilled Senior ETL Developer to join our team. As a Senior ETL Developer, you will be responsible for designing, implementing, and maintaining ETL processes to extract, transform, and load data from various sources into our data warehouse.Key Responsibilities:*...

  • Senior Software Developer

    4 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Job DescriptionJob SummaryMaarut Inc is seeking a highly skilled Senior Software Developer - ETL to join our team. As a key member of our data migration team, you will be responsible for designing, developing, and implementing ETL processes to migrate data from legacy applications to our new Dynamics 365 solution and data warehouse/lakehouse.Key...

  • Senior Software Developer

    4 weeks ago

    Toronto, Ontario, Canada GTT, LLC Full time

    About the RoleOur client is seeking a skilled Senior Software Developer - ETL to play a crucial role in our data migration initiative. You will be responsible for migrating data from legacy OPGT applications to the new Dynamics 365 OPGT solution and data warehouse/lakehouse.Key ResponsibilitiesData Analysis: Analyze legacy data, understand its structure, and...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Job Title: Senior ETL DeveloperMaarut Inc is seeking a highly skilled Senior ETL Developer to join our team. As a key member of our data migration team, you will be responsible for designing, developing, and implementing ETL processes to migrate data from our legacy applications to our new Dynamics 365 solution and data warehouse/lakehouse.Key...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Clarity Hiring Full time

    Job Title: Senior ETL DeveloperJob Summary: We are seeking a highly skilled Senior ETL Developer to join our team. The ideal candidate will have a strong understanding of ETL principles, including data extraction, transformation, and loading processes.Key Responsibilities:Design and implement ETL processes using Azure Data Factory and Azure Synapse...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Job Title: Senior ETL DeveloperJob Description:We are seeking a highly skilled Senior ETL Developer to join our team at Arthur Grand Technologies Inc. The ideal candidate will have a strong understanding of ETL principles, including data extraction, transformation, and loading processes.Key Responsibilities:Design and implement ETL processes using Azure Data...

  • Senior ETL Developer

    1 month ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Job Title: Senior ETL DeveloperWe are seeking a highly skilled Senior ETL Developer to join our team at Maarut Inc. As a key member of our integrations team, you will be responsible for designing, developing, and testing ETL processes to integrate various data sources and systems.Key Responsibilities:Design and develop ETL processes using Azure ETL services...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Job DescriptionAbout the Role:We are seeking a highly skilled Senior ETL Developer to join our team at Maarut Inc. As a Senior ETL Developer, you will be responsible for designing, developing, and implementing data migration solutions using Azure Data Factory and Synapse Workspaces.Key Responsibilities:Design and develop data pipelines using Azure Data...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Job DescriptionJob SummaryMaarut Inc is seeking a highly skilled Senior ETL Developer to join our team. As a Senior ETL Developer, you will be responsible for designing, developing, and implementing ETL processes to extract, transform, and load data from various sources into our data warehouse.Key ResponsibilitiesDesign and develop ETL processes using Azure...

  • Senior ETL Developer Position

    1 month ago

    Toronto, Ontario, Canada Futran Tech Solutions Pvt. Ltd. Full time

    Senior ETL Developer OpportunityWe are seeking a highly skilled Senior ETL Developer to join our dynamic team at Futran Tech Solutions Pvt. Ltd. in Toronto, Canada.About the RoleThe ideal candidate will have 6+ years of experience in capital markets and a strong background in ETL development. The successful candidate will be responsible for designing,...

  • Senior ETL Developer

    2 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    About the RoleWe are seeking an experienced Senior ETL Developer to join our team at Scotiabank.The ideal candidate will have a strong background in developing strategies for Extraction, Transformation, and Loading (ETL) mechanisms, with experience in designing Server jobs using various types of stages. They should also be skilled in integrating multiple...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Are you a data integration expert looking for a new challenge?In this role, you will be responsible for designing and developing ETL solutions on multiple complex initiatives.You will work closely with product owners and test engineers to support QA processes, review test plans, and help improve test automation.Additionally, you will investigate failures,...

  • Senior ETL Developer Position

    3 weeks ago

    Toronto, Ontario, Canada Futran Tech Solutions Pvt. Ltd. Full time

    Role: Senior ETL Developer Location: Toronto, Canada (Candidate will be visiting the office 4 days per week)Job Overview: We are seeking an ETL Developer with BA experience to join our stimulating and dynamic team.About the Position: The ideal candidate will have 6+ years of capital markets experience and strong skills in data integration and ETL...

  • Senior Python ETL Developer

    1 month ago

    Toronto, Ontario, Canada Sun Life Full time

    Job Title: Senior Python ETL DeveloperAre you a skilled Python developer looking to take your career to the next level? Do you have experience with data transformation and ETL processes? We are seeking a highly motivated and experienced Senior Python ETL Developer to join our team at Sun Life.Job Summary:We are looking for a talented developer to design,...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    This is a contract position for a Senior ETL Developer - ETL, Senior Level for our client who is in the Broader Public Sector. Work location will be in the North York area.This is a Hybrid Role with 3 days in the office a week. This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.The Contract runs for one...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job SummaryThis is a contract position for a Senior ETL Developer - ETL, Senior Level for our client in the Broader Public Sector. The work location will be in North York.This is a hybrid role with 3 days in the office a week, which is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.The contract runs for one...

  • Senior ETL Developer

    4 weeks ago

    Toronto, Ontario, Ontario, Canada Bevertec Full time

    Title: Senior ETL Developer(s)Duration: End of March 2025 (possible extension)The role is "Hybrid", working 7.25 hours per calendar dayMust haves:10 years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding...