Senior Software Developer - ETL

Contrat temporaire

Toronto, Ontario

30 Aug 2024

    We are looking for a skilled Data Migration Specialist to join our Ontario Government Client's team. This role focuses on the development and documentation of ETL processes, data migration, and conversion, particularly in digital transformation projects. The successful candidate must have:

    • 7+ years of experience in developing and documenting ETL for data conversion and migration.

    • Extensive experience in data migration planning and execution from legacy systems to modernized solutions.

    • Proficiency with RDMS such as Oracle, MS SQL Server, and Azure SQL, along with cloud DB technologies like Azure SQL.

    • Expertise in using ETL tools like Azure Data Factory and Informatica.

    Mandatory Requirements

    • 7+ years of experience in ETL development for data conversion and migration.

    • Extensive experience in data migration and planning, including migrating data from legacy to modernized solutions.

    • Proficiency in RDMS like Oracle, MS SQL Server, Azure SQL, and complex SQL query writing.

    • Experience migrating document attachments from legacy systems to new solutions.

    • Experience with cloud DB technologies and ETL tools such as Azure Data Factory and Informatica.

    • Strong documentation skills, including ETL mappings, data dictionaries, and migration strategies.

    • Knowledge of Information Management principles and master/transactional data concepts.

    Skills and Knowledge

    • Full life-cycle data conversion experience with enterprise systems.

    • Proficiency in SQL and PL-SQL, with experience in constructing complex queries.

    • Strong data analysis and problem-solving skills.

    • Experience with mainframe data formats and non-relational data structures.

    • Ability to oversee the entire data conversion process, including extraction, cleansing, transformation, and loading.

    • Experience providing support through the cutover process.

    Data Knowledge Expertise

    • Extensive experience in data conversion and migration, including full life-cycle experience.

    • Ability to troubleshoot and solve complex technical problems.

    • Technical Skills

      • Proficiency with ETL tools like Informatica and Azure Data Factory, and strong SQL skills.

      • Knowledge of various database structures and data migration tools.

    • Communication Skills

      • Strong communication, facilitation, and problem-solving skills.

      • Experience in presenting migration strategies to stakeholders.

    • Public Sector Experience

      • Experience working in Government or Public Sector organizations.