Senior Test Specialist - Cloud ETL, DW Automation

Sapsf; United States; On-site; USD 120,000 - 150,000; Full time

Job summary

Sapsf is seeking a Senior Test Specialist in Cloud Automation Testing to automate ETL and data warehousing validation in a US-based environment. The role focuses on designing, developing, and executing automation scripts for data transformations and loading processes.

You will collaborate with cross-functional teams to build automated testing frameworks, create test plans, and drive performance testing to ensure scalable data pipelines and high data quality across the stack.

Qualifications

• Experience automating ETL and data warehouse testing.
• Strong SQL querying and data validation skills.
• Familiar with cloud-based automation testing.
• Experience with performance testing of data pipelines.
• Certifications in Automation Testing or Cloud technologies are a plus.

Responsibilities

• Develop and execute automated test scripts for ETL processes and data pipelines.
• Collaborate with cross functional teams to design and implement automated testing frameworks.
• Create test plans and test cases for ETL and data warehouse testing.
• Identify and troubleshoot issues in data transformations and data loading processes.
• Conduct performance testing to ensure scalability of data pipelines.
• Implement best practices for data quality assurance in ETL environments.

Skills

Automation testing tools

ETL testing

SQL queries

Big data technologies

Scripting (Python, Java, Shell)

Analytical thinking

Communication

Tools

Selenium

Appium

Hadoop

Spark

Kafka

Job description

Requisition ID175138-Posted09/30/2026

The Senior Test Specialist in Cloud Automation Testing focuses on automating testing processes in ETL (Extract, Transform, Load) and Data Warehousing environments to ensure the quality and reliability of data pipelines. The role involves designing, developing, and implementing automation scripts for testing data transformations, data loading processes, and data quality verification.

Key Responsibilities

1. 1. Develop and execute automated test scripts for etl processes and data pipelines.
2. 2. Collaborate with cross functional teams to design and implement automated testing frameworks.
3. 3. Create test plans and test cases for etl and data warehouse testing.
4. 4. Identify and troubleshoot issues in data transformations and data loading processes.
5. 5. Conduct performance testing and ensure scalability of data pipelines.
6. 6. Implement best practices for data quality assurance in etl environments.

Skill Requirements

1. 1. Proficiency in cloud based automation testing tools like selenium, appium, or similar.
2. 2. Experience in automation testing of etl (extract, transform, load) processes and data warehousing.
3. 3. Strong understanding of sql for data querying and validation.
4. 4. Knowledge of big data technologies such as hadoop, spark, or kafka is a plus.
5. 5. Familiarity with scripting languages like python, java, or shell scripting.
6. 6. Excellent analytical and problem-solving skills with a keen attention to detail.
7. 7. Ability to work collaboratively in a team environment and good communication skills.

Other Requirements

1. 1.Relevant certifications in Automation Testing, ETL Testing, or Cloud technologies are a plus.