Engineer the Quantum RevolutionYour expertise can help us shape the future of quantum computing at Oxford Ionics.

View Open Roles

QA Tester – ETL Testing (Informatica) & Azure Data Engineering

Mastek
City of London
1 month ago
Applications closed

Related Jobs

View all jobs

Risk Quantitative Analytics

Risk Quantitative Analytics

Risk Quantitative Analytics

Finance Data Analyst - Fareham

Finance Data Analyst - Fareham

Finance Data Analyst - Fareham

Job Title: QA Tester – ETL Testing (Informatica) & Azure Data Engineering

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 inETL testing (Informaticaor Microsoft Fabric) and a strong understanding ofAzure Data Engineering toolssuch asAzure SQL Database,Azure Blob Storage, andAzure Data Factory. The ideal candidate will possessgood hands-on knowledge of writing and executing SQL queriesto validate data across systems. Experience inMicrosoft Fabricis considered a strong bonus.


Key Responsibilities:

  • PerformETL/data pipeline testingusingInformatica PowerCenterorIICS.
  • Validatedata ingestion,transformation, andloading processesacross Azure services.
  • Executesource-to-target data validation, data profiling, and data reconciliation.
  • Write and execute complex SQL queriesto validate data transformations, aggregations, and business rules inAzure SQL Databaseand other relational platforms.
  • Test data flows and integrations involving:
  • Azure Data Factory (ADF)
  • Azure Blob Storage
  • Azure SQL Database
  • Analyze data mapping specifications and support data quality and audit initiatives.
  • Log, track, and retest defects using tools likeJIRAorAzure 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 yearsof software testing experience, with at least2+ years in ETL testing using Informatica.
  • Strong hands-on experience inwriting and executing complex SQL queries.
  • Experience testing cloud-based data pipelines built onAzure, specifically:
  • Azure SQL Database
  • Azure Blob Storage
  • Azure Data Factory
  • Familiarity withdata warehouse testing,data transformation logic, anddata quality standards.
  • Exposure totest planning,test case design, anddefect management.
  • Strong analytical skills and attention to detail.


Preferred / Bonus Skills:

  • Experience withMicrosoft Fabric(OneLake, DirectLake, Data Warehouse, Data Activator) is a significant plus.
  • Knowledge ofAzure Synapse Analytics,Databricks, orPower BI.
  • Experience withautomated data validationor scripting (e.g., Python, PowerShell).
  • Familiarity withCI/CD processesin data environments.
  • Relevant certifications (e.g.,Microsoft Certified: Azure Data Engineer Associate,Informatica Developer/QA) are advantageous.

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Pre-Employment Checks for Data Science Jobs: DBS, References & Right-to-Work and more Explained

Pre-employment screening in data science reflects the discipline's unique position at the intersection of statistical analysis, machine learning innovation, and strategic business intelligence. Data scientists often have privileged access to comprehensive datasets, proprietary algorithms, and business-critical insights that form the foundation of organisational strategy and competitive positioning. The data science industry operates within complex regulatory frameworks spanning GDPR, sector-specific data protection requirements, and emerging AI governance regulations. Data scientists must demonstrate not only technical competence in statistical modelling and machine learning but also deep understanding of research ethics, data privacy principles, and the societal implications of algorithmic decision-making. Modern data science roles frequently involve analysing personally identifiable information, financial data, healthcare records, and sensitive business intelligence across multiple jurisdictions and regulatory frameworks simultaneously. The combination of analytical privilege, predictive capabilities, and strategic influence makes thorough candidate verification essential for maintaining compliance, security, and public trust in data-driven insights and automated systems.

Why Now Is the Perfect Time to Launch Your Career in Data Science: The UK's Analytics Revolution

The United Kingdom stands at the forefront of a data science revolution that's reshaping how businesses make decisions, governments craft policies, and society tackles its greatest challenges. From the machine learning algorithms powering London's fintech innovation to the predictive models guiding Manchester's smart city initiatives, Britain's transformation into a data-driven economy has created an unprecedented demand for skilled data scientists that far outstrips the available talent. If you've been contemplating a career transition or seeking to position yourself at the cutting edge of the digital economy, data science represents one of the most intellectually stimulating, financially rewarding, and socially impactful career paths available today. The convergence of big data maturation, artificial intelligence mainstream adoption, business intelligence evolution, and cross-industry digital transformation has created the perfect conditions for data science career success.

Automate Your Data Science Jobs Search: Using ChatGPT, RSS & Alerts to Save Hours Each Week

Data science roles land daily across banks, product companies, consultancies, scaleups & the public sector—often buried in ATS portals or duplicated across boards. The fix: put discovery on rails with keyword-rich alerts, RSS feeds & a reusable ChatGPT workflow that triages listings, ranks fit, & tailors your CV in minutes. This copy-paste playbook is for www.datascience-jobs.co.uk readers. It’s UK-centric, practical, & designed to save you hours each week. What You’ll Have Working In 30 Minutes A role & keyword map spanning Core DS, Applied/Research, Product/Decision Science, NLP/CV, Causal/Experimentation, Time Series/Forecasting, MLOps-adjacent & Analytics Engineering overlaps. Shareable Boolean searches for Google & job boards that strip out noise. Always-on alerts & RSS feeds that bring fresh UK roles to you. A ChatGPT “Data Science Job Scout” prompt that deduplicates, scores match & outputs ready-to-paste actions. A simple pipeline tracker so deadlines & follow-ups never slip.