[On-site / Remote / Hybrid - City, State or "Anywhere, USA"]
Employment Type:
[Full-time / Contract / C2C / Part Time ]
NOTE :
Candidate has to work US Night Shifts
Job Summary:
We are seeking a highly skilled
ETL Automation Tester
with expertise in
SQL
,
Python scripting
, and experience working with
Cloud technologies
such as
Azure, AWS, or GCP
. The ideal candidate will be responsible for designing and implementing automated testing solutions to ensure the accuracy, performance, and reliability of ETL pipelines and data integration processes.
Key Responsibilities:
Design and implement test strategies for ETL processes and data pipelines.
Develop automated test scripts using Python and integrate them into CI/CD pipelines.
Validate data transformations and data integrity across source, staging, and target systems.
Write complex SQL queries for test data creation, validation, and result comparison.
Perform cloud-based testing on platforms such as Azure Data Factory, AWS Glue, or GCP Dataflow/BigQuery.
Collaborate with data engineers, analysts, and DevOps teams to ensure seamless data flow and test coverage.
Log, track, and manage defects through tools like JIRA, Azure DevOps, or similar.
Participate in performance and volume testing for large-scale datasets.
Required Skills and Qualifications:
3-7 years
of experience in ETL/data warehouse testing.
Strong hands-on experience in
SQL
(joins, CTEs, window functions, aggregation).
Proficient in
Python
for automation scripting and data manipulation.
Solid understanding of
ETL tools
such as Informatica, Talend, SSIS, or custom Python-based ETL.
Experience with at least one
Cloud Platform
:
Azure
: Data Factory, Synapse, Blob Storage
AWS
: Glue, Redshift, S3
GCP
: Dataflow, BigQuery, Cloud Storage
Familiarity with
data validation
,
data quality
, and
data profiling
techniques.
Experience with
CI/CD tools
such as Jenkins, GitHub Actions, or Azure DevOps.
Excellent problem-solving, communication, and documentation skills.
Preferred Qualifications:
Knowledge of
Apache Airflow
,
PySpark
, or
Databricks
.
Experience with
containerization
(Docker) and
orchestration
tools (Kubernetes).
ISTQB or similar testing certification.
Familiarity with