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 developing and documenting ETL processes for data conversion and migration projects.
Extensive experience with:
Data migration and migration planning for digital transformation initiatives.
Migrating data from legacy applications to modernized solutions using ETL methodologies.
Relational databases such as Oracle, MS SQL Server, and Azure SQL Database.