Description
You will own data warehouse testing for complex data models and BI reporting initiatives.
Responsibilities
- Analyze user stories and acceptance criteria to define test plans and test cases.
- Develop and prepare necessary test data to evaluate overall testability.
- Execute testing across multiple phases in medium to large-scale projects.
- Perform back-end/ETL testing, focusing on data accuracy and integrity.
- Handle multiple concurrent priorities with limited direct oversight.
Required Skills
- 7+ years of professional experience, specifically in data warehouse testing.
- Strong SQL skills for complex data validation.
- Hands-on experience with AWS, Azure, and IICS cloud services.
- Proficiency working with databases including SSMS, Oracle, Workbench, and Snowflake.
- Experience testing complex data models and BI reporting structures.
- Demonstrated understanding of data mart testing principles.
Preferred Skills
- Knowledge of FiveTran, DBT, Airflow, or Great Expectations.
- Experience in the food or transportation industry.