Senior Software Developer ETL

2 weeks ago

Toronto ON, Canada Knewin Full time

Senior Software Developer ETL

  • Contract Duration 2+ years



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

Deliverables:

  • Provide best practice migration solutions and oversee all facilities of the data and files migration from a legacy application to a new solution.
  • Establish a strong working relationship with clients, interact effectively at all levels, and analyze 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 that arise during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations
  • Senior Software Developer ETL works with importing files from heterogeneous platforms and coordinating data file migration.
  • Define testing strategy, plan and conduct 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


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


Evaluation Criteria:

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, importing data, manipulating 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 models 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 solutions.
  • 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 of 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 detail, including the 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, and 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 load programs.



Criteria 3 - Communication Skills (25 Points)

  • Communication, facilitation, negotiation, consensus-building, and problem-solving skills
  • Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders



Criteria 4 - Public Sector Experience (5 Points)

  • Previous experience working in Government or Public Sector organizations


Note :
  • Hybrid role- 3 days per week in the office required.

#gttca
#LI-GTT #J-18808-Ljbffr

  • Software Developer

    3 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    Title: Software Developer - ETL – Senior Duration: Business Days Location: Jarvis St, Toronto, Toronto, Ontario (Hybrid) General Skills:  Experience in programming and analysis; specialized software package support at the specified experience level  ...

  • Software Developer ETL

    3 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    Title: Software Developer - ETL Senior Location: Toronto, ON (Hybrid) Duration: Business Days + Possible extension Job Description: 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...

  • Senior ETL Software Developer

    3 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    Position: Senior ETL Software Developer Location: Toronto, ON (Hybrid) Duration: Business Days Job Description: Responsibilities: Support the branch in developing and implementing the technical solutions needed as well as providing operational support ensuring that any technical glitch can be quickly addressed Support the branch in data...

  • DI ETL Developer

    3 weeks ago

    Ottawa, ON, Canada Nexus Systems Group Inc. Full time

    DI ETL Developer - Senior DUTIES • Load target data bases using complex transformations that come from many systems. • Monitor loads and troubleshoot any issues that arise. • Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues. • Participate...

  • Software Developer

    3 weeks ago

    Toronto, Canada Computer Consultants International, Inc. Full time

    HYBRID position at Toronto, OntarioMust haves:7+ years of Data migration in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutionsExperience working in ETL tools such as Azure Data Factory, Informatica, etc.Experience in migrating document attachments from legacy solution to a new modernized...

  • ETL Developer

    1 day ago

    Toronto, ON, Canada Procom Full time

    ETL Developer - Informatica DEI On behalf of our client in the Healthcare Sector, PROCOM is looking for an ETL Developer - Informatica DEI. ETL Developer - Informatica DEI - Job Description This Senior Consultant/Developer will operate (run processes), maintain (small code changes) and develop changes (medium to major changes) to the portfolio of products...

  • ETL Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job...

  • ETL Developer Specialist

    21 hours ago

    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Do you enjoy working with different Cloud technologies such as IICS, Snowflake, AWS and in a collaborative environment? Do you like to contribute to adding value to company data? This is a great opportunity for you! We are looking for a ETL Specialist who will integrate data from the company’s diverse data source into our Enterprise Data Platform and make...

  • ETL Developer Specialist

    5 hours ago

    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Do you enjoy working with different Cloud technologies such as IICS, Snowflake, AWS and in a collaborative environment? Do you like to contribute to adding value to company data? This is a great opportunity for you! We are looking for a ETL Specialist who will integrate data from the company’s diverse data source into our Enterprise Data Platform and make...

  • ETL Developer Specialist

    21 hours ago

    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Do you enjoy working with different Cloud technologies such as IICS, Snowflake, AWS and in a collaborative environment? Do you like to contribute to adding value to company data? This is a great opportunity for you! We are looking for a ETL Specialist who will integrate data from the company’s diverse data source into our Enterprise Data Platform and make...

  • ETL Developer

    2 weeks ago

    Toronto, ON, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service Toronto Min. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • ETL Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionJob...

  • ETL Software Developer 7429-0112

    3 weeks ago

    Toronto, Canada Foilcon Full time

    HM Note: This hybrid role is three (3) days in officeDescription: • 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 solutionDELIVERABLES:• Provide best practice migration solutions and oversee all facilities of the data and...

  • ETL Developer

    2 days ago

    Toronto, Canada Procom Full time

    ETL Developer - Informatica DEI On behalf of our client in the Healthcare Sector, PROCOM is looking for an ETL Developer - Informatica DEI. ETL Developer - Informatica DEI - Job DescriptionThis Senior Consultant/Developer will operate (run processes), maintain (small code changes) and develop changes (medium to major changes) to the portfolio of products...

  • ETL Developer

    3 days ago

    Toronto, Canada Procom Full time

    ETL Developer - Informatica DEI On behalf of our client in the Healthcare Sector, PROCOM is looking for an ETL Developer - Informatica DEI. ETL Developer - Informatica DEI - Job DescriptionThis Senior Consultant/Developer will operate (run processes), maintain (small code changes) and develop changes (medium to major changes) to the portfolio of products...

  • ETL Developer

    2 days ago

    Toronto, Canada Procom Full time

    ETL Developer - Informatica DEI On behalf of our client in the Healthcare Sector, PROCOM is looking for an ETL Developer - Informatica DEI. ETL Developer - Informatica DEI - Job DescriptionThis Senior Consultant/Developer will operate (run processes), maintain (small code changes) and develop changes (medium to major changes) to the portfolio of products...

  • ETL Cloud Developer

    3 weeks ago

    Toronto, Canada CB Canada Full time

    The opportunityReporting to the Vice President of Enterprise Applications and working on the integration team, we are looking for an  ETL Cloud Developer. You will play a vital role in designing, developing and supporting a new real estate cloud-based data platform that supports global asset investment portfolios. Our new cloud-based ELT/ETL/AWS/AIS...

  • Data Engineer

    3 weeks ago

    Toronto, Canada hireVouch Full time

    Data Engineer**Reports to:** Senior Manager Decision Support and Data Insights Job Summary:We are seeking a highly skilled and motivated Data Engineer to join our team. The ideal candidate will have a strong background in developing ETL processes, managing a cost model in a SQL database, conducting code reviews, overseeing development processes, and...

  • ETL Developer

    2 days ago

    Old Toronto, Canada Zortechsolutions Full time

    Role: ETL DeveloperLocation: Toronto, ONDuration: Full TimeJob DescriptionSkills and Responsibilities: ETL data warehouse- MS SSIS/SSRS- IBM Netezza, MS SQL server/Sybase database Hadoop (Hive SQL and Pentaho ETL design) AWS Cloud services (Spark, Redshift and EMR) Knowledge in lending systems and functional knowledge on the same Knowledge in MDM systems for...

  • ETL Developer

    3 days ago

    Old Toronto, Canada Zortechsolutions Full time

    Role: ETL DeveloperLocation: Toronto, ONDuration: Full TimeJob DescriptionSkills and Responsibilities: ETL data warehouse- MS SSIS/SSRS- IBM Netezza, MS SQL server/Sybase database Hadoop (Hive SQL and Pentaho ETL design) AWS Cloud services (Spark, Redshift and EMR) Knowledge in lending systems and functional knowledge on the same Knowledge in MDM systems for...