Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as an ETL Tester, ensuring data quality and integrity through rigorous testing.
- Company: Be part of a dynamic team in the heart of London, driving innovation in data analytics.
- Benefits: Enjoy competitive pay, flexible working arrangements, and opportunities for professional growth.
- Why this job: This role offers hands-on experience with cutting-edge technology and a chance to impact business decisions.
- Qualifications: 4+ years in data warehouse or ETL testing; degree in a quantitative field preferred.
- Other info: Ideal for self-starters who thrive in Agile environments and love tackling complex challenges.
The predicted salary is between 55000 - 77000 £ per year.
Rate: £275/day inside IR35
Requirements:
- 4+ years of experience as a Data Warehouse Developer Tester or ETL Tester
- Graduate degree preferred in Computer Science, Statistics, Informatics, Information Systems or another quantitative field
- Expert in understanding and implementing QA/Testing Lifecycle
- Expertise in DB-related testing and ETL testing
- Testing experience with reporting and BI tools
- Writing basic SQLs to check record counts, data truncation, invalid data types, NULLs and data integrity, data transformation, aggregate functions testing
- Expertise preferred in testing our current or a similar analytics stack
- Experience in transforming complex Business logic into SQL or PL/SQL queries
- Must be a self-starter with the ability to work on complex projects and analyse business requirements independently
- Must be able to identify and document testing issues and quality risks, participate in defect remediation
- Willingness to follow Agile Testing practices and guidelines, including Defect Management
- Actively participate in all test management activities like assessment, test strategies and test plans
- Knowledge of Database objects and relational data model
- Experience in scripting
- Test automation experience is a huge plus
- Understanding of ETL requirements (source-to-target mappings)
- Testing experience with different file types
ETL Tester (London Area) employer: Vallum Associates
Contact Detail:
Vallum Associates Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ETL Tester (London Area)
✨Tip Number 1
Familiarise yourself with the specific ETL tools and technologies that are commonly used in the industry. This will not only help you understand the role better but also allow you to speak confidently about your experience during interviews.
✨Tip Number 2
Network with professionals in the data testing field, especially those who work in similar roles. Attend meetups or webinars focused on ETL testing to gain insights and potentially get referrals for job openings.
✨Tip Number 3
Brush up on your SQL skills, particularly focusing on writing queries that check for data integrity and transformation. Being able to demonstrate your SQL proficiency can set you apart from other candidates.
✨Tip Number 4
Prepare to discuss your experience with Agile methodologies and how you've applied them in past projects. Employers value candidates who can adapt to their processes and contribute effectively from day one.
We think you need these skills to ace ETL Tester (London Area)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience as a Data Warehouse Developer Tester or ETL Tester. Emphasise your expertise in QA/Testing Lifecycle and any relevant projects you've worked on that align with the job requirements.
Craft a Strong Cover Letter: Write a cover letter that specifically addresses the skills mentioned in the job description. Discuss your experience with DB-related testing, SQL proficiency, and your ability to work independently on complex projects.
Showcase Relevant Skills: In your application, clearly outline your experience with testing reporting and BI tools, as well as your familiarity with Agile Testing practices. Mention any test automation experience you have, as this is considered a huge plus.
Highlight Problem-Solving Abilities: Demonstrate your ability to identify and document testing issues and quality risks. Provide examples of how you've participated in defect remediation and contributed to test management activities in previous roles.
How to prepare for a job interview at Vallum Associates
✨Showcase Your Technical Skills
Be prepared to discuss your experience with ETL testing and data warehouse development. Highlight specific projects where you implemented QA/testing lifecycles and how you tackled challenges related to data integrity and transformation.
✨Demonstrate SQL Proficiency
Since writing basic SQLs is crucial for this role, be ready to explain your approach to checking record counts, handling NULLs, and ensuring data quality. You might even be asked to write a simple query during the interview, so brush up on your SQL skills!
✨Understand Agile Methodologies
Familiarise yourself with Agile Testing practices, as this role requires adherence to these guidelines. Be prepared to discuss how you've participated in test management activities and how you handle defect management in an Agile environment.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving abilities. Think of examples where you transformed complex business logic into SQL queries or identified testing issues. This will demonstrate your analytical skills and ability to work independently on complex projects.
