Software Developer Etl Senior

Toronto, ON, Canada

Job Description

Role: Software Developer - ETL - Senior
Location: 21 College Street, Toronto. (Onsite)
Duration: 12 Months Contract With possible extension.
Criteria 1: Data Knowledge Expertise Skills - 35 Points

  • 7+ years of experience in developing data conversion and migration
  • At least one experience of working with migrating data from different legacy platforms to a new solution.
  • Full life-cycle data conversion experience with enterprise systems, including deployment experience.
  • Data analysis, investigative and logic skills, including the ability to troubleshoot and solve complex technical problems.
  • Experience with overseeing /completing all tasks involved in the conversion process including data extraction, profiling, cleansing, import data, manipulate data, transformation and loading.
  • Experience liaising with teams to understand to-be migration requirements.
  • Knowledge and understanding of Information Management principles, concepts, policies and practices.
  • Experience providing support through the cutover process.
  • Knowledge of data model of case management solutions and experience in data migration/conversion of large case management applications.
  • Experience with migrating attachment files from legacy applications to new solution.
  • Experience with document migration
Criteria 2: Technical Skills - 35 Points
  • Experience with industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
  • Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
  • Exceptional level of knowledge on relationships between tables to perform and construct complex query statements from multiple data sources.
  • Knowledge of various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, etc.,
  • Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
  • Data analysis, investigative and logic skills with high attention to details, including ability to troubleshoot and solve complex technical problems.
  • Experience with data conversion scripts and tools.
  • Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, Oracle BLOBs.
  • Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation and verifying completeness and accuracy of converted data, including data dictionary development and updates.
  • Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
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.
  • Knowledge and experience in 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.

Skills Required

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD3293821
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Toronto, ON, Canada
  • Education
    Not mentioned