ETL Tester Job Description

Datagaps; Hyderabad; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Datagaps in Hyderabad is seeking an ETL Tester to validate data pipelines, ensure data accuracy, and test APIs across enterprise applications.

You will work with product-based teams, perform SQL validations, API testing, and data warehouse testing, and collaborate with Developers, Data Engineers, Business Analysts, and Product teams. Strong analytical and problem-solving skills are essential, with experience using Jira or Azure DevOps for defect tracking.

Qualifications

• Proven experience in ETL testing and data validation.
• Advanced SQL skills with complex queries and data validation.
• Hands-on API testing using Postman, Swagger, or similar tools.
• Strong manual testing experience and attention to data quality.
• Experience with Data Warehouse testing and data integration concepts.
• Understanding of ETL tools and data mappings and business rules.
• Solid knowledge of SDLC and STLC processes.
• Experience in product-based companies is mandatory.
• Defect tracking using Jira, Azure DevOps, or similar tools.

Responsibilities

• Validate ETL workflows, data transformations, and loading processes.
• Develop and execute test cases, plans, and scenarios.
• Perform source-to-target data validation.
• Validate large datasets with complex SQL queries.
• Conduct API testing to verify functionality, performance, and data integrity.
• Identify, log, and track defects through closure.
• Ensure data accuracy, completeness, consistency, and quality.
• Work closely with Developers, Data Engineers, Business Analysts, and Product Teams.
• Participate in requirement analysis and provide test estimates.
• Perform regression, integration, and end-to-end testing.

Skills

ETL Testing

SQL

API Testing

Manual Testing

Data Warehouse Testing

Data Integration Concepts

SDLC/STLC

Product-Based Companies

Defect Tracking (Jira/Azure DevOps)

Tools

Postman/Swagger

Jira

Azure DevOps

Selenium

Job description

We are looking for a highly skilled ETL Tester with strong experience in ETL Testing, SQL, API Testing, and Manual Testing. The ideal candidate should have worked extensively in product-based companies and possess strong analytical and problem-solving skills. The candidate will be responsible for validating data pipelines, ensuring data accuracy, testing APIs, and maintaining data quality across enterprise applications.

Mandatory Skills

• Strong experience in ETL Testing
• Excellent SQL skills with complex query writing and data validation
• Hands-on experience in API Testing using Postman, Swagger, or similar tools
• Strong exposure to Manual Testing
• Experience in Data Warehouse Testing
• Good understanding of ETL tools and data integration concepts
• Experience in validating data mappings, transformations, and business rules
• Strong knowledge of SDLC and STLC
• Experience working in Product-Based Companies is mandatory
• Defect tracking using Jira, Azure DevOps, or similar tools

Key Responsibilities

• Validate ETL workflows, data transformations, and loading processes.
• Develop and execute test cases, test plans, and test scenarios.
• Perform source-to-target data validation.
• Validate large datasets using complex SQL queries.
• Conduct API testing to verify functionality, performance, and data integrity.
• Identify, log, and track defects through closure.
• Ensure data accuracy, completeness, consistency, and quality.
• Work closely with Developers, Data Engineers, Business Analysts, and Product Teams.
• Participate in requirement analysis and provide test estimates.
• Perform regression, integration, and end-to-end testing.

Good to Have

• Knowledge of Automation Testing (Selenium, Rest Assured, or similar tools)
• Exposure to Cloud Platforms (AWS, Azure, or GCP)
• Experience with Snowflake, Databricks, Redshift, or similar data platforms
• Basic knowledge of Python scripting

Preferred Background

• Experience working in Product-Based Organizations
• Strong understanding of data warehousing concepts
• Experience testing large-scale data integration projects
• Excellent communication and stakeholder management skills