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 data excellence.
- Benefits: Enjoy competitive pay, flexible working arrangements, and opportunities for professional growth.
- Why this job: This role offers hands-on experience with cutting-edge analytics tools 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 (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 are commonly used in the industry. Being able to discuss your hands-on experience with these tools during an interview can set you apart from other candidates.
✨Tip Number 2
Brush up on your SQL skills, especially focusing on writing queries that check for data integrity and transformation. You might be asked to demonstrate your SQL knowledge in a practical test or during the interview.
✨Tip Number 3
Prepare to discuss your experience with Agile Testing practices. Be ready to share examples of how you've participated in test management activities and how you handle defect management in your previous roles.
✨Tip Number 4
Showcase your ability to work independently on complex projects. Think of specific instances where you've successfully analysed business requirements and translated them into testing strategies, as this will demonstrate your self-starter attitude.
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.
Showcase Technical Skills: Clearly outline your technical skills, especially in DB-related testing, SQL, and ETL testing. Provide examples of how you've transformed complex business logic into SQL or PL/SQL queries in previous roles.
Write a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your willingness to follow Agile Testing practices and your experience in defect management, as these are key aspects of the position.
Highlight Problem-Solving Abilities: Demonstrate your ability to work independently on complex projects. Include specific examples of how you've identified and documented testing issues and quality risks in past experiences.
How to prepare for a job interview at Vallum Associates
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL and ETL testing in detail. Highlight specific projects where you transformed complex business logic into SQL queries, and be ready to explain your approach to data integrity and validation.
✨Demonstrate Your Understanding of QA Lifecycle
Make sure to articulate your knowledge of the QA/Testing lifecycle. Discuss how you've implemented testing strategies in previous roles and how you ensure quality throughout the development process.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving skills. Think of examples where you identified testing issues or quality risks and how you participated in defect remediation.
✨Familiarise Yourself with Agile Practices
Since the role requires a willingness to follow Agile Testing practices, brush up on Agile methodologies. Be ready to discuss how you've worked in Agile environments and contributed to test management activities like assessment and planning.
