Job Title: ETL Automation Tester (SQL, Python, Cloud)
Location: [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 Agile methodologies and Scrum ceremonies.
Job Types: Part-time, Contractual / Temporary, Freelance
Contract length: 6 months
Pay: ₹18,074.09 - ₹86,457.20 per month
Expected hours: 40 per week
Benefits:
- Work from home