Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as an ETL Tester, focusing on data quality and testing processes.
- Company: Be part of a dynamic team in the heart of London, driving data excellence.
- Benefits: Enjoy competitive pay, flexible working arrangements, and opportunities for growth.
- Why this job: This role offers hands-on experience with cutting-edge analytics and a chance to impact business decisions.
- Qualifications: 4+ years in data testing, with a 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 (City of London) employer: Vallum Associates
Contact Detail:
Vallum Associates Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ETL Tester (City of London)
✨Tip Number 1
Familiarise yourself with the specific ETL tools and technologies that we use at StudySmarter. Highlighting your experience with similar tools during discussions can set you apart from other candidates.
✨Tip Number 2
Brush up on your SQL skills, especially in writing queries that check for data integrity and transformation. Being able to demonstrate your proficiency in SQL during interviews will show that you're ready to tackle the technical challenges of the role.
✨Tip Number 3
Prepare to discuss your experience with Agile methodologies. We value candidates who can adapt to our testing practices, so be ready to share examples of how you've successfully worked in Agile environments before.
✨Tip Number 4
Showcase your problem-solving skills by preparing examples of complex business logic you've transformed into SQL or PL/SQL queries. This will demonstrate your analytical abilities and your fit for the role.
We think you need these skills to ace ETL Tester (City of London)
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 description.
Craft a Strong Cover Letter: Write a cover letter that specifically addresses the requirements listed in the job description. Mention your experience with SQL, DB-related testing, and any familiarity with Agile Testing practices to show you’re a great fit for the role.
Showcase Relevant Skills: In your application, clearly outline your skills in testing reporting and BI tools, as well as your ability to transform complex business logic into SQL queries. This will demonstrate your technical proficiency and understanding of the role.
Proofread Your Application: Before submitting, carefully proofread your application for any errors or inconsistencies. A polished application reflects your attention to detail, which is crucial for an ETL Tester role.
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 warehousing in detail. Highlight specific projects where you implemented QA/testing lifecycles, and be ready to demonstrate your knowledge of SQL and PL/SQL through practical examples.
✨Understand the Business Logic
Since transforming complex business logic into SQL queries is crucial for this role, make sure you can explain how you've approached similar challenges in the past. Use real-world scenarios to illustrate your problem-solving skills.
✨Familiarise Yourself with Agile Practices
As the company values Agile Testing practices, brush up on your understanding of Agile methodologies. Be ready to discuss how you've participated in test management activities and how you handle defect management within an Agile framework.
✨Prepare Questions About the Analytics Stack
Research the company's current analytics stack and prepare insightful questions about it. This shows your genuine interest in the role and helps you understand how your skills can contribute to their specific needs.
