QA ETL Testing

QA ETL Testing

We are looking for an experienced ETL Tester / Data Quality Test Engineer to validate data extraction, transformation, and loading processes and ensure the accuracy, completeness, consistency, and reliability of data across enterprise data platforms.

The ideal candidate will have strong SQL skills, hands-on experience testing ETL/ELT pipelines, and a solid understanding of data warehousing, data integration, and data validation. You will work closely with data engineers, business analysts, and QA teams to identify data issues, validate business rules, and ensure high-quality data delivery for reporting and analytics.

Key Responsibilities

• Design, develop, and execute test plans, test cases, and test scenarios for ETL/ELT pipelines and data integration workflows.
• Validate data extraction, transformation, and loading processes across source systems, staging environments, data warehouses, and target systems.
• Perform source-to-target data validation to ensure data accuracy, completeness, consistency, and integrity.
• Write complex SQL queries to verify data transformations, perform reconciliations, and identify data discrepancies.
• Test data mapping documents, transformation logic, business rules, aggregations, calculations, and derived fields.
• Validate data quality across large datasets, including duplicate records, missing values, incorrect formats, null values, and referential integrity issues.
• Test incremental loads, full loads, historical data loads, and change data capture (CDC) processes where applicable.
• Perform backend testing for data warehouses, data marts, and analytical reporting solutions.
• Validate data used in BI reports and dashboards to ensure that reported metrics align with underlying source and business requirements.
• Collaborate with data engineers and developers to investigate defects, identify root causes, and verify fixes.
• Create and maintain test data, test scripts, test evidence, defect reports, and test execution documentation.
• Support regression, integration, system, and user acceptance testing as required.
• Contribute to improving data testing processes, reusable validation scripts, and test automation.

Required Qualifications

• 5+ years of experience in ETL testing, data warehouse testing, data validation, or database testing.
• Strong proficiency in SQL, including complex joins, subqueries, CTEs, aggregations, window functions, and data reconciliation queries.
• Hands-on experience testing ETL/ELT pipelines and validating source-to-target data flows.
• Strong understanding of data warehousing concepts, dimensional modeling, fact and dimension tables, and star/snowflake schemas.
• Experience validating data transformations, business rules, data mappings, and data integration logic.
• Familiarity with relational databases such as SQL Server, Oracle, or similar platforms.
• Experience identifying, documenting, tracking, and retesting data-related defects.
• Strong analytical and problem-solving skills, with attention to detail and the ability to investigate complex data issues.
• Ability to work collaboratively with data engineering, QA, analytics, and business teams.

Technical Skills

Candidates should have experience with several of the following technologies:

• SQL and databases: Advanced SQL, SQL Server, Oracle, or comparable relational databases.
• ETL/ELT tools: SSIS, Informatica, Talend, Azure Data Factory, AWS Glue, or similar data integration tools.
• Data platforms: Snowflake, Azure Synapse, Amazon Redshift, or other data warehouse platforms.
• BI and reporting: Power BI, Tableau, or similar reporting tools for validating data and business metrics.
• Test automation: Selenium or Playwright or automated data validation frameworks.
• Test and defect management: Jira, Azure DevOps, or similar tools.

Nice to Have

• Experience testing cloud-based data platforms and modern data pipelines.
• Familiarity with data quality frameworks, automated reconciliation, and anomaly detection.
• Experience validating APIs or data feeds that integrate with ETL workflows.
• Knowledge of CI/CD practices and automated testing within data engineering environments.
• Experience testing large-scale datasets and distributed processing systems.
• Familiarity with Agile/Scrum methodologies and standard QA processes.
• Experience in banking, financial services, payments, or other data-intensive industries.

WHY JOIN US

Matrix is a global, dynamic, and fast‑growing technology services and consulting company with over 17,000 employees worldwide. Founded in 2001, Matrix has grown through significant organic expansion and strategic acquisitions, executing some of the largest and most impactful technology projects in the market.

We specialize in the design, development, and implementation of advanced technologies, software solutions, and digital products. Our services include infrastructure and consulting, IT outsourcing and offshore delivery, training and assimilation programs, and acting as a trusted implementation and delivery partner for the world’s leading software vendors.

With deep expertise across both the private and public sectors—spanning Finance, Telecom, Healthcare, Hi‑Tech, Education, Defense, and Security—Matrix serves a strong customer base in Israel alongside a continuously expanding global client portfolio.

At Matrix, our people are at the heart of our success. We are a community of talented, creative, and dedicated professionals who are passionate about innovation and excellence. We actively attract, develop, and retain top talent, recognizing that every employee’s contribution is critical to our continued growth and future success.

Matrix’s success is built on a challenging and engaging work environment, competitive compensation and benefits, and meaningful career development opportunities. We foster a diverse, inclusive culture that encourages collaboration, continuous learning, and growth—together.

Join the winning team. Be challenged, grow your career, and enjoy the journey in a highly respected global organization.

To learn more, visit: www.matrix-ifs.com

EQUAL OPPORTUNITY EMPLOYER: Matrix is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind. Matrix is committed to the principle of equal employment opportunity for all employees, providing employees with a work environment free of discrimination and harassment. All employment decisions at Matrix are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, family or parental status, or any other status protected by the laws or regulations in our locations. Matrix will not tolerate discrimination or harassment based on any of these characteristics. Matrix encourages applicants of all ages.



no need to work Rao