Qa Automation Testing Engineer (ETL/ Python/ Database)

Were 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 ephemeral test envs. 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.