Data Quality Engineer: Redshift & Lake Validation

HCL Technologies Limited; Seattle (WA); On-site; USD 69,000 - 128,000; Full time

Job summary

HCLTech is seeking a highly talented Data Analyst & Validation Engineer (ETL QA Focused) to join full-time in the US. The role emphasizes data validation, AWS data services, Python scripting, and QA methodologies to ensure data quality across pipelines.

Responsibilities include validating transformations, reconciliations, data integrity, and building automated validation suites, with governance and testing strategy to prevent production issues.

Qualifications

• 6-10 years combined experience in data engineering, data QA, or analytics engineering.
• Owned data quality for at least one production system end-to-end.
• Defined acceptance criteria and quality gates blocking defective releases.
• Built automated validation suites catching production issues.
• Comfortable reading and reasoning about pipeline code.

Responsibilities

• Validate transformation logic against business rules and specifications.
• Perform source-to-target data reconciliation for completeness, accuracy, and consistency.
• Identify data anomalies, silent failures, and drift in pipeline outputs.
• Build and maintain automated data validation suites in pipelines.
• Conduct periodic data audits beyond automated checks.

Skills

Data Validation

AWS Data Services

Python

ETL/ELT Concepts

QA Methodology

Test Planning

Defect Lifecycle

Tools

AWS Redshift

AWS Lake Formation

Athena

S3 Data Lakes

Job description

HCLTech is seeking a highly talented Data Analyst & Validation Engineer (ETL QA Focused) to join full-time in the US. The role emphasizes data validation, AWS data services, Python scripting, and QA methodologies to ensure data quality across pipelines.

Responsibilities include validating transformations, reconciliations, data integrity, and building automated validation suites, with governance and testing strategy to prevent production issues.