Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a QA Tester to validate data processes and ensure quality in ETL testing.
- Company: We are a dynamic tech company based in Westminster, London, focused on data engineering excellence.
- Benefits: Enjoy a full-time role with opportunities for growth, collaboration, and a vibrant work culture.
- Why this job: Be part of an innovative team, enhance your skills, and make a real impact in data quality.
- Qualifications: 3-7 years of software testing experience, especially in ETL testing with Informatica and SQL proficiency.
- Other info: Experience with Microsoft Fabric and cloud-based data pipelines is a bonus!
The predicted salary is between 36000 - 60000 £ per year.
Location: Westminster, London
Type: Full-time
Department: Quality Assurance / Data Engineering
Reporting to: Data Engineering Lead
Job Summary: We are looking for a skilled and detail-oriented QA Tester with hands-on experience in ETL testing (Informatica or Microsoft Fabric) and a strong understanding of Azure Data Engineering tools such as Azure SQL Database, Azure Blob Storage, and Azure Data Factory. The ideal candidate will possess good hands-on knowledge of writing and executing SQL queries to validate data across systems. Experience in Microsoft Fabric is considered a strong bonus.
Key Responsibilities:
- Perform ETL/data pipeline testing using Informatica PowerCenter or IICS.
- Validate data ingestion, transformation, and loading processes across Azure services.
- Execute source-to-target data validation, data profiling, and data reconciliation.
- Write and execute complex SQL queries to validate data transformations, aggregations, and business rules in Azure SQL Database and other relational platforms.
- Test data flows and integrations involving Azure Data Factory (ADF), Azure Blob Storage, and Azure SQL Database.
- Analyze data mapping specifications and support data quality and audit initiatives.
- Log, track, and retest defects using tools like JIRA or Azure DevOps.
- Collaborate closely with developers, data engineers, and business analysts.
- Contribute to daily Agile ceremonies and maintain clear and detailed QA documentation.
Required Skills & Experience:
- 3–7 years of software testing experience, with at least 2+ years in ETL testing using Informatica.
- Strong hands-on experience in writing and executing complex SQL queries.
- Experience testing cloud-based data pipelines built on Azure, specifically Azure SQL Database, Azure Blob Storage, and Azure Data Factory.
- Familiarity with data warehouse testing, data transformation logic, and data quality standards.
- Exposure to test planning, test case design, and defect management.
- Strong analytical skills and attention to detail.
Preferred / Bonus Skills:
- Experience with Microsoft Fabric (OneLake, DirectLake, Data Warehouse, Data Activator) is a significant plus.
- Knowledge of Azure Synapse Analytics, Databricks, or Power BI.
- Experience with automated data validation or scripting (e.g., Python, PowerShell).
- Familiarity with CI/CD processes in data environments.
- Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate, Informatica Developer/QA) are advantageous.
QA Tester – ETL Testing (Informatica) & Azure Data Engineering employer: Mastek
Contact Detail:
Mastek Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land QA Tester – ETL Testing (Informatica) & Azure Data Engineering
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Informatica and Azure Data Factory. Having hands-on experience or even completing relevant online courses can give you a significant edge during interviews.
✨Tip Number 2
Join online forums or communities focused on ETL testing and Azure Data Engineering. Engaging with professionals in these spaces can provide insights into industry trends and best practices, which you can discuss during your interview.
✨Tip Number 3
Prepare to demonstrate your SQL skills by practicing complex queries that validate data transformations. You might be asked to solve a problem on the spot, so being well-prepared can help you stand out.
✨Tip Number 4
Research StudySmarter's approach to quality assurance and data engineering. Understanding our company culture and values will allow you to tailor your responses in interviews, showing that you're not just a fit for the role but also for our team.
We think you need these skills to ace QA Tester – ETL Testing (Informatica) & Azure Data Engineering
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in ETL testing, particularly with Informatica and Azure Data Engineering tools. Include specific examples of projects where you've written and executed SQL queries.
Craft a Strong Cover Letter: In your cover letter, emphasise your hands-on experience with Azure services like Azure SQL Database and Azure Data Factory. Mention any familiarity with Microsoft Fabric and how it relates to the role.
Showcase Relevant Skills: Clearly list your skills related to data validation, defect management, and Agile methodologies. Use bullet points for clarity and ensure you mention any relevant certifications.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects attention to detail, which is crucial for a QA Tester.
How to prepare for a job interview at Mastek
✨Brush Up on ETL Testing Concepts
Make sure you have a solid understanding of ETL testing principles, especially with Informatica. Be prepared to discuss your hands-on experience and any challenges you've faced in previous roles.
✨Showcase Your SQL Skills
Since writing and executing complex SQL queries is crucial for this role, be ready to demonstrate your SQL knowledge. You might be asked to solve a problem or write a query on the spot, so practice beforehand!
✨Familiarise Yourself with Azure Tools
Get comfortable with Azure Data Factory, Azure SQL Database, and Azure Blob Storage. Understanding how these tools interact will help you answer questions more effectively and show your expertise in cloud-based data pipelines.
✨Prepare for Agile Methodologies
As the role involves collaboration in Agile ceremonies, be ready to discuss your experience working in Agile environments. Highlight your contributions to team dynamics and how you handle feedback and iterations.
