Data-Driven QA Lead: SQL, ETL & API Testing

Luxoft; United States; Remoto; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

Luxoft is seeking an experienced Database Testing Lead in the United States to validate large data sets and ensure data integrity from AWS sources to downstream systems, including PNR creation on PID data. The role combines backend SQL validation with API testing as a secondary skill and requires strong automation experience.

You will lead data migration validation efforts, design comprehensive test strategies, write complex SQL queries, and develop automated scripts to reconcile source and

Competenze

• Must have strong experience in SQL-based backend validation.
• Expertise in writing complex SQL queries (joins, aggregations, subqueries) and PLSQL.
• Able to build automation using Java or Python with CI/CD integration.
• Experience in API testing is required.
• Experience in file-to-file data validation.
• Hands-on experience with volume testing / large data set validation.
• Experience in data reconciliation and backend testing.
• Ability to validate data pipelines and data transformations.
• Experience validating data flow between systems and databases.
• Strong understanding of data integrity, accuracy, and consistency checks.

Mansioni

• Data Migration & Transformation Validation across large datasets.
• Lead testing for large-scale data transformation and migration initiatives.
• Design and execute data validation strategies for migration accuracy.
• Develop complex SQL queries and automated validation scripts.
• Validate ETL/ELT processes, data mappings, and business logic.
• Perform end-to-end testing of batch, real-time, and incremental migrations.
• Identify and troubleshoot data quality issues and migration defects.
• Collaborate with data engineers and architects to define test strategies.
• Generate data quality metrics and migration readiness reports.
• Drive best practices in database testing and data quality engineering.
• AI Agent Onboarding & Test Automation: define onboarding approach for UA agents and establish automation-first testing for product workflows.
• Review architecture diagrams to align testing requirements with end-to-end agent workflows.
• Identify opportunities to apply AI-driven test automation to improve coverage and efficiency.
• Collaborate to embed DB automation & AI agent into the development lifecycle.
• Define test scenarios for AI-agent workflows across functional, integration, data, and end-to-end levels.

Conoscenze

SQL-based backend validation

Complex SQL queries (joins, aggreg</n>

PLSQL

Java / Python automation

API Testing

File-to-File data validation

Volume testing / large data sets

Data reconciliation and backend tests

Data pipelines and ETL validation

End-to-end data migration testing

AI-driven test automation (nice to)

Strumenti

Postman

Swagger

Descrizione del lavoro

Luxoft is seeking an experienced Database Testing Lead in the United States to validate large data sets and ensure data integrity from AWS sources to downstream systems, including PNR creation on PID data. The role combines backend SQL validation with API testing as a secondary skill and requires strong automation experience.

You will lead data migration validation efforts, design comprehensive test strategies, write complex SQL queries, and develop automated scripts to reconcile source and