Sr QA Engineer – ETL & Automation Testing

Harmony Data Integration Technologies; Pakistan; On-site; PKR 2,500,000 - 4,500,000; Full time

Job summary

Harmony Data Integration Technologies is seeking a Senior QA Engineer to own test automation across data/ETL pipelines, APIs, and web frontends. You will design robust QA strategies, build CI/CD-native test suites, and drive performance testing.

You will translate system requirements into executable, measurable test plans, champion shift-left quality, and collaborate with data, engineering, and product teams to improve release quality.

Qualifications

• Experience validating data pipelines/warehouses (e.g., BigQuery/Snowflake/Redshift).
• Proficient in Python/TypeScript/Java for test automation.
• Experience with API testing tools (Postman/Newman, REST Assured, Pact).
• UI testing with Playwright or Cypress for stable, parallel tests.
• Performance testing with k6, JMeter, Locust; understanding p95/p99.
• CI/CD integration and test artifacting.
• Data testing frameworks like Great Expectations / Soda Core / dbt tests.
• Cloud containers and IaC familiarity (Docker, Kubernetes, Terraform).
• Observability tooling to link tests to telemetry (Prometheus, Grafana).

Responsibilities

• Own test automation across ETL pipelines, APIs, and frontends.
• Design data quality checks, schema validations, reconciliation, and CDC verification.
• Build CI/CD-native test suites and seed synthetic data.
• Create end-to-end, integration, contract, and regression tests.
• Define SLAs/SLOs, performance/load tests, and publish dashboards.
• Champion shift-left and quality as code; support monitoring and incident reviews.

Skills

ETL/Data QA

Automation frameworks

API Testing

UI Testing

Performance Testing

CI/CD

Data Testing Frameworks

Cloud & Containers

Observability

Education

Bachelor's in CS/IT

Tools

Postman/Newman

Playwright/Cypress

k6/JMeter/Locust

GitHub Actions/GitLab CI/Jenkins

Docker/Kubernetes

dbt/Soda/Great Expectations

Job description

We’re hiring a Senior QA Engineer who can own test automation across data/ETL pipelines, APIs, and web frontends. You’ll design robust QA strategies, build CI/CD-native test suites, drive performance/load testing, and turn system requirements into executable, measurable test plans.

What will you do:

• ETL/Data Quality Automation
• Design and automate tests for ingestion, transformation, and loading (schema checks, constraints, null/dup checks, reconciliation, row/column-level validation, business rule assertions).
• Implement data contract and data lineage test coverage; ensure CDC/merge logic and dedup rules are verified.
• Add data checks to orchestration (e.g., Airflow/Prefect/Cloud Composer) and block bad data from promotion.
• API & Frontend Test Automation
• Build end-to-end, integration, contract, and regression suites for REST/GraphQL services.
• Create UI automation for critical user journeys; stabilize flaky tests with good wait/retry design.
• Performance/Load Testing
• Establish load, stress, soak, and breakpoint tests for APIs and web apps; define SLAs/SLOs and capacity baselines.
• Automate performance tests in CI and publish trend dashboards.
• CI/CD & Quality Gates
• Integrate tests into CI/CD (pre-merge, nightly, release) with quality gates, artifacting, and environment provisioning.
• Build disposable test environments using containers and IaC; seed synthetic datasets for deterministic runs.
• Test Strategy & Documentation
• Turn PRDs/BRDs into detailed test plans, risk matrices, and traceability matrices.
• Champion shift-left, code reviews for testability, and “quality as code.”
• Monitoring & Incident Support
• Instrument quality KPIs; collaborate on root-cause analysis; prevent regressions with guardrail tests.

Must-have skills:

• ETL/Data QA: Strong experience validating data pipelines/warehouses (e.g., BigQuery/Snowflake/Redshift/PostgreSQL), reconciliation at scale, partitioning/windowing awareness, and SQL proficiency.
• Automation: Hands-on with Python/TypeScript/Java for test frameworks; solid patterns (fixtures, page objects, data builders).
• API Testing: Postman/Newman, REST Assured, Pact or equivalent for contract testing.
• UI Testing: Playwright or Cypress (preferred) for stable, parallelizable suites.
• Performance Testing: k6 / JMeter / Locust; interpreting p95/p99, throughput, saturation; correlation with APM metrics.
• CI/CD: GitHub Actions / GitLab CI / Jenkins; branching, artifacts, caching, matrix builds; gating policies.
• Data Testing Frameworks: Great Expectations / Soda Core / dbt tests; schema diffs, expectations as code.
• Cloud & Containers: Docker; working knowledge of Kubernetes-based ephemer…>
• Observability: Using Prometheus/Grafana/New Relic/Datadog to tie test results to runtime telemetry.

Nice-to-have

• Orchestrators (Airflow/Prefect), CDC tools (Debezium), ELT (Airbyte/Fivetran), transformation (dbt/Spark/Dataflow).
• IaC (Terraform), secrets management, feature flags.
• Security testing exposure (OWASP ZAP, SAST/DAST), basic vuln triage.
• Experience with data privacy and compliance test considerations.
• Experience building synthetic data generators and golden datasets.

Tools you might use here:

• Data/ETL: SQL, dbt, Great Expectations/Soda, Airflow/Prefect
• API/UI: Playwright/Cypress, Postman/Newman, REST Assured, Pact
• Performance: k6, JMeter, Locust
• CI/CD: GitHub Actions/GitLab CI/Jenkins, Docker, Terraform
• Analytics/Stores: BigQuery/Snowflake/Redshift/PostgreSQL
• Observability: Prometheus, Grafana, Datadog/New Relic

Qualifications:

• Bachelor’s in CS/IT or equivalent experience.
• 6+ years in QA with at least 3 years in data/ETL test automation and 2+ years in performance testing.
• Proven experience integrating tests into CI/CD and scaling suites for speed and reliability.
• Excellent communication; comfortable driving quality across engineering, data, and product teams.

Location: Mohali, Punjab