30 Jul
|
Acuity Analytics
|
Pune
30 Jul
Acuity Analytics
Pune
Job Purpose
Looking for a Data QA Engineer to lead data validation and regression testing across capital-markets data pipelines spanning legacy and modern platforms. The role will focus on ensuring data accuracy, completeness, consistency, integrity, and adherence to business rules through source-to-target validation, schema checks, reconciliation, lineage review, and automation-led regression testing.
The candidate will build reusable Python/SQL-based validation frameworks, support batch and cloud execution, validate post-trade data flows, identify data anomalies, and partner with engineering and business teams to embed strong data-quality controls. The ideal candidate combines data QA expertise, capital-markets domain understanding, automation-first thinking, and strong ownership of data quality across environments.
Key Responsibilities
Perform source-to-target data validation across legacy and contemporary systems, including SQL Server and cloud-based data environments.
Validate data accuracy, completeness, consistency, timeliness, duplication handling, referential integrity,
schema structures, metadata, lineage, and business-rule conformance.
Build and maintain automation-first regression testing frameworks using Python, PySpark, SQL, and validation utilities.
Execute field-level, dataset-level, transformation-level, and aggregate-level data checks across source, staging warehouse, data lake, and downstream systems.
Validate ETL/ELT pipelines, post-trade data flows, stored procedures, batch jobs, and cloud-based execution workflows.
Integrate regression tests, data validation checks, SQL deployables, and quality gates into CI/CD pipelines using DevOps, Jenkins, GitLab, or equivalent tools.
Design reusable test cases, validation scenarios, reconciliation checks, automated scripts, and regression packs for repeatable data-quality assurance.
Write, optimize, and troubleshoot complex SQL queries and stored procedures across SQL Server, Oracle, PostgreSQL, or similar p
📌 Data QA Engineer (Pune)
🏢 Acuity Analytics
📍 Pune