About this role
Job Description
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 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.
- Complex SQL development, data analysis, data val