Data QA Engineer: ETL Validation & SQL Expert

Systems Limited; Lahore; On-site; PKR 1,000,000 - 1,500,000; Full time

Job summary

Systems Limited in Lahore is seeking a QA professional with 3–5+ years of experience in Data Analytics, Data QA, ETL/ELT, and BI reporting. The role is data-focused testing, requiring strong SQL, data validation, and investigation of data discrepancies.

You will independently translate business requirements into data test scenarios, write complex SQL queries, perform source-to-target validation, and collaborate with QA, Development, BA, and product teams.

Qualifications

• 3–5+ years of QA experience in Data Analytics, Data QA, ETL/ELT, Data Warehouse, BI, or data-focused testing.
• Strong hands-on SQL skills including joins, CTEs, subqueries, aggregations, and complex data validation queries.
• Experience with data reconciliation and source-to-target validation, data transformations, mappings, and data integrity.

Responsibilities

• Perform data validation and data quality testing across source and target systems.
• Validate ETL/ELT processes, data transformations, mappings, and business rules.
• Write and execute complex SQL queries for data validation, reconciliation, and analysis.
• Perform source-to-target validation and investigate data mismatches.
• Validate record counts, totals, calculations, duplicates, missing/null values, and overall data integrity.
• Test reports, dashboards, and analytics by validating the underlying data as well as the presentation layer.
• Collaborate with QA, Development, BA, Product, and business teams to resolve discrepancies.
• Communicate data-quality findings and root causes clearly to technical and non-technical stakeholders.
• Utilize AI tools within QA and Data Analytics activities to improve testing and productivity.

Skills

SQL

Data Validation

Data QA

ETL/ELT

Data Warehousing

BI Reporting

Analytical Thinking

Communication

Tools

Power BI

Tableau

Snowflake

Databricks

Azure Data Factory

Postman

Playwright

Job description

Systems Limited in Lahore is seeking a QA professional with 3–5+ years of experience in Data Analytics, Data QA, ETL/ELT, and BI reporting. The role is data-focused testing, requiring strong SQL, data validation, and investigation of data discrepancies.

You will independently translate business requirements into data test scenarios, write complex SQL queries, perform source-to-target validation, and collaborate with QA, Development, BA, and product teams.