At Technatomy, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customer’s success. We provide solutions to agencies and entities including the Department of Veterans Affairs, Department of Defense, Defense Logistics Agency, National Institute of Health, and more. Everything we do is built on a commitment to do the right thing for our customers, our people, and our community. Our Mission, Vision, and Values guide the way we do business.
If this sounds like an environment where you can thrive, keep reading!
We are seeking an experienced Data Validation Test Engineer to verify the accuracy, completeness, lineage, reconciliation, and auditability of data exchanged or migrated into an enterprise Department of Veterans Affairs Pega solution. The role focuses on source-to-target validation, interface payloads, transformations, financial and acquisition data quality, migration results, and cross-system consistency rather than general application testing alone.
DUTIES AND RESPONSIBILITIES:
- Develop data-validation strategies, test plans, cases, queries, reconciliation rules, expected results, and traceability to source-to-target mappings and requirements.
- Validate data extraction, transformation, cleansing, normalization, migration, synchronization, and loading across source systems, integration services, staging, and Pega.
- Verify completeness, accuracy, uniqueness, consistency, timeliness, format, referential integrity, metadata, lineage, and authoritative-source alignment.
- Test interface requests and responses, API payloads, mappings, translations, business rules, error handling, retries, replay, and exception reporting.
- Reconcile legacy and current data across fiscal years, programs, appropriations, cost centers, spending items, approvals, acquisition records, and reporting outputs.
- Develop and execute SQL queries, data profiles, comparison routines, sampling methods, and automated validation checks where practical.
- Document discrepancies with clear evidence, severity, affected records, likely source, business impact, and retest results.
- Collaborate with data/integration engineers, business analysts, developers, SMEs, and functional testers to resolve data defects and clarify rules.
- Support test-data preparation, masking, generation, migration rehearsals, cutover validation, rollback checks, and post-deployment reconciliation.
- Maintain reusable validation assets, data-quality metrics, migration results, exception logs, and audit-ready evidence.
KNOWLEDGE AND SKILLS REQUIRED:
- 4+ years of experience in data testing, ETL testing, migration validation, integration testing, data quality, or comparable QA roles.
- Strong SQL skills and experience comparing, profiling, reconciling, and validating data across multiple sources or environments.