| Job Title: | ETL MIGRATION DEVELOPER - ORACLE-SQL-CONTRACT-LONDON |
| Contract Type: | Contract |
| Location: | London |
| Industry: | |
| Salary: | Negotiable |
| Duration: | 6-9 months |
| REF: | ETL-BJ_1665146855 |
| Contact Name: | Balla J |
| Contact Email: | Balla@projectpeople.com |
| Job Published: | over 2 years ago |
Job Description
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.
