Job Title: Data Warehouse SDET
We are seeking a skilled Data Warehouse Software Development Engineer in Test (SDET) who is passionate about software quality, has an agile mindset, and is interested in developing their knowledge and skillset within the data warehouse space.
This role involves close collaboration with the data & analytics team to support and test throughout the entire data development lifecycle within our data warehouse and reporting systems, including data profiling, ETL, and data model design, development, testing, and support.
Key Responsibilities:
* Develop test strategies and test artifacts to validate our data warehouse E2E process and reporting interfaces.
* Contribute to devising the test automation strategy and tools for validating the data, functionality, and ETL & BI solution testing in collaboration with the QA practice lead.
* Conduct thorough testing of the data warehouse solutions.
* Design an environment management strategy for the data warehouse and reporting test environment instances in collaboration with the team and the QA practice lead.
* Work with the team to define the core QA gates and processes for new data warehouse feature development in collaboration with the quality practice lead.
* Collaborate with the team to define the key QA gates and test approach for functionality delivered by the data & analytics team.
* Create a core data warehouse regression suite focusing on leveraging automated validation to maximum effect.
* Validate source to target mappings using various tools.
* Ensure reports validation ensuring the finalised reports are an accurate reflection of the source data.
* Guarantee comprehensive and transparent test coverage for new and existing functionality.
* Evaluate the testability of new data warehouse features during analysis and development phases.
* Develop a deep understanding of the E2E flow in the data warehouse and the associated BI reporting systems.
* Collaborate with user acceptance testers to ensure an efficient test approach across these phases of test.
* Implement scalable solutions according to defined patterns and practices.
* Collaborate closely with data & analytics software engineers to develop a deep understanding of the underlying SQL server integration (SSIS) packages and associated data transformations.
* Participate in a Scrum team using Agile practices and adhering to the values and principles.
* Promote testing best practices within the team.
* Research test tools, methodologies, and trends and work on continuous process improvement initiatives within the quality practice.
* Collaborate closely with the data architect to create the appropriate test strategies for new data warehouses.