Automation Tester/Quality Consultant

WeSupport, Inc.; Taguig; Hybrid; PHP 600,000 - 1,000,000; Full time

Job summary

WeSupport, Inc. is seeking a data quality specialist to drive ETL testing and data validation across multiple systems. You will build Python-based automation for ETL checks, UI testing with Playwright, and API testing. Expect collaboration with cross-functional teams and CI/CD integrations in a fast-paced environment.

The role emphasizes data accuracy, SQL proficiency, and experience with BI validation and cloud-based ETL pipelines. Agile/Scrum practices are used throughout development.

Qualifications

• Bachelor's degree required with strong ETL/testing foundation.
• 3–5 years in ETL testing and data warehousing concepts.
• Hands-on Python programming experience.
• Experience with Playwright for UI automation.
• Strong SQL skills including joins and window functions.
• API testing and automation experience.
• Familiarity with Apache JMeter for performance testing.
• Knowledge of AWS services is a plus.
• Experience with CI/CD tools and cloud ETL pipelines.
• Knowledge of data migration testing and BI validation.
• Exposure to Agile/Scrum methodologies.

Responsibilities

• Validate data between source and target systems (DB2, Oracle, MySQL).
• Perform data reconciliation, completeness, and transformation validation.
• Write complex SQL queries for data validation and analysis.
• Test ETL pipelines across Landing -> Raw -> Derived -> Mart.
• Identify and troubleshoot data discrepancies.
• Develop and maintain automation frameworks using Python.
• Automate ETL validation (data comparison, counts, schema).
• Integrate automation with CI/CD pipelines.
• Design and execute UI automation scripts using Python + Playwright.
• Test REST APIs using Postman / Python requests / REST Assured.

Skills

ETL Testing

Python programming

UI Automation

SQL

API Testing

Playwright

CI/CD

AWS services

Cloud ETL Pipelines

Data Migration Testing

Tableau/BI validation

Agile/Scrum

Education

Bachelor's degree

Tools

Postman

REST Assured

Jenkins

Git

Job description

About the role

This role involves comprehensive ETL and data testing, automation testing, UI testing, API testing, and performance testing across multiple systems and technologies.

Key responsibilities

• Validate data between source and target systems (DB2, Oracle, MySQL, etc.)

• Perform data reconciliation, data completeness, and transformation validation

• Write complex SQL queries for data validation and analysis

• Test ETL pipelines across layers (Landing -> Raw -> Derived -> Mart)

• Identify and troubleshoot data discrepancies

• Develop and maintain automation frameworks using Python

• Automate ETL validation (data comparison, counts, schema validation)

• Integrate automation with CI/CD pipelines

• Design and execute UI automation scripts using Python + Playwright

• Test REST APIs using tools like Postman / Python requests / REST Assured

About you

• Bachelor's degree graduate

• 3-5 years of experience in ETL Testing & Data Warehousing concepts

• 3-5 years Python programming

• Hands-on experience with Playwright (UI Automation)

• Strong SQL skills (joins, aggregations, window functions)

• Experience in API testing and automation

• Experience with Apache JMeter for performance testing

• Knowledge of AWS services (S3, Glue, Athena, Redshift) is a plus

• Familiarity with CI/CD tools (Jenkins, Git, etc.)

• Experience in cloud-based ETL pipelines

• Knowledge of data migration testing

• Experience with Tableau or BI dashboards validation

• Exposure to Agile/Scrum methodology