Testing - SQL, ETL, Data Migration, API

ADROITENT; Hyderabad, Pune District, Bengaluru; Hybrid; INR 900,000 - 1,200,000; Full time

Job summary

ADROITENT is seeking an experienced ETL Tester / Data Quality Analyst with strong SQL and database expertise to validate data across source and target systems within Agile environments.

You will perform ETL testing, API testing, data mapping validation, and UI testing, write complex SQL, analyze data, log defects, and collaborate with developers and business analysts to ensure data accuracy and completeness.

This role requires attention to detail and strong collaboration across teams.

Qualifications

• 6 years of experience in ETL testing, SQL, database testing, and data validation.
• Experience with ETL testing, API testing, data mapping validation, and UI testing in Agile environments.

Responsibilities

• Perform ETL testing and validate data movement from source to target systems.
• Create and execute test cases for data extraction, transformation, and loading processes.
• Validate data mapping and transformation rules as per business requirements.
• Write complex SQL queries to perform data validation and reconciliation.
• Analyze source and target database records to ensure data accuracy and completeness.
• Perform API testing using Postman and Swagger.
• Conduct UI testing to validate data displayed in front-end applications.
• Identify, log, track, and retest defects.
• Collaborate with developers, business analysts, and stakeholders in Agile/Scrum environments.
• Prepare test reports and maintain testing documentation.

Skills

ETL Testing

SQL

Database Testing

Data Validation

API Testing

UI Testing

Agile/Scrum

Tools

Postman

Swagger

Job description

Job Title: ETL Tester / Data Quality Analyst

Experience

6 Years of experience in ETL Testing, SQL, Database Testing, and Data Validation.

Job Summary

We are looking for a detail-oriented ETL Tester with strong SQL and database expertise to validate data across source and target systems. The candidate should have experience in ETL testing, API testing, data mapping validation, and UI testing within Agile environments.

Key Responsibilities

Perform ETL testing and validate data movement from source to target systems.

Create and execute test cases for data extraction, transformation, and loading processes.

Validate data mapping and transformation rules as per business requirements.

Write complex SQL queries to perform data validation and reconciliation.

Analyze source and target database records to ensure data accuracy and completeness.

Perform API testing using Postman and Swagger.

Conduct UI testing to validate data displayed in front-end applications.

Identify, log, track, and retest defects.

Collaborate with developers, business analysts, and stakeholders in Agile/Scrum environments.

Prepare test reports and maintain testing documentation.

Required Skills

ETL Testing

Strong experience in ETL/Data Warehouse testing.

Experience validating data flows, transformation logic, and data integrity.

SQL Skills

Ability to write complex SQL queries involving:

• Joins
• Subqueries
• CTEs
• Aggregate functions
• Data comparison and reconciliation queries
• Experience validating data between source and target systems.

API Testing

Hands-on experience with:

• Postman
• Swagger
• Validation of REST APIs, request/response payloads, status codes, and data consistency.