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 opportunities, and performance bonuses.
- Why this job: Make an impact in a collaborative environment while enhancing your technical skills in data warehousing.
- Qualifications: Expertise in SQL, ETL testing, and data warehousing principles required; Python knowledge is a plus.
- Other info: Hybrid work model with 3 days on-site in Edinburgh; British or EU passport needed.
The predicted salary is between 44000 - 52000 £ per year.
Edinburgh – Hybrid – 3 days pw on site £55,000 to £65,000
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 (Datawarehousing) employer: InterQuest Group
Contact Detail:
InterQuest Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land QA Engineer (Datawarehousing)
✨Tip Number 1
Familiarise yourself with the specific tools and technologies mentioned in the job description, such as Oracle, Postgres, and SQL Developer. Having hands-on experience or even personal projects showcasing your skills with these tools can set you apart during discussions.
✨Tip Number 2
Brush up on your knowledge of ETL processes and data warehousing concepts, especially around Star schema and dimensional modelling. Being able to discuss these topics confidently will demonstrate your expertise and understanding of the role.
✨Tip Number 3
Prepare to discuss your experience with automation in testing, particularly in relation to Datawarehouse projects. Highlight any specific examples where you've successfully implemented CI/CD processes or added automation to improve efficiency.
✨Tip Number 4
Showcase your communication and interpersonal skills by preparing examples of how you've built relationships within teams or across departments. This is crucial for a role that requires collaboration with Data Engineers and business users.
We think you need these skills to ace QA Engineer (Datawarehousing)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle and Postgres databases, as well as your expertise in ETL/MI data testing. Use specific examples to demonstrate your advanced SQL skills and any relevant projects you've worked on.
Craft a Strong Cover Letter: In your cover letter, express your passion for quality engineering and how your background aligns with the role. Mention your experience with data warehousing design and your ability to collaborate with multi-disciplinary teams.
Showcase Relevant Skills: Clearly outline your hands-on experience with SQL Developer, Snowflake, and other querying tools. Highlight any automation you've added to Datawarehouse testing projects and your understanding of CI/CD processes.
Prepare for Technical Questions: Be ready to discuss your technical knowledge during interviews. Prepare to explain complex data flows, your approach to testing, and how you ensure quality from design to production release.
How to prepare for a job interview at InterQuest Group
✨Showcase Your SQL Skills
Be prepared to demonstrate your advanced SQL skills during the interview. You might be asked to solve problems or write queries on the spot, so brush up on your knowledge of Oracle and Postgres databases, as well as any querying tools like SQL Developer or DBeaver.
✨Understand Data Warehousing Concepts
Make sure you have a solid grasp of data warehousing principles, including star schema and dimensional modelling. Be ready to discuss how these concepts apply to your previous work and how they can enhance the team's existing processes.
✨Prepare for ETL Testing Scenarios
Since the role focuses on ETL/MI data testing, think about specific scenarios you've encountered in the past. Be ready to explain how you approached testing, what challenges you faced, and how you ensured data accuracy and reliability.
✨Demonstrate Team Collaboration
Highlight your experience working in multi-disciplinary teams. Share examples of how you've collaborated with data engineers and business users to ensure quality and sign-off on projects, showcasing your excellent communication and interpersonal skills.
