**Role & Seniority: ** ETL Automation Tester (Senior) — 6+ years; may include lead testing responsibilities

**Stack/Tools: **

Python (test automation)
SQL (joins, subqueries, data validation)
Selenium (automation)
Data warehousing concepts, ETL workflows
(Nice-to-have) Git, CI/CD tools, AWS/Azure
Top 3 Responsibilities:
- Develop and execute automated test scripts for ETL pipelines using Python
- Perform ETL/database testing to verify data integrity, transformation logic, and migrations
- Write/optimize SQL queries for validation and analysis; define test strategies with stakeholders
Must-have Skills:
- Strong ETL testing / database testing experience
- Proficient in SQL for validation and analysis
- Hands-on Python automation experience
- Understanding of ETL/data warehousing workflows
- Analytical/problem-solving skills; defect tracking and reporting
Nice-to-haves:
- Automation framework development experience
- CI/CD and Git exposure
- Cloud knowledge (AWS/Azure)
- For lead: ability to plan/explain testing and report outcomes
Location & Work Type: Remote; client-facing communication required

Full Description

Job Title: ETL Automation Tester -Remote

Location: Remote

Experience: 6+ Years

Job Overview

We are looking for a skilled ETL Automation Tester with strong expertise in Python and database testing. The ideal candidate will be responsible for validating data pipelines, ensuring data accuracy, and building automation frameworks for ETL processes. This role requires strong technical capabilities along with excellent communication and client-facing skills. Key Responsibilities

Design, develop, and execute automated test scripts for ETL processes using Python Perform ETL/Database testing to validate data integrity, transformation logic, and data migration. Write and optimize complex SQL queries for data validation and analysis. Collaborate with developers, business analysts, and stakeholders to understand requirements and define test strategies. Identify, log, and track defects, ensuring timely resolution. Monitor and improve test automation frameworks for performance and scalability. Lead testing efforts (for senior/lead roles), including planning, execution, and reporting. Participate in client interactions, providing updates and handling queries effectively. Required Skills

Strong experience in ETL Testing / Database Testing Proficiency in SQL (joins, subqueries, data validation) Hands-on experience in Python for automation Experience with Selenium Automation Good understanding of data warehousing concepts and ETL workflows Strong analytical and problem-solving skills Preferred Skills

Experience in automation frameworks development Exposure to CI/CD tools and version control (Git) Knowledge of cloud platforms (AWS/Azure) is a plus Soft Skills

Excellent communication skills Strong client-facing experience Leadership abilities (for Lead role) Ability to work in a fast-paced environment