Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a QA Tester to ensure data quality through ETL testing and Azure Data Engineering.
- Company: Be part of a dynamic team in Westminster, London, focused on innovative data solutions.
- Benefits: Enjoy a full-time role with opportunities for growth and collaboration in an Agile environment.
- Why this job: Make an impact by validating data processes and enhancing data quality in exciting cloud projects.
- Qualifications: 3-7 years in software testing, with 2+ years in ETL testing and strong SQL skills required.
- Other info: Experience with Microsoft Fabric and relevant certifications are a plus!
The predicted salary is between 36000 - 60000 £ per year.
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
- Azure SQL Database
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
- Azure Data Factory
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, especially Informatica and Azure services. Consider setting up a small project or lab environment to practice ETL testing and data validation using these technologies.
✨Tip Number 2
Join online forums or communities focused on Azure Data Engineering and ETL testing. Engaging with professionals in these spaces can provide insights into current trends and best practices, which can be beneficial during interviews.
✨Tip Number 3
Prepare for technical interviews by brushing up on your SQL skills. Practice writing complex queries that validate data transformations, as this is a key requirement for the role. You might even want to simulate real-world scenarios to showcase your problem-solving abilities.
✨Tip Number 4
Network with current employees at StudySmarter or similar companies. Reach out on LinkedIn to learn more about their experiences and gather tips on what the company values in a QA Tester. This can give you an edge in understanding the company culture and expectations.
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. Use specific examples of projects where you've executed SQL queries and validated data.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your hands-on experience with Azure services and how it aligns with the job requirements. Be sure to include any relevant certifications you hold.
Showcase Relevant Skills: When filling out your application, emphasise your analytical skills and attention to detail. Provide examples of how you've contributed to QA documentation and collaborated with teams in Agile environments.
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 a QA Tester role.
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 services like Azure Data Factory, Azure Blob Storage, and Azure SQL Database. Understanding how these tools interact will help you answer questions more effectively and show your expertise.
✨Prepare for Agile Methodologies
As the role involves collaboration in Agile ceremonies, be prepared to discuss your experience working in Agile environments. Highlight your contributions to team dynamics and how you handle feedback and iterations.
