N Consulting Global
Test Analyst (SDET) – Automation
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Title: Test Analyst (SDET) – Automation
Location: London, UK
Employment Type: Contract
Industry: Banking / Financial Services
Role Overview
We are looking for an experienced Test Analyst (SDET) – Automation to join our data transformation programme in London. The ideal candidate will have strong experience in data testing, ETL validation, migration testing, reconciliation, and test automation within enterprise data environments. Banking or financial services experience is highly desirable.
The successful candidate will be responsible for designing and executing automated testing solutions to ensure the quality, accuracy, and integrity of large-scale data migration and reporting initiatives while maintaining compliance with regulatory and business requirements.
Key Responsibilities
- Develop and implement comprehensive data testing strategies for large-scale migration programmes.
- Perform end-to-end data migration validation, ensuring completeness and accuracy of migrated data.
- Design and execute reconciliation testing between source and target systems.
- Develop automated frameworks for data quality validation and regression testing.
- Validate ETL processes and ensure data transformations meet business requirements.
- Perform SQL-based validation of complex datasets and identify discrepancies.
- Validate BI reports, dashboards, and analytical outputs against source data.
- Work closely with Business Analysts, Data Engineers, Developers, and Project Managers to define test scenarios and acceptance criteria.
- Produce test plans, test cases, execution reports, defect reports, and compliance documentation.
- Support regulatory and audit requirements by providing testing evidence and compliance reporting.
- Participate in Agile ceremonies, including sprint planning, daily stand-ups, retrospectives, and release planning.
- Drive continuous improvement in automation frameworks, testing processes, and quality standards.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Required Skills & Experience
Essential Skills
- Strong experience in ETL Testing.
- Advanced SQL skills for data validation and reconciliation.
- Hands-on experience with data migration testing.
- Strong knowledge of data reconciliation methodologies.
- Experience with Informatica and/or Azure Data Factory (ADF).
- Experience in data quality testing and validation.
- Hands-on experience in test automation for data platforms.
- Experience validating BI reports and dashboards.
- Strong analytical, troubleshooting, and defect management skills.
- Excellent stakeholder communication and documentation skills.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Desirable Skills
- Experience working in Azure-based data platforms.
- Banking or Financial Services experience.
- Knowledge of data governance and regulatory reporting.
- Experience with Agile/Scrum delivery methodologies.
Certifications
Preferred Certifications
- ISTQB Advanced Test Manager
- Certified Data Management Professional (CDMP)
- Microsoft Certified: Azure Data Engineer Associate (Desirable)
What We're Looking For
- Proven experience as a Test Analyst or SDET in enterprise data programmes.
- Strong understanding of data migration lifecycle and testing best practices.
- Ability to automate complex data validation scenarios.
- Experience working with cross-functional technical and business teams.
- Excellent problem-solving, communication, and stakeholder management skills.
- Ability to work in a fast-paced Agile delivery environment.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location