ETL MIGRATION DEVELOPER - ORACLE-SQL-CONTRACT-LONDON

ETL MIGRATION DEVELOPER - ORACLE-TO- SQL MIGRATION-LONDON

Leading Managed Services Provider in the Defence Sector require an ETL Data Migrations Consultant who has experience in Data migration from legacy Oracle based application to the new SQL based application refined and tested. A Transformation Program to complete and accurate transformation program capable of producing a set of data files.

Location: Colindale - Central London

Onsite 5 day a week

Duration: 6-9 Months+extension

**A national security clearance is required for this role but candidates not holding this level of clearance will be considered**

Responsibilities:

Extract: Export and decrypt data from the source Oracle 9i database (training instance)

Develop: Develop the transformation program against the training data set - c. 20% remaining. Remainder will be based on areas of functionality that are not yet fully developed, including BRC functionality that requires further refinement by the software delivery supplier

Develop: Further refine the transformation program against the live data set. The live data set contains secret level data and can only be processed in a secure environment

Load: Import data into the data migration SQL 2016 database instance

Validate: Further develop and execute data validation

Support: Support testing activities

Contingency: Define and implement a roll-back approach

Plan: Look at ways to minimise business disruption

Live data migration from legacy Oracle based application to the new SQL based application

Extract: Export and decrypt live data from the source Oracle 9i database

Transform: the live data set

Load: Import data into the SQL 2016 production database instance

Validate: Execute data validation

Test: Support testing activities

Support: Provide Early Life Support (ELS) following go live of the production instance, estimated to be a period of 6 weeks

Remediation: Identify and resolve issues

Please apply via this ad in the first instance or send a CV with covering note or contact me on 07587743762 or Balla@projectpeople.com

Project People is acting as an Employment Business in relation to this vacancy.