Client is seeking a team of Consultants with collective knowledge and experience in data conversion and data cleansing to assist SOS in converting data from a legacy Oracle database to a modernMS SQL database using the Extract, Transform, and Load tools.
The resource team shall include a Lead Consultant, who will act as the primary Consultant for the services provided under this contract, and one or more additional Consultant personnel that will assist the Lead Consultant with the work and/or deliverables detailed in this SOW.
The Consultants to perform services under this Agreement shall work collaboratively with the SOS CARS SI vendor, SOS PRD staff and SOS ITD staff on all CARS data conversion activities.
The related roles and responsibilities are as identified below: CARS Project Task/Activity Mandatory
Develop CAL-ACCESS to CARS Data Migration and Integration Plan
Perform Data Clean up
Perform Data Migration extract, transform and load (ETL) from CAL-ACCESS into a blank CARS Database
CARS Data Integration and testing of full database with CARS System
A minimum of three (3) years administrating and maintaining Oracle database systems.
A minimum of three (3) years administrating and maintaining MS SQL databases.
A minimum of five (5) years of experience in SQL query development, query optimizations, rule-based transformation, and source file preparation.
A minimum of three (3) years developing and implementing data strategy for all databases