DB Tester

Atain; Gurugram District; Hybrid; INR 1,800,000 - 2,600,000; Full time

Job summary

Atain is seeking a Test Engineer specializing in Data Migration & Transformation Validation. You will lead testing for large-scale migrations, design validation strategies, and develop SQL-driven checks to ensure data quality across enterprise platforms.

Collaboration with data engineers and BI teams is essential to define acceptance criteria and readiness metrics. This role demands 6–10 years of experience, with a focus on end-to-end testing of batch, real-time, and incremental migrations in a

Qualifications

• 6–10 years in data testing and migration projects.
• Experience validating ETL/ELT processes.
• Ability to design data validation strategies and SQL tests.

Responsibilities

• Lead testing for large-scale data migration across enterprise platforms.
• Design and execute data validation strategies for accuracy and completeness.
• Develop complex SQL queries and automated validation scripts.
• Collaborate with data engineers and business teams on test criteria.
• Produce data quality metrics and migration readiness reports.

Skills

Data migration testing

SQL scripting

ETL testing

Data validation

Test strategy

Data quality

Tools

SQL

Job description

Experience: 6–10 Years

Location: Gurgaon Hybrid

Test Engineer – Data Migration & Transformation Validation (Must Have)

• 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.

AI Agent Onboarding & Test Automation (Good to Have)

• Establish an automation-first testing strategy for the product and agent-based workflows.
• Identify opportunities to use AI-driven test automation to improve test coverage, execution efficiency, and agent workflow validation.
• Collaborate with development, architecture, AI partners, and QA teams to embed DB automation & AI agent into the product development lifecycle.
• Define test scenarios and validation strategies for AI-agent-based workflows, covering functional, integration, data, and end-to-end validation.