ETL Software Developer 7285-0214

HM Note: This hybrid role is three (3) days in office and starts May 6 2024

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 legacy application to a new solution. and nbsp;

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 datadriven 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 posteffective conversion support to business clients

Skills

Experience and Skill Set Requirements

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 AND KNOWLEDGE:

Full lifecycle 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 PLSQL.

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 nonrelational data structures

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 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 tobe 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 problemsolving skills

CRITERIA:

Criteria 1 Data Knowledge Expertise Skills (35 Points)

7 years of experience in developing data conversion and migration

Experience working with migrating data from different legacy platforms to a new solution.

Full lifecycle data conversion experience with enterprise systems including deployment experience.

Knowledge of various database structures and RDMS like Oracle DB MS SQL Server Azure SQL Database and write complex SQL queries etc.

Data analysis investigative and logic skills.

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 tobe 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)

Proficiency in query languages such as Oracle SQL PLSQL 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 nonrelational data structures

Data analysis investigative and logic skills with high attention to details.

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.

Criteria 3 Communication Skills (25 Points)

Communication facilitation negotiation consensus building and problemsolving 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

KNOWLEDGE TRANSFER:

Knowledge to be Transferred:

All documentation relating to the technology designs and technology knowledge specific to the candidates assignment All information gathered while working with vendors and internal solutions to be shared Any best practices work around lessons learned must be documented

Knowledge to be Transferred to:

Project Manager / Team members

Details of Transfer:

1:1 meetings / team meetings / documentation on SharePoint site throughout the duration of the project life cycle etc.

Must Haves:

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