ETL Test Lead CGEMJP00320103

ETL Test Lead CGEMJP00320103

Posted 6 days ago by 1765606646

Apply
Negotiable
Inside
Hybrid
Milton Keynes
Apply
Automation Bank Reconciliations Data Analysis Data Quality Extract Transform Load (ETL) Input/Output Life Cycle Planning Management Mapping Software Reconciliation Scheduling Test Automation Test Data Test Execution Engine Test Management Test Strategy User Acceptance Testing (UAT) Verification And Validation

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 is a contract role running until the end of 2026. The role is hybrid, requiring two days per week on-site, and is classified as inside IR35 with a daily rate of up to £230 via umbrella.

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
  • Execute Test Scenarios & Test cases as per the agreed plan and schedule across various different Test phases & Test cycles
  • Identify & log defects and participate & support defect triage
  • Input identified RAID to Test Lead &/or Test Manager
  • Provide Reports on Test status as requested by the Test Lead/ Test Manager periodically
  • Ensure that all testing activities align with the Organisation's Testing Policy & Strategy
  • Provide UAT & ELS Support via Test creation, Test Preparation, Test execution, Defect Retests, Regression Tests, Demo's, etc.
  • Create Knowledge Transfer documentation at various different points in the project as requested by Test Lead/ Test Manager
  • Support creation and maintenance of Test RTM

Key Skills:

  • ETL team lead experience
  • Bank Regulatory reporting experience
  • End-to-end data analysis and testing experience
  • Understanding of ETL, data reconciliation, validation, and defect triage
  • Ability to work with large datasets
  • Proactive and self-sufficient work style
  • Clear communication skills for defect descriptions
  • Familiarity with source-to-target mapping and data quality checks
  • Experience in Test Strategy & Approach
  • Ability to create Test Plans and Test Cases
  • Experience in Test Execution and Defect Management
  • Knowledge of RAID management
  • Reporting skills for Test status
  • Quality Assurance knowledge
  • Experience in UAT & ELS Support
  • Knowledge Management skills
  • Experience in Test RTM maintenance

Salary (Rate): £230 daily

City: Milton Keynes

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: Mid-Level

Industry: IT

Detailed Description From Employer:

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!

Apply
Similar Jobs
Loading data...