remote
Senior QA Engineer - Database & Data Quality Testing - Aigen Technologies
QA Engineer
Lead end‑to‑end database and data quality testing, crafting complex SQL queries, validating ETL/ELT workflows, and ensuring data integrity across systems.
About the role
Key Responsibilities
- Design and execute comprehensive database tests, including complex SQL queries with joins, aggregations, window functions, CTEs, and temporary tables.
- Validate stored procedures, triggers, and business transformation logic to ensure accurate data processing.
- Develop and maintain reconciliation queries and repeatable SQL validation scripts for ongoing data quality assurance.
- Test batch processing, ETL/ELT workflows, and synchronization jobs, covering incremental loads, delta processing, and reprocessing scenarios.
- Ensure data consistency and integrity across source and target systems, identifying and documenting defects.
Requirements
- Extensive experience with SQL and relational database testing.
- Proficiency in ETL/ELT tools and batch processing validation.
- Strong analytical skills and attention to detail in data quality assessment.
- Excellent communication skills for defect reporting and cross‑team collaboration.