Data Migration Consultant
at Opus Recruitment Solutions
Bath, England, United Kingdom -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 27 Jun, 2024 | GBP 400 Annual | 27 Mar, 2024 | N/A | Project Managers,Continuous Improvement,Test Cases,Stored Procedures,Requirements Gathering,Normalization,It,Data Validation,Databases,Documentation,Testers,Developers,Data Structures,Collaboration,Ir35 | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
Description:
My client is looking for a SQL Data Migration Consultant / Developer to come on board for an initial 3 months contract to help on a SQL migration project.
• EXPERIENCE IN SQL DEVELOPMENT
Desirable
- Previous CRM/Billing migration experience
Responsibilities include:
1. Requirements Gathering: Collaborate with stakeholders to understand the scope of the SQL migration project, including data sources, target databases, performance requirements, and any special considerations.
2. Database Analysis: Analyze the existing SQL databases to identify data structures, dependencies, stored procedures, functions, triggers, and other database objects that need to be migrated.
3. SQL Scripting: Write SQL scripts to extract data from the source databases, transform it as necessary, and load it into the target databases. This may involve data cleansing, normalization, denormalization, and other data manipulation tasks.
4. Data Validation: Develop and execute test cases to validate the accuracy, completeness, and consistency of the migrated data. Compare data between source and target databases to identify discrepancies and reconcile any differences.
5. Documentation: Maintain documentation detailing the migration process, including data mappings, transformation rules, migration scripts, configuration settings, and testing procedures.
6. Collaboration: Collaborate with other team members, including database administrators, developers, testers, and project managers, to ensure the successful completion of the SQL migration project within the defined timeline
7. Communication: Communicate regularly with stakeholders to provide updates on the progress of the migration project, address any issues or concerns, and solicit feedback for continuous improvement.
This role will be outside of IR35 paying from £300-£400 per day. With the ideal candidate willing to come onsite 1 time a week to their Bath office but this is NOT an essential fully remote is being considered
If you are interested please send me your updated CV to becca. coombes @ Opusrs. co
Responsibilities:
Please refer the Job description for details
REQUIREMENT SUMMARY
Min:N/AMax:5.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Software Engineering
Graduate
Proficient
1
Bath, United Kingdom