ETL Developer - Toronto, Canada - AMISEQ

    AMISEQ
    AMISEQ Toronto, Canada

    2 weeks ago

    Default job background
    Description

    MANDATORY REQUIREMENTS:

    • 7+ years of experience in developing data conversion and migration
    • Extensive experience in data migration in terms of digital transformation,ETL experience in migrating data from legacy applications to modernized solutions.
    • 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 in ETL tools such as Azure Data Factory, Informatica, etc.

    SKILLS AND KNOWLEDGE:

    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

    Must haves:

    7+ years of experience in developing data conversion and migration

    Demonstrates extensive experience with the following:

    • Data migration in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions
    • Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
    • Experience in migrating document attachments from legacy solution to a new modernized solution
    • Experience working in cloud DB technologies (such as Azure SQL)

    Demonstrates knowledge and experience with the following:

    • Development of 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