Sr. DB Tester (SQL / API / Volume Testing)

Key Responsibilities:

• Lead testing efforts for large-scale data transformation and migration initiatives involving millions of records.
• Design and execute comprehensive data validation strategies to ensure accuracy, completeness, consistency, and data integrity.
• Write complex SQL queries and validation scripts for source-to-target reconciliation.
• Perform file-to-file validation and large-volume data testing.
• Validate ETL/ELT processes, transformation rules, data mappings, and business logic.
• Perform end-to-end testing of batch, real-time, and incremental data migration workflows.
• Identify and troubleshoot data quality issues, duplicates, missing records, and transformation anomalies.
• Validate AWS source data flowing into downstream systems.
• Generate reconciliation reports, data quality metrics, and migration readiness assessments.
• Collaborate with Data Engineers, Architects, Business Analysts, Development, and QA teams.
• Review test strategies, test cases, and defect tracking processes.
• Lead and mentor testing team members.

Required Skills:

• Strong Database / Backend Testing experience
• Advanced SQL and complex query writing
• Joins, aggregations, subqueries, and data reconciliation
• File-to-File Data Validation
• Volume Testing and Large Data Set Validation
• Data integrity, accuracy, and consistency validation
• ETL/ELT and Data Migration Testing
• AWS Data Validation
• Experience with Oracle, SQL Server, PostgreSQL, or MySQL

Nice to Have:

• API Testing using Postman, Swagger, or similar tools
• REST APIs and HTTP methods
• API response validation against database data
• JSON/XML validation
• Experience leading testing teams

Experience Required:

• 7–10 years of experience in Database / Backend Testing
• Lead experience preferred