senior big data tester.

1. Help implement Shift Left testing in dbt world 

2. Involve early on in requirements gathering session and contribute to Data mapping, data Modelling sheets by closely working with BAs, Data Modellers and End Users.

3. Understand technical project/ release goals and end user needs while deriving Test Coverage and Scenarios

4. Collaborate with developers to build automated test suites in dbt framework – In-built assertions and also custom developed test cases

5. Regularly review the automated test suites to optimise test coverage, identify gaps/ redundancies and maintain requirements traceability to the automated Test cases.

6. Execute any test cases that are not covered as part of dbt test suites- Integration, negative or failover, exception handling etc (these may vary based on the delivery type) and also any exploratory testing on need basis.

7. Ensure quality code is developed by continuous validation and assurance of the automated test cases (design as well as output validations)

8. Feedback to dev team on any slow running queries/ inefficient transformations for optimisation

9. Coordinate and support UAT and BAT Test Phases

10. Contribute to monitoring practices by suggesting metrics or threshold alerts based on user feedbacks post deployment ensuring data quality is maintained even in production

11. Support with dbt and UAT implementation roll out to multiple projects in data estate.