Short JD / Mandatory skills: particularly the hands-on Data Warehouse/ETL testing, advanced SQL, Snowflake, and relevant Python-based data automation experience expected for this role
----
Detailed JD:
We are looking for a highly skilled
Automation Test Lead
with strong hands-on experience in
Data Warehouse, ETL/ELT and Data Platform testing
. The candidate should have proven expertise in
Python-based test automation framework development
, advanced SQL and data validation, along with experience leading testing initiatives and guiding technical solutions.
The adecuado candidate should be able to
design, build, enhance and maintain scalable automation frameworks
for complex data-testing requirements and work closely with Data Engineers, Architects and other technical teams.
Key Responsibilities
1. Data & ETL Testing
Lead end-to-end testing of
Data Warehouse, ETL/ELT and data integration pipelines
.
Validate data flow across source, staging, transformation and target layers.
Design and execute
source-to-target validation, data reconciliation and transformation testing
.




Validate full, incremental and delta data loads.
Perform testing of
large-volume datasets
and complex data scenarios.
Identify data integrity, completeness, duplication and transformation issues.
2. Test Automation Framework Development
Design, develop and maintain
Python-based test automation frameworks and reusable libraries
for data validation.
Enhance existing automation frameworks to support evolving business and technical requirements.
Develop reusable utilities for data comparison, reconciliation, validation and reporting.
Apply automation framework best practices, including modularity, maintainability, scalability and exception handling.
Evaluate opportunities to improve automation coverage and reduce manual validation effort.
3. Advanced SQL & Data Validation
Develop complex SQL queries for data validation and reconciliation.
Perform validation using complex joins, CTEs, subqueries, aggregations

📌 Quality Assurance Automation Engineer (Zaragoza)
🏢 Virtusa
📍 Zaragoza