Author and execute comprehensive data validation test suites for data warehouse systems, ETL processes, and database integrity to deliver accurate, high‑quality data solutions on time.
Follow standard operating procedures, validate data accuracy and transformation logic, track and close data‑related defects, and document evidence across multiple environments (dev, test, pre‑prod, prod).
Mentor QA engineers and collaborate with cross‑functional teams to ensure high‑quality data warehouse solutions meet company commitments.
Partner with product, engineering, and internal teams for support, training, and knowledge transfer on database and data warehouse testing best practices.
Identify and drive improvements in data testing processes and automation.
Review and provide feedback on technical documentation for data pipelines, ETL processes, and database schemas.
Research and introduce new tools, frameworks, and best practices for database and warehouse test automation.
Collaborate on defining and executing test strategies for data‑centric products.
Analyze acceptance criteria, create test cases, and maintain automated test suites for data validation.
Validate data accuracy, integrity, and transformation logic across multiple database environments.
Troubleshoot and resolve data‑related issues to ensure high data quality throughout the pipeline.
Independently lead testing efforts and participate in Agile ceremonies with the Data Intelligence team.
Requirements
3–5 years of software engineering or software testing experience, with a strong focus on database/data warehouse testing.
Deep understanding of relational databases, data warehousing concepts, and ETL processes
Expert‑level SQL skills for data validation, profiling, and root‑cause analysis (Oracle, MySQL, Snowflake)
Experience with data testing tools and automation frameworks
Strong analytical skills for investigating data discrepancies in source, transformation, and loading stages
Manual and automated testing experience focused on data quality
Familiarity with Unix/Linux environments
Experience with GIT, JIRA, Confluence, and cloud platforms (AWS preferred)
Bachelor’s degree or equivalent experience in computer science, engineering, or related field