Senior QA- ETL/ Database

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 turning 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, and row/column-level validation. - Implement data contract and data lineage test coverage, ensure CDC/merge logic and dedup rules are verified. - Add data checks to orchestration tools like 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 and stabilize flaky tests with good wait/retry design. - **Performance/Load Testing:** - Establish load, stress, soak, and breakpoint tests for APIs and web apps. - Automate performance tests in CI and publish 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 Infrastructure as Code (IaC) and 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, 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; comfortable driving quality across engineering, data, and product teams. Please note that the company is located in Mohali, Punjab.,