Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a dynamic team to ensure top-notch data quality and streamline testing processes.
- Company: Be part of a leading UK customer-centric business focused on data-driven decisions.
- Benefits: Enjoy 28 days holiday, PMI, a pension scheme, training, and performance bonuses.
- Why this job: Make an impact in a collaborative environment while enhancing your technical skills.
- Qualifications: Expertise in SQL, ETL testing, and data warehousing is essential; experience with Oracle and Postgres preferred.
- Other info: Hybrid work model: 3 days on-site in Bristol; must have British or EU passport.
The predicted salary is between 48000 - 52000 £ per year.
We are looking for an experienced and driven Datawarehouse QA Engineer to work for a UK leading customer centric business. As part of a centralised data function, you will work closely with Data Engineers in a multi-disciplinary team. You will need to understand complex data flows and both business and technical requirements to develop ETL/ELT reconciliation scenarios and ensure all features are fully tested.
The role primarily focuses on quality, supporting the team in sourcing, compiling, and developing reliable and consistent data reporting solutions that enable strategic, insight-driven decision-making. Additionally, you will explore opportunities to streamline or further enhance the team's existing SQL/ETL test automation processes where applicable. You will ensure that quality engineering principles are highlighted, discussed, and implemented from early design stages through to final production release. This will include reviewing acceptance criteria to determine relevant test scenarios; executing tests and collaborating with business users to ensure sign-off. You will also be responsible for the creation and maintenance of SQL based testing.
What you will bring:
- Expert level testing experience with Oracle and Postgres databases and Datawarehouses.
- Experience of ETL / MI data testing.
- Advanced / Expert level SQL skills to reconcile source/target data and to validate business rules / requirements.
- Proficient with using querying tools such as SQL Developer, Snowflake, PostgreSQL/DBeaver.
- Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports.
- Hands on and technical understanding of complex Data Warehousing, including Data Warehouse design; Star schema and dimensional modelling.
- Proficient with using OAS (or similar reporting tools) and validating subject areas and reports.
- Experience of working with and using ETL tools such as ODI.
- Understanding of data replication tools such as GoldenGate and DMS.
- Python scripting knowledge would be desirable.
- Experience of implementing CI/CD process would be an advantage.
- Experience of adding automation to Datawarehouse testing projects.
- You’ll be highly organised with the ability to own and manage testing activities and deliverables within allocated projects.
- You’ll be a team player.
- Have excellent communication and interpersonal skills, with the ability to build relationships with all levels across the business.
On top of the salary, you will receive a number of fantastic benefits which include: 28 days holiday, PMI, a non-contributory pension scheme, training and development and a discretionary performance related bonus.
Candidates must hold a British, EU Passport or Indefinite Leave to Remain. Unfortunately sponsorship cannot be offered for this role.
Please apply now for more information.
QA Engineer (Data Warehousing) employer: InterQuest Group
Contact Detail:
InterQuest Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land QA Engineer (Data Warehousing)
✨Tip Number 1
Familiarise yourself with the specific tools and technologies mentioned in the job description, such as Oracle, Postgres, and SQL Developer. Being able to discuss your hands-on experience with these tools during an interview will demonstrate your suitability for the role.
✨Tip Number 2
Prepare to showcase your understanding of data warehousing concepts, particularly Star schema and dimensional modelling. You might be asked to explain how you have applied these principles in past projects, so having concrete examples ready can set you apart.
✨Tip Number 3
Highlight any experience you have with automation in testing processes, especially related to ETL. Be ready to discuss specific instances where you've streamlined testing activities, as this aligns closely with the responsibilities of the role.
✨Tip Number 4
Since communication is key in this role, think about how you can demonstrate your interpersonal skills. Prepare examples of how you've successfully collaborated with cross-functional teams or business users to achieve project goals.
We think you need these skills to ace QA Engineer (Data Warehousing)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle and Postgres databases, as well as your advanced SQL skills. Emphasise any hands-on experience you have with ETL tools and data warehousing concepts like star schema and dimensional modelling.
Craft a Strong Cover Letter: In your cover letter, explain why you're passionate about quality assurance in data warehousing. Mention specific projects where you've implemented CI/CD processes or added automation to testing, showcasing your problem-solving skills.
Showcase Relevant Experience: When detailing your work history, focus on your roles that involved data reconciliation, testing, and collaboration with data engineers. Use metrics to demonstrate the impact of your contributions, such as improved testing efficiency or reduced errors.
Prepare for Technical Questions: Anticipate technical questions related to SQL, ETL processes, and data warehousing principles during the interview. Brush up on your knowledge of querying tools and be ready to discuss how you've used them in past projects.
How to prepare for a job interview at InterQuest Group
✨Showcase Your Technical Skills
Be prepared to discuss your experience with Oracle and Postgres databases in detail. Highlight specific projects where you successfully implemented ETL/MI data testing and how your advanced SQL skills helped reconcile source and target data.
✨Understand the Business Context
Demonstrate your understanding of the business requirements behind data flows. Be ready to explain how you would approach developing ETL/ELT reconciliation scenarios that align with strategic decision-making.
✨Emphasise Collaboration
Since the role involves working closely with Data Engineers and business users, share examples of how you've effectively collaborated in past projects. Highlight your communication skills and ability to build relationships across teams.
✨Discuss Automation and CI/CD Experience
If you have experience with automation in Data Warehouse testing or implementing CI/CD processes, make sure to bring this up. Discuss any tools you've used and the impact of these practices on project efficiency and quality.
