ETL QA Engineer

2T Consulting

Woodland Hills, CA/Los Angeles, CA

Posted On: Apr 02, 2026

Posted On: Apr 02, 2026

Job Overview

Job Type

Full-time

Experience

8 - 12 Years

Salary

Depends on Experience

Work Arrangement

On-Site

Travel Requirement

0%

Required Skills

  • ETL testing
  • Data Validation
  • SQL
  • Property & Casualty Insurance
Job Description
Required Skills
  • Agile/Scrum experience
  • Strong analytical and decision-making skills
  • Good communication and stakeholder management
  • Domain knowledge: Property & Casualty Insurance (Auto, Home, Umbrella)
  • Experience with Rally (or similar tools)
Roles and Responsibilities
  • Validate source-to-target mappings and business rules
  • Perform data reconciliation between source and target systems
  • Verify ETL transformations (aggregations, calculations, derivations)
  • Conduct end-to-end data validation (Source → Staging → Target)
  • Ensure compliance with P&C domain rules
  • Collaborate with business SMEs to ensure data accuracy
  • Create and maintain test strategy, test cases, and validation checklists
  • Design and execute tests for full, incremental, delta, and historical loads
  • Perform SIT, UAT support, regression, reconciliation, and smoke testing
  • Log, track, and analyze defects; support resolution with dev teams
  • Validate fixes and generate data quality/test reports
Required Experience
  • Hands-on ETL testing and data validation experience
  • Strong understanding of ETL architecture and data pipelines
  • Advanced SQL skills (joins, aggregations, complex queries)
  • Knowledge of SDLC/STLC in data-centric projects

Job ID: 2C320895


Posted By

Shayne

Sr. Recruiter