Senior/Lead DB Tester (SQL / API / Volume Testing)

Project description

We are looking for an experienced Database Testing Lead with strong expertise in SQL-based backend validation. The candidate will be responsible for validating large data sets, performing file-to-file reconciliation, volume testing, and ensuring accurate data validation from AWS sources to downstream systems (including PNR creation from PID data). API testing experience is required as a secondary skill.

Responsibilities

• Lead testing efforts for large-scale data transformation and migration initiatives involving millions of records across enterprise Network Operation platforms.
• Design and execute comprehensive data validation strategies to ensure data accuracy, completeness, consistency, and integrity during migrations.
• Develop complex SQL queries and automated validation scripts to reconcile source and target systems at scale.
• Validate ETL/ELT processes, transformation rules, data mappings, and business logic across multiple data domains.
• Perform end-to-end testing of batch, real-time, and incremental data migration workflows.
• Identify, analyze, and troubleshoot data quality issues, migration defects, duplicates, missing records, and transformation anomalies.
• Collaborate closely with data engineers, architects, business analysts, and application teams to define test strategies and acceptance criteria.
• Generate detailed data quality metrics, reconciliation reports, and migration readiness assessments for stakeholders.
• Drive best practices in database testing, automation, and data quality engineering to ensure successful delivery of enterprise migration programs
• Coordinate with development, data engineering, and QA teams
• Review test cases, test strategies, and defect tracking

SKILLS

Must have

• · Strong experience in Database Testing using SQL

· Experience in AI-driven test automation

· Expertise in writing complex SQL queries (joins, aggregations, subqueries)

· 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

Technical Skills

· SQL (Mandatory)

· Database platforms such as Oracle, SQL Server, PostgreSQL, or MySQL

· AWS data validation

· Experience working with large data volumes

· Knowledge of data migration and ETL validation

Nice to have

• API Testing using tools such as Postman, Swagger, or similar tools
• Understanding of REST APIs and HTTP methods (GET, POST, PUT, DELETE)
• Ability to validate API responses with database data
• Knowledge of JSON/XML validation