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 experience with Oracle/Postgres databases required.
- Other info: Hybrid work model with 3 days on-site in Edinburgh; must hold valid UK/EU passport.
The predicted salary is between 44000 - 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 (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 from other candidates.
✨Tip Number 2
Network with current or former employees of the company on platforms like LinkedIn. Engaging in conversations about their experiences can provide you with valuable insights into the company culture and expectations, which you can leverage during interviews.
✨Tip Number 3
Prepare to discuss your experience with ETL processes and data reconciliation in detail. Be ready to share specific examples of how you've improved testing processes or automated tasks in previous roles, as this aligns closely with the responsibilities outlined in the job description.
✨Tip Number 4
Showcase your communication skills by preparing questions for the interview that demonstrate your understanding of both technical and business aspects of the role. This will highlight your ability to collaborate effectively with cross-functional teams, a key requirement for the position.
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 advanced SQL skills. Include specific examples of your work with ETL processes and data warehousing to demonstrate your expertise.
Craft a Strong Cover Letter: In your cover letter, express your passion for quality assurance in data warehousing. Mention how your skills align with the job requirements, particularly your experience with SQL/ETL test automation and CI/CD processes.
Showcase Relevant Projects: If you have worked on projects involving data reconciliation or automated testing, be sure to include these in your application. Detail your role and the impact of your contributions to highlight your hands-on experience.
Highlight Soft Skills: Since the role requires excellent communication and interpersonal skills, mention instances where you've successfully collaborated with teams or built relationships across different levels of an organisation.
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/ELT processes and how you used SQL to reconcile data. This will demonstrate your expertise and understanding of the technical requirements for the role.
✨Understand the Business Context
Make sure you grasp the business implications of the data you will be working with. Be ready to explain how your testing ensures that data reporting solutions support strategic decision-making. This shows that you can connect technical work with business outcomes, which is crucial for a QA Engineer.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to describe how you would handle specific testing scenarios or challenges. Think about past experiences where you had to troubleshoot issues or improve testing processes, especially in relation to data warehousing and automation.
✨Demonstrate Team Collaboration Skills
Since the role involves working closely with Data Engineers and other team members, be ready to discuss how you have effectively collaborated in previous roles. Share examples of how you communicated with stakeholders to ensure quality and accuracy in testing, as this will highlight your interpersonal skills.
