Etl Qa

VeeRteq Solutions Inc.

Estado de México

On-site

MXN 420,000 - 640,000

Full time

29 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

VeeRteq Solutions Inc. is seeking a detail-oriented ETL Tester to ensure accuracy and reliability of enterprise data pipelines. You will design comprehensive data validation strategies across Informatica and Databricks environments to guarantee high-quality data for business reporting.

Key responsibilities include testing ETL jobs, validating MDM workflows, and performing SQL/Spark SQL queries to detect data anomalies. Collaborate with data engineers and analysts to drive defects to resolution.

Qualifications

  • Advanced SQL and data validation expertise for source-to-target checks.
  • Experience validating MDM hubs, match/merge rules and golden records.
  • ETL/ETL workflow testing across Informatica and Databricks environments.
  • Strong QA methodology, test planning, execution and defect tracking.

Responsibilities

  • Design and execute data validation strategies across Informatica and Databricks.
  • Validate end-to-end ETL jobs and data transformation rules.
  • Verify MDM workflows including cleansing, survivorship and distributions.
  • Write complex SQL and Spark SQL to detect anomalies and defects.
  • Maintain regression test data and report test execution metrics to stakeholders.

Skills

Advanced SQL
Data Validation
MDM Testing
ETL Testing
QA Methodology

Tools

Informatica
Databricks
PowerCenter/IICS

Job description

Data Warehouse Testing, Master Data Management (MDM) Validation, Big Data Verification, and Automated Data Testing (SQL, Informatica, Databricks).

Mandatory Skills
  • Advanced SQL & Data Validation: Expert-level SQL skills to write complex queries for source-to-target data validation, data completeness, transformation logic, and reconciliation.
  • Informatica Testing: Hands-on experience testing, validating, and troubleshooting ETL workflows, mappings, and sessions in Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
  • Databricks & Lakehouse Verification: Practical experience querying and validating large datasets in Databricks using Spark SQL, PySpark, and Delta Lake tables.
  • Master Data Management (MDM) Testing: Proven experience testing MDM hubs, validating match/merge rules, survivorship logic, golden record creation, and downstream data distribution.
  • QA Methodology & Defect Tracking: Strong understanding of SDLC/STLC, test plan creation, test case execution, and defect lifecycle management using tools like Jira, Zephyr, or Azure DevOps".
Desired Skills
  • Test Automation: Experience automating ETL and data validation tests using Python, PyTest, Great Expectations, or commercial data testing tools.
  • Cloud Data Platforms: Familiarity with cloud storage and data warehousing ecosystems such as Azure (ADLS, Synapse), AWS (S3, Redshift), or Snowflake.
  • CI/CD Integration: Experience integrating automated data regression suites into CI/CD pipelines (Azure DevOps, Jenkins, or GitHub Actions).
  • Communication & Alignment: Strong analytical and communication skills to collaborate effectively with data engineers, business analysts, and product stakeholders across distributed teams".
Job Description

We are looking for a detail-oriented ETL Tester to ensure the accuracy, integrity, and reliability of our enterprise data pipelines and Master Data Management (MDM) solutions. In this role, you will design and execute comprehensive data validation strategies across Informatica and Databricks environments to guarantee high-quality data for business reporting and analytics.

Key Responsibilities
  • Test Planning & Execution: Analyze business requirements, source-to-target mapping documents, and data models to design thorough test plans, test scenarios, and test cases.
  • ETL & Pipeline Validation: Execute end-to-end validation of batch and incremental ETL jobs built in Informatica and Databricks, verifying data extraction, transformation rules, and target loading.
  • MDM Quality Assurance: Validate MDM workflows, including data cleansing, standardization, match/merge thresholds, and golden record accuracy across source systems.
  • SQL & Root-Cause Analysis: Write complex SQL and Spark SQL queries to detect data anomalies, duplicates, truncation, and referential integrity issues, driving defects to resolution with data engineers.
  • Regression & Reporting: Maintain reusable test data sets, execute regression suites for pipeline releases, and provide clear test execution metrics and sign-off reports to stakeholders
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL QA Specialist: Data Integrity & MDM Validation
ETL QA Specialist: Data Integrity & MDM Validation

VeeRteq Solutions Inc. • Estado de México

On-site
MXN 420,000 - 640,000
ETL Tester Analyst
ETL Tester Analyst

Infosys Limited • Región Centro

On-site
MXN 360,000 - 720,000
Quality Assurance Engineer
Quality Assurance Engineer

KTek Resourcing • Ciudad de México

On-site
MXN 50,000 - 70,000
Data Quality Engineer / Data Access Management
Data Quality Engineer / Data Access Management

Coforge Limited • Mexico

On-site
MXN 650,000 - 900,000
ETL Test Lead
ETL Test Lead

Infosys Limited • Monterrey

On-site
MXN 900,000 - 1,300,000
MDM Team Member
MDM Team Member

Hussmann • Ciénega de Zimatlán

On-site
MXN 600,000 - 1,000,000
Data QA Engineer
Data QA Engineer

KTek Resourcing • Ciudad de México

On-site
MXN 152,334 - 182,466
MDM Team Member
MDM Team Member

Panasonic • Ciénega de Flores

On-site
MXN 600,000 - 1,000,000
MDM Team Member
MDM Team Member

Panasonic Corporation of North America • Ciénega de Flores

On-site
MXN 600,000 - 900,000
Quality Engineering Analyst - ETL & Data Validation Expert
Quality Engineering Analyst - ETL & Data Validation Expert

Infosys Limited • Región Centro

On-site
MXN 360,000 - 720,000