ETL QA Engineer

Role: ETL QA Engineer
Location: Woodland Hills, Los Angeles, CA (Onsite Preferred) / Remote
Duration: 12+ Months

Description:

We are seeking a detail-oriented ETL QA Engineer with strong expertise in data validation, ETL testing, and data pipelines. The ideal candidate will ensure data accuracy, integrity, and compliance across systems, with a focus on end-to-end data flow validation and business rule verification, particularly within the Property & Casualty Insurance domain.

Key Responsibilities:
Validate source-to-target data mappings for accuracy and business correctness
Perform data reconciliation between source systems and target databases
Verify ETL transformations, aggregations, and calculations
Conduct end-to-end data validation (Source → Staging → Target)
Validate business transformation rules against functional requirements
Ensure compliance with domain-specific rules (P&C Insurance)
Collaborate with Business SMEs to ensure data integrity and correctness
Create and maintain:
ETL test strategy
Test scenarios and test cases
Data validation checklists
Design and execute test cases for:
Full loads
Incremental loads
Delta and historical loads
Perform:
Smoke testing
System Integration Testing (SIT)
UAT support
Regression and reconciliation testing
Identify, log, and track defects with root cause analysis
Work closely with ETL developers and data engineers to resolve issues
Validate defect fixes through re-testing and impact analysis
Produce data quality and test execution reports
Required Skills & Experience:
8–10 years of overall IT experience
Strong hands-on experience in ETL Testing and Data Validation
Solid understanding of ETL architecture and data pipelines
Advanced proficiency in SQL (joins, aggregates, complex queries)
Experience working in Agile methodology
Strong knowledge of SDLC / STLC, especially for data-centric projects
Preferred Qualifications:
Experience with Informatica PowerCenter
Knowledge of Test Management tools
Understanding of Snowflake architecture
Experience with Guidewire PolicyCenter (GWPC):
Submissions
Policy changes
Validation on GWPC screens
Strong communication, leadership, and stakeholder management skills
Experience in risk management and coaching/mentoring
Key Deliverables:
Accurate and validated data pipelines and ETL processes
High-quality test cases and validation frameworks
Reduced defects through thorough testing and RCA
Reliable and consistent data quality reporting