Sr. ETL Tester

Job Description: As a Senior QA Engineer at our company, you will be responsible for owning test automation across data/ETL pipelines, APIs, and web frontends. Your role will involve designing robust QA strategies, building CI/CD-native test suites, driving performance/load testing, and converting system requirements into executable and measurable test plans. Key Responsibilities: - ETL/Data Quality Automation: - Design and automate tests for ingestion, transformation, and loading including schema checks, constraints, null/dup checks, reconciliation, and row/column-level validation. - Implement data contract and data lineage test coverage, ensuring verification of CDC/merge logic and dedup rules. - Add data checks to orchestration tools like Airflow, Prefect, or Cloud Composer to 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 and stabilize flaky tests with a 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 and automate performance tests in CI, publishing trend dashboards. - CI/CD & Quality Gates: - Integrate tests into CI/CD pipelines with quality gates, artifacting, and environment provisioning. - Build disposable test environments using containers and IaC, seeding synthetic datasets for deterministic runs. - Test Strategy & Documentation: - Translate PRDs/BRDs into detailed test plans, risk matrices, and traceability matrices. - Advocate for shift-left testing, code reviews for testability, and quality as code. - Monitoring & Incident Support: - Instrument quality KPIs, collaborate on root-cause analysis, and prevent regressions with guardrail tests. Qualifications: - Bachelors 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 skills and comfortable driving quality across engineering, data, and product teams. Additional Details: - Location: Mohali, Punjab Company Tools: - 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,