QA Analyst (DB & ETL)
Core
Designing and executing QA tests for data warehouses and ETL processes to ensure data quality and system integrity.
Role type
Senior QA Analyst (Database & ETL)
Builds
Data quality assurance for customer experience and marketing analytics platforms
Domain
Data Warehousing & ETL
Deliverable
production ML models | dashboards & analysis
Required skills
SQL, DWH/Database testing, test case design, SQL script development, functional testing, regression testing, load testing, UAT, defect tracking, data quality remediation
Preferred skills
Cloud technologies, JIRA, SOAP/API testing
Technologies
JIRA
Responsibilities
Define scope and objectives of all levels of QA testing; Write test plans, design test cases, develop test SQL scripts; Perform functional, regression, load, system, and UAT on DWH/Database; Create large volumes of test data; Track and report defects; Validate fixes and ensure follow through to all test cycles; Investigate and recommend remediation strategies for data quality conditions and process failures; Communicate test status to internal project team and clients; Develop and contribute best practices and standards; Mentoring a team of 2 to 3 QA Associates
Seniority
Mid-Senior, hands-on IC with mentoring responsibilities
