QA Automation Engineer (ETL, Python, pytest)

Meduvi LLC.; United States; Remote; USD 96,000 - 99,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Weekly payroll

Job summary

Meduvi LLC. is seeking an ETL Test Automation Engineer to validate large-scale data platforms, ETL pipelines, and cloud data testing. You will develop Python automation scripts using pytest and pandas to perform automated ETL data validation.

Responsibilities include ETL testing, data validation, API testing, and regression testing within an Agile team, with a 100% remote setup across the United States. Strong SQL and experience with data tools are required.

Qualifications

• 5+ years QA/testing experience.
• Strong Data Warehouse and ETL testing.
• Experience with API test automation.
• Strong SQL for data validation and reconciliation.
• Experience in Agile environments.
• Experience creating test plans and strategies.

Responsibilities

• Perform ETL testing.
• Validate source-to-target data mappings and transformation logic.
• Develop and maintain Python-based automation frameworks.
• Execute API, functional, and regression testing.
• Create and execute test plans, test cases, and test strategies.
• Analyze test results and coordinate defect triage activities.
• Work closely with developers, business analysts, and stakeholders in Agile teams.
• Ensure data quality, accuracy, and integrity across enterprise systems.

Skills

QA & Testing

Data Warehouse Testing

ETL Testing

API Test Automation

SQL

Agile Methodologies

Test Plans & Strategies

Tools

pytest

pandas

Great Expectations

dbt tests

Kafka

Playwright

Gherkin

Job description

This is a contract-to-hire role with an estimated conversion to permanent employment at 6 months.

Pay Rate for Contract: $70-$72/hour w2, depending on experience

Salary Range for Permanent Employment: $115,000-$120,000 plus bonus

40 Hours/week

Must work core hours M-F 8am-5pm EST

Reporting Mode: 100% Remote from anywhere in the United States

We are seeking an ETL Test Automation Engineer with strong experience in Data Warehouse Testing, ETL Testing, Cloud Testing, and Python Automation. The ideal candidate will have hands-on experience validating large-scale data platforms, testing ETL pipelines, and automating test processes in cloud and big data environments. This role will develop Python automation scripts using pytest and pandas to perform automated ETL data validation.

Required Skills

• 5+ years of QA and Testing experience
• Strong experience in Data Warehouse and ETL Testing
• Experience with API Test Automation
• Strong SQL skills for complex data validation and reconciliation
• Experience working in Agile environments
• Experience creating Test Plans, Test Strategies

Preferred Skills

• Experience with Generative AI (Gen AI)
• Familiarity with data observability or data testing tools (e.g., Great Expectations, dbt tests)
• Experience with pytest
• Domain experience in healthcare, including managing data regulations
• Working knowledge of cloud ecosystems and message/streaming platforms (Kafka)
• Exposure to Playwright automation
• Exposure to Gherkin syntax, BDD frameworks and Cucumber

Key Responsibilities

• Perform ETL testing
• Validate source-to-target data mappings and transformation logic
• Develop and maintain Python-based automation frameworks
• Execute API, functional, and regression testing
• Create and execute test plans, test cases, and test strategies
• Analyze test results and coordinate defect triage activities
• Work closely with developers, business analysts, and stakeholders in Agile teams
• Ensure data quality, accuracy, and integrity across enterprise systems

Technical Skills

• ETL Testing
• Python Automation
• API Testing
• Complex SQL
• Agile Methodologies

---------------------------

Compensation Statement. Please see pay rate within this job posting.

Employee Benefits Statement. Meduvi offers comprehensive medical health insurance (HMO/PPO), dental (PPO) and weekly payroll with direct deposit.

EEO Statement. We welcome all applicants and qualified individuals, who will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.