ETL Test Lead CGEMJP00320103

ETL Test Lead CGEMJP00320103

Posted 6 days ago by Experis IT

Negotiable
Inside
Hybrid
Milton Keynes, UK

Summary: The ETL Test Lead role in Milton Keynes involves leading an ETL team with a focus on Bank Regulatory reporting. The position requires extensive experience in data analysis and testing, particularly with large datasets and transformation issues. The contract is set to run until the end of 2026, with a hybrid working arrangement requiring two days on-site each week. The role is classified as inside IR35 and offers a daily rate of up to £230 via an umbrella company.

Key Responsibilities:

  • Must have ETL team lead, Bank Regulatory reporting experience
  • Proven experience in end-to-end data analysis and testing - across multiple cutovers and cycles
  • Understanding of ETL, data reconciliation, validation, and defect triage
  • Comfortable working with large datasets and identifying transformation or mapping issues
  • Able to work independently - Proactive, self-sufficient, and structured
  • Can write clear defect descriptions and escalate data load/reconciliation issues effectively
  • Familiar with source-to-target mapping, data quality checks, and post-load validation
  • Provide inputs into Overall Test Strategy & Approach for the Project
  • Support and input into detailed test plans for various test phases
  • Analyse Requirements and Design documents to create Test cases, identify pre-requisites and manage tests across the test life cycle
  • Write Test Scenarios and Test Cases for various Test Phases, input into Test Automation Script, Test data preparation and provide UAT Support
  • Execute Test Scenarios & Test cases as per the agreed plan and schedule across various different Test phases & Test cycles
  • Identify & log defects, participate & support defect triage
  • Input identified RAID to Test Lead &/or Test Manager
  • Support reporting into TAG (Test Assurance and Governance) Board
  • Provide Reports on Test status as requested by the Test Lead/Test Manager periodically
  • Input status into Entry/Exit criteria and provide evidence for all pre requisites identified
  • Support Go/No-Go meetings & regular Test check point meetings
  • Ensure that all testing activities align with the Organisation's Testing Policy & Strategy
  • Conduct and participate in Peer reviews
  • Provide UAT & ELS Support via Test creation, Test Preparation, Test execution, Defect Retests, Regression Tests, Demo's, etc.
  • Provide test knowledge support where required and create Knowledge Transfer documentation
  • Support creation and maintenance of Test RTM

Key Skills:

  • Overall Test Strategy & Approach
  • Phase Test Plans
  • Test Analysis
  • Test Preparation
  • Test Execution
  • Defect Management
  • RAID management
  • Test Reporting
  • Test Assurance
  • Quality Assurance
  • Test Support
  • Knowledge Management
  • Test RTM maintenance

Salary (Rate): £230 daily

City: Milton Keynes

Country: UK

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT

ETL Test Lead
Milton Keynes, hybrid 2 days per week onsite
Contract to run until 31/12/2026
Up to £230 p/d Via umbrella inside IR35

Role purpose/summary

  • Must have ETL team lead, Bank Regulatory reporting experience
  • Proven experience in end-to-end data analysis and testing - across multiple cutovers and cycles
  • Understanding of ETL, data reconciliation, validation, and defect triage
  • Comfortable working with large datasets and identifying transformation or mapping issues
  • Able to work independently - Proactive, self-sufficient, and structured
  • Can write clear defect descriptions and escalate data load/reconciliation issues effectively
  • Familiar with source-to-target mapping, data quality checks, and post-load validation

Key Skills/requirements

  • Overall Test Strategy & Approach: Where required, provide inputs into Overall Test Strategy & Approach for the Project.
  • Phase Test Plans : Support and input into detailed test plans for various test phases.
  • Test Analysis : Analyse Requirements and Design documents to create Test cases, identify pre-requisites and manage tests across the test life cycle.
  • Test Preparation : Write Test Scenarios and Test Cases for various Test Phases. Input into Test Automation Script, Test data preparation and provide UAT Support. Identify Regression Test cases, create and update Regression Test pack.
  • Test Execution : Execute Test Scenarios & Test cases as per the agreed plan and schedule across various different Test phases & Test cycles.
  • Defect Management : Identify & log defects. Participate & support defect triage.
  • RAID : Input identified RAID to Test Lead &/or Test Manager.
  • Support reporting into TAG (Test Assurance and Governance) Board.
  • Test Reporting : Provide Reports on Test status as requested by the Test Lead/Test Manager periodically.
  • Test Assurance : Input status into Entry/Exit criteria and provide evidence for all pre requisites identified.
  • Support Go/No-Go meetings & regular Test check point meetings.
  • Quality Assurance: Ensure that all testing activities align with the Organisation's Testing Policy & Strategy.
  • Conduct and participate in Peer reviews.
  • Test Support : Provide UAT & ELS Support via Test creation, Test Preparation, Test execution, Defect Retests, Regression Tests, Demo's, etc.
  • Knowledge Management: Across the Test Lifecycle, provide test knowledge support where required. Create Knowledge Transfer documentation at various different points in the project as requested by Test Lead/Test Manager.
  • Test RTM : Support creation and maintenance of Test RTM.

Key benefits to be derived from the service: To ensure that any system changes made to support the project objectives have been tested and verified in line with Organisation Test Policy & Strategy. It will enable the project to understand more about the quality of those system changes and will facilitate the project making evidence-based decisions about whether to proceed from development and testing into the implementation phase of the project.

All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!