Lotus Notes Consultant - #2201366
Hays Specialist Recruitment Limited
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
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Optical Consultant - Foundation
Duty Manager - Multi-Brand
Data Protection Officer (Temp)