Data Ware House Test Lead

TechDigital Group; Los Angeles (CA); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading technology firm in Los Angeles is seeking an experienced QA Tester to manage and coordinate system testing. You will be responsible for executing functional tests, managing defect resolutions, and ensuring traceability of requirements. Ideal candidates should have a strong background in ETL and SQL testing, and proven experience in managing defect triage meetings. This position offers opportunities for collaboration across various teams.

Qualifications

• Strong understanding of ETL and SQL.
• Experience managing test setups and defect resolutions.
• Proven ability to coordinate with multiple teams.

Responsibilities

• Manage the scope and testing of the system.
• Draft and approve test cases with detailed steps.
• Conduct end-to-end functionality testing.

Skills

ETL knowledge

SQL testing

Test management

Defect resolution

Data traceability

Job description

Responsibilities

• Strong ETL and SQL testing knowledge
• Formalize Test Setup (Test Scenario; Test Environment, Test Data, Test Cases, and Test Scripts, etc.)
• Manage the scope and testing of the system
• Run Testing Team and report status to the project manager/team
• Manage defect resolution to entry and exit criteria in ALM
• Confirm the Requirement and control traceability
• Conduct data traceability and lineage at multiple points
• Operates as overall process owner (Meter to Cash, Customer Experience, Sales &Service)
• Test functionality end-to-end
• Manage defect triage meetings
• Responsible for the Test script inventory for the workstream
• Drafts/ Approves the test cases with detailed steps that need to be executed
• Test functionality
• Document test conditions and test scripts
• Execute Functional test scripts based on the type of testing
• Retest defects
• Coordinate with the data prep team to prepare the test data for the specific script
• Coordinate test planning & execution of test scripts for Edge Partners
• Coordinate the execution of scripts that depend on Vista DW, SCG DW & Edge Partners
• Coordinate the defect fixes for any defects that require Edge partner involvement.
• Report the test execution and defect status for testing conducted by Edge partners
• Coordinate with upstream teams and users to keep requirement documents up to date