Data Migration SQL Specialist

Description

Summary of the work IPSA are implementing an integrated ERP solution to replace a variety of corporate systems. We are seeking a SQL data migration specialist to design and develop scripts that will extract data from existing systems and transform it to match the target schema. Specialist role Developer Expected Contract Length 3 Months (60 days) Latest start date Monday 30 October 2017 Maximum Day Rate Up to £650 per day for an exceptional candidate Who Speclialist Work With The developer will work closely with a technical lead that will provide the business requirements for the data migration and integration work. Some interaction with technical as-is/to-be system supplier staff may be required as well as liaison with internal technical and business stakeholders. What Specialists Work On 1.) Data migration technical requirements analysis 2.) Define Extract, Transform and Load (ETL) technical approach 3.) Iterative development and testing of SQL based ETL scripts 4.) Running scripts in live data migration environments 5.) Technical post-migration reconciliation testing 6.) Additional ad hoc SQL scripting as needed (e.g. to identify and correct data quality issues, support integration requirements etc.) 7.) Liaison with technical and business stakeholders Skills & Experience • Extensive MS SQL development experience • Extensive experience designing and developing ETL solutions for data migration • Experience producing detailed technical designs from higher-level business requirements • Database administration (DBA) experience in SQL Server Nice to Haves Experience working with the UNIT4 Business World On! ERP solution (formerly Agresso) Work Location The IPSA, 4th Floor, 30 Millbank, London, SW1P 4DU Working Arrangments Successful candidate will be available to work onsite full time. No expenses can be provided. Security Clearance CTC minimum held at the time of application. No. of Specialists to Evaluate 3 Cultural Fit Criteria • Experience working directly with both business and technical stakeholders • Ability to clearly articulate technical concepts for non-technical audiences • A pragmatic approach to problem solving and delivery • Experience working in a multi-vendor landscape Evaluation Weighting Technical competence 70% Cultural fit 10% Price 20% Questions from Suppliers 1. Does this position fall inside or outside of IR35? This position falls outside of IR35 legislation provided the supplier is a limited company. 2. 1. Regarding the CTC clearance status, if the candidate does not hold active CTC clearance and is willing to go through the process, can this be considered, if yes will you sponsor the security clearance. 2. What is the lead time for feedback once the application is submitted? 3. Any chances of change in start date as the latest date mentioned is 30th Oct 2017 4. What are the other expenses which will be paid? 5. What are the exact work locations? 6. Any specific format(pdf,doc) in which CVs to be sent later? 7. Is occasional remote working allowed? 1. CTC clearance must be held at the time of application2. Feedback will be provided on or before the 25th October3. We are prepared to consider a slightly later start date for an exceptional candidate4. No expenses will be paid5. The IPSA, 4th Floor, 30 Millbank, London, SW1P 4DU6. PDF 7. The role is full time onsite 3. 1.Is there any travel involved in this role and will the travel expenses be paid ? 2. Is the rate inclusive or exclusive of VAT? 3.Would you consider work permit holders (e.g. Tier 2 General Visa) and EU passport holders for this role ? 1. The role is based full time out of IPSA's London office. No travel to other sites is involved. No expenses will be paid.. 2. The maximum date rate is exclusive of VAT.3. Suppliers must have the right to work in the UK for the 60 day period specified, IPSA does not have a licence to sponsor Tier 2 General Visa applicants. Please note CTC clearance must also be held at the time of application.