Current jobs related to RQ09299 - Software Developer - ETL - Senior - Toronto, Ontario - Maarut Inc

  • RQ09299 - Software Developer - ETL - Senior

    1 week ago

    Toronto, Ontario, Canada Amanst Inc Full time $30,000 - $120,000 per year

    Must Haves7+ years of experience in developing data conversion and migrationExperience working in ETL tools such as Azure Data Factory, Informatica, etc.Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,Nice to Have:Knowledge and experience in development of business case, data migration strategy and planKnowledge and understanding...

  • RQ09460 - Software Developer - ETL - Senior

    1 week ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $120,000 - $180,000 per year

    Client: Ministry of Public and Business Service Delivery and ProcurementWork Location:595 Bay Street, Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:130.00Extension:Probable after the initial mandateHours per day or Week:7.25 hours per daySecurity Level:CRJMC + Credit CheckMust Have5+ years of proven working experience in an...

  • Rq09299

    1 week ago

    Toronto, Ontario, Canada Source Code Full time $80,000 - $150,000 per year

    RQ Sr. Software Developer - ETLContract 1 year, 2 possible extensionsOnsite / 21 College Street, TorontoSecurity Level: EnhancedScopeA senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solutionAssignment DeliverablesProvide best...

  • RQ09886 - Software Developer - ETL - Senior

    1 week ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $80,000 - $120,000 per year

    Client: Ministry of Public and Business Service Delivery and ProcurementWork Location:595 Bay Street, Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:165.00Extension:Probable after the initial mandateHours per day or Week:7.25 hours per daySecurity Level:CRJMC + Credit CheckMust Have5+ years of proven working experience in an...

  • Senior Java/ ETL Software Developer

    6 days ago

    Toronto, Ontario, Canada Source Code Full time $80,000 - $120,000 per year

    Senior Java/ ETL Software Developer (Java, Informatica, ETL, SQL, PL/SQL,and Power BI)Toronto, Ontario - Hybrid, 3 days onsite - 87 Sir William Hearst Ave Toronto, ON M3M 0B4Contract, 9 months (with possibly of extension) Employment Ontario is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training,...

  • RQ10027 - Software Developer - ETL - Senior

    1 week ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $80,000 - $120,000 per year

    Client: Ministry of Treasury Board SecretariatWork Location:222 Jarvis St., Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:274.00Extension:130.00Hours per day or Week:7.25 hours per daySecurity Level:CRJMCMust HaveExperience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data...

  • Senior ETL Developer

    1 week ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    RQ Software Developer - ETL – SeniorLocation:Onsite / 595 Bay Street, TorontoPeriod:  6-monthsMust-haves:·      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. Understanding of data pipeline...

  • RQ10027 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $100,000 - $120,000 per year

    Responsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.Required to translate technical systems specifications into working, tested applications.This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs,...

  • RQ10027 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $100,000 - $150,000 per year

    Responsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs,...

  • RQ09460 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $120,000 - $180,000 per year

    Scope:The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer – ETL to validate the data migration from the existing OPGT legacy applications to the new Dynamics 365 OPGT solution. Assignment Deliverables: As a member of the data migration team, you will be responsible for validating the quality of the data...

RQ09299 - Software Developer - ETL - Senior

2 weeks ago

Toronto, Ontario, Canada Maarut Inc Full time $100,000 - $120,000 per year

Scope:

  • A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution

Assignment Deliverables:

  • Provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution. 
  • Establish a strong working relationship with clients, interact effectively at all levels and analyses legacy data and files stored in a variety of data sources and formats.
  • Analyze and complete data profiling and suggest any pre migration data cleansing activities.
  • Complete data migration strategy, data mapping, define interfaces, perform mock conversion, define enhancements and perform actual conversion.
  • Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
  • Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations
  • Work with importing files from heterogeneous platforms and coordinates data file migration.
  • Define testing strategy, plan and conducts testing to ensure data integrity and data comparisons.
  • Perform post migration audit and data reconciliation.
  • Generate data migration exception reporting and perform data cleansing as required.
  • Provides pre- and post-effective conversion support to business clients


Requirements

Experience and Skill Set Requirements:

Must Haves:

  • 7+ years of experience in developing data conversion and migration
  • Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
  • Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,

 

Nice to Have:

  • 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

Skill Set Requirements:

Mandatory Requirements:

  • 7+ years of experience in developing data conversion and migration
  • 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

Desired Skills and Experience:

  • 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.
  • Experience ensuring the data migration solution is scalable.
  • Data analysis, investigative and logic skills with high attention to detail
  • Experience with migrating file attachments from legacy applications to new solution.
  • Experience in migrating document attachments from legacy solution to a new modernized solution.
  • Experience with data conversion scripts and various ETL tools such as Informatica, Azure Data Factory, etc.
  • Experience with overseeing /completing all tasks involved in the conversion process including data extraction, cleansing, transformation and loading
  • Experience liaising with teams to understand to-be migration requirements.
  • Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
  • Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
  • Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
  • Experience providing support through the cutover process
  • A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience
  • Communication, facilitation, negotiation, consensus building, and problem-solving skills

Data Knowledge Expertise Skills:

  • Experience 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.
  • 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

Experience with Document Migration:

  • 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, etc., Azure SQL Database, and write complex SQL queries.
  • 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 industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
  • 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.

Communication Skills:

  • Communication, facilitation, negotiation, consensus building, and problem-solving skills
  • Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders
  • Experience liaising with teams to understand to-be migration requirements.

Public Sector Experience:

  • Previous experience working in Government or Public Sector organizations