Sr. QA Engineer (ETL & Database)

Job Description: You are being hired as a Senior QA Engineer to take ownership of 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 translating system requirements into executable, 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, row/column-level validation, and business rule assertions. - 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 prevent bad data from being promoted. - 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, defining SLAs/SLOs and capacity baselines. - Automate performance tests in CI and publish trend dashboards. - CI/CD & Quality Gates: - Integrate tests into CI/CD pipelines (pre-merge, nightly, release) with quality gates, artifacting, and environment provisioning. - Build disposable test environments using containers and Infrastructure as Code (IaC) and seed synthetic datasets for deterministic runs. - Test Strategy & Documentation: - Translate PRDs/BRDs into detailed test plans, risk matrices, and traceability matrices. - Advocate for shift-left approach, 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 Computer Science/Information Technology or equivalent experience. - Minimum of 6 years in QA with at least 3 years in data/ETL test automation and 2+ years in performance testing. - Proven experience in integrating tests into CI/CD pipelines and scaling suites for speed and reliability. - Excellent communication skills and comfortable driving quality across engineering, data, and product teams. Location: - Mohali, Punjab,