QA Automation Engineer (ETL, Python, pytest)

• 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
• Strong Python Automation skills (Python, pytest, pandas)
• 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.