Data Validation Engineer

KPI Partners; Hyderabad, Pune District, Bengaluru; Hybrid; INR 800,000 - 1,100,000; Full time

Job summary

KPI Partners in Hyderabad is seeking a QA/Data Validation Engineer to own testing and validation for a multi-stage data-processing pipeline. You will ensure transformed and consolidated outputs are accurate, complete, and production-ready.

You will write unit tests, perform reconciliation testing against source totals, build CI/CD-integrated test suites, and design edge-case test cases. You will also triage defects and maintain test documentation throughout the lifecycle.

Qualifications

• Strong SQL with complex joins and set comparisons for data validation and reconciliation.
• Experience testing ETL/ELT pipelines and cloud data warehouses (e.g., Snowflake).
• Test automation experience—building repeatable, CI-integrated test suites (pytest, dbt tests).
• Experience with defect-tracking and test-management tools (Jira, TestRail).
• Solid understanding of data-quality dimensions: completeness, accuracy, timeliness.

Responsibilities

• Write and execute unit tests for data-transformation components.
• Perform reconciliation testing against source-system totals using row counts and checksums.
• Build and maintain automated test suites integrated into the CI/CD pipeline.
• Design test cases covering edge conditions: nulls, duplicates, malformed records, schema drift.
• Triaging defects, isolating root causes, and verifying fixes in production.
• Maintain test documentation and traceability from requirements to test coverage.

Skills

SQL proficiency

ETL testing

Test automation

Jira/TestRail

Data quality

Job description

"Description: QA/Data Validation Engineer"

Owns testing and validation for a multi-stage data-processing pipeline, ensuring transformed and consolidated outputs are accurate, complete, and production-ready.

What you'll do:

• Write and execute unit tests for individual data-transformation and consolidation components
• Perform reconciliation testing validating processed/aggregated outputs against source-system totals using row counts, checksums, business-rule assertions, and etc.
• Build and maintain automated test suites integrated into the CI/CD pipeline
• Design test cases covering edge conditions: nulls, duplicate keys, malformed records, and schema drift
• Support production hardening by triaging defects, isolating root cause, and verifying fixes
• Maintain test documentation and traceability from requirements to test coverage

Mandatory Skills:

• Strong SQL — complex joins, aggregations, and set comparisons for data-validation and reconciliation logic
• Experience testing ETL/ELT pipelines and cloud data warehouses (e.g., Snowflake)
• Test automation experience — building repeatable, CI-integrated test suites (e.g., pytest, dbt tests)
• Experience with defect-tracking and test-management tools (e.g., Jira, TestRail)
• Solid understanding of data-quality dimensions: completeness, accuracy, consistency, timeliness