Back to jobs
Hays

Hays

Lotus Notes Consultant

City of Edinburgh On-site 5-10 yrs exp Staffing and Recruiting 31,859 employees£450 – £600
Lotus NotesHCL NotesDominoData ExtractionETL

Sponsorship unclear

1 of 5 checks passed, 1 to note

  • No result: Register
    • Employer not matched to the register yet
  • No result: Job ad
    • No clear sponsorship commitment in the ad
  • No result: Visa routes
    • No visa routes listed
  • To note: Salary check
    • SOC 2133 going rate £54,900/yr — occupation qualifies
    • Stated salary £600 below going rate/threshold (~£54,900)
  • Passed: Occupation
    • Degree-level or skilled occupation (RQF 6+)

Checked against the Home Office register of licensed sponsors and the advert itself.

Requirements

Strong experience extracting and migrating data from complex legacy environments, with a good technical understanding of Lotus Notes/HCL Notes and Domino, is required. Relevant experience includes ETL, data cleansing and validation, profiling, mapping, scripting, reconciliation, stakeholder engagement, and migration documentation.

Job Description

Your new company and role


You will be joining a public sector organisation undertaking a major transformation of its systems, migrating from a long-established Lotus Notes environment to a modern case management platform. As a Lotus Notes / Domino Migration Specialist, you will take responsibility for the extraction, transformation and cleansing of legacy data ahead of its migration. The focus will be on understanding a complex legacy Lotus Notes environment, identifying where required information is held and carrying out the ETL activity needed to produce accurate, cleansed and migration-ready data. Working closely with technical colleagues, business stakeholders and third-parties, you will:

  • Investigate existing Lotus Notes/Domino databases and understand their underlying data structures.
  • Identify and extract the data required for migration.
  • Develop and execute ETL processes to transform legacy data into the required target structures.
  • Analyse and cleanse legacy data, identifying duplicates, inconsistencies, missing information and other data-quality issues.
  • Map legacy fields and data structures against the requirements of the new system.
  • Validate extracted and transformed datasets to ensure completeness and accuracy.
  • Work with business users to understand the meaning and context of legacy data where required.
  • Liaise closely with the SI to ensure datasets meet agreed migration specifications.
  • Resolve issues identified during migration and data-validation cycles.
  • Document extraction processes, transformations, mappings and data-quality decisions.



What you'll need to succeed


You will have strong experience of extracting and migrating data from complex legacy environments, combined with a good technical understanding of Lotus Notes / HCL Notes and Domino. You will ideally have experience across:

  • Lotus Notes / Domino databases and data structures.
  • ETL and data migration projects.
  • Extracting data from complex or poorly documented legacy systems.
  • Data cleansing, transformation and validation.
  • Data profiling and identifying data-quality issues.
  • Source-to-target data mapping.
  • Developing scripts, queries or routines to automate data extraction and transformation.
  • Reconciling migrated datasets and investigating discrepancies.
  • Working with Systems Integrators and third-party implementation partners.
  • Gathering information from technical and non-technical stakeholders.
  • Producing clear data-mapping and migration documentation.



What you need to do now


If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk

Skills

Lotus NotesHCL NotesDominoData ExtractionETLData MigrationData CleansingData TransformationData ValidationData ProfilingSource-to-Target MappingData ReconciliationScriptingData Quality AnalysisStakeholder EngagementMigration Documentation

About Hays

At Hays, we believe that the right job can transform a person's life - and the right person can transform a business. From career‑defining opportunities to complex workforce strategies, we connect ambition with opportunity - helping people and organisations reimagine what’s possible. Every year we place over 200,000 professionals into new roles. Whether it’s a permanent role or a temporary contract, our specialist consultants provide tailored advice and market intelligence to accelerate careers, from emerging talent to executive leadership. For organisations, our expert teams build recruitment and workforce solutions shaped by real-time market insights, local expertise and the scale of a world leading specialist in white collar hiring. With operations in 30 countries, over 200 offices and 9,500 colleagues worldwide, we fill around 1,000 roles every working day. The future of work isn’t something we’re waiting for.  We’re creating it every day.