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: We are a dynamic tech company dedicated to data-driven solutions.
- Benefits: Enjoy competitive pay, flexible working arrangements, and opportunities for growth.
- Why this job: Be part of a collaborative team that values innovation and quality in data management.
- Qualifications: 4+ years in data warehouse testing; degree in a quantitative field preferred.
- Other info: Experience with Agile practices and test automation is a big plus!
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 employer: Vallum Associates
Contact Detail:
Vallum Associates Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ETL Tester
✨Tip Number 1
Familiarise yourself with the specific ETL tools and technologies that we use at StudySmarter. Having a solid understanding of our analytics stack will give you an edge during discussions and interviews.
✨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 ability to handle complex business logic will impress us.
✨Tip Number 3
Showcase your experience with Agile Testing practices. We value candidates who can actively participate in test management activities, so be prepared to discuss how you've contributed to test strategies and defect management in past roles.
✨Tip Number 4
Highlight any experience you have with test automation. If you've worked on automating testing processes, make sure to mention this, as it’s a huge plus for us and can set you apart from other candidates.
We think you need these skills to ace ETL Tester
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: In your cover letter, explain why you're a great fit for the role. Mention your experience with DB-related testing, ETL testing, and any specific tools or technologies you’ve used. Show enthusiasm for the position and how you can contribute to the team.
Showcase Relevant Skills: Highlight your skills in writing SQL queries, understanding complex business logic, and your experience with Agile Testing practices. Be specific about your testing experience with reporting and BI tools, as well as any test automation experience you have.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. 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 ETL Expertise
Make sure to highlight your experience with ETL testing and data warehousing. Be prepared to discuss specific projects where you implemented QA/testing lifecycles and how you tackled challenges in those roles.
✨Demonstrate SQL Skills
Since writing basic SQLs is crucial for this role, brush up on your SQL knowledge. Be ready to explain how you've used SQL to check data integrity, perform transformations, and handle complex business logic.
✨Familiarise Yourself with Agile Practices
Understanding Agile Testing practices is essential. Be prepared to discuss your experience with defect management and how you've participated in test management activities like assessment and strategy development.
✨Prepare for Technical Questions
Expect technical questions related to database objects, relational data models, and ETL requirements. Practise explaining these concepts clearly, as well as any relevant scripting or automation experience you have.
