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. 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 practising complex queries that validate data transformations. You might be asked to solve a problem on the spot, so being well-prepared can showcase your expertise.
✨Tip Number 4
Research StudySmarter's approach to quality assurance and data engineering. Understanding our company culture and values will help you align your answers with what we look for in a candidate, making you a more appealing applicant.
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 executed SQL queries and validated data.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the QA Tester role and mention your hands-on experience with Azure services. Discuss how your skills align with the job requirements and why you're a great fit for the team.
Showcase Relevant Skills: When detailing your experience, emphasise your analytical skills and attention to detail. Mention any familiarity with tools like JIRA or Azure DevOps, as well as your understanding of Agile methodologies.
Highlight Certifications: If you have relevant certifications, such as Microsoft Certified: Azure Data Engineer Associate or Informatica Developer/QA, be sure to include them in your application. This can set you apart from other candidates.
How to prepare for a job interview at Mastek
✨Brush Up on ETL Testing
Make sure you have a solid understanding of ETL testing concepts, especially with Informatica. Be prepared to discuss your hands-on experience and any specific projects where you performed ETL testing.
✨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 during the interview, so practice beforehand.
✨Familiarise Yourself with Azure Tools
Get comfortable with Azure services like Azure Data Factory, Azure Blob Storage, and Azure SQL Database. Be prepared to discuss how you've used these tools in past projects and how they relate to data engineering.
✨Prepare for Agile Discussions
As the role involves collaboration in Agile ceremonies, be ready to talk about your experience working in Agile environments. Highlight your contributions to team meetings and how you maintain QA documentation.
