SQL Developer

Channel 3 Consulting Ltd
London (Greater)
12 Jan 2018
10 Feb 2018
Contract Type
Full Time


Clinical System Data Migration Project

One of our very close clients are resourcing for an urgent hire to help with data migration.

They are in need of techniccally savvy SQL developers that have the experience of working with SystmOne's back end. Furthermore the ideal candidate will have proven experience with:

Java script writing

Volumetric profiling and analysis

Trouble shooting

Read code mapping

Go live support

The migration requires in-depth analysis of the original data to provide insight to support TPP in converting it into equivalent components in SystmOne. Furthermore, the Quantitative aspect of the testing requires volumetric profiling of Jade data in a comparative analysis against equivalent profiling of the returned SystmOne data. To achieve this, the data migration work stream requires data migration developers to:

  • Write baseline profile SQL scripts of original data
  • Write SQL scripts against the data to support migration rules
  • Provide data to support any migration queries from TPP
  • Write SQL scripts to highlight the data quality issues that will impact migration
  • Write equivalent scripts against SystmOne data once received
  • Write SQL scripts to provide data for volumetric testing
  • Provide data and analytical support to the Project Team
  • Provide quantification to support and document any Read Code mapping
  • Provide quantification for any issues observed during testing
  • Support the cutover process with data extraction and volumetric testing tasks

This job was originally posted as www.jobsite.co.uk/job/959886279