Job Title: ETL Tester QA Engineer Insurance domain

Location: Woodland Hills, Los Angeles, CA(Preferred) Remote Work

Long Term Contract

Job Description:

• Validate source to target data mappings for accuracy and business correctness.

• Perform data reconciliation between source systems and target databases.

• Verify ETL transformations, aggregations, calculations, and derivations.

• Perform end to end data flow validation (Source ? Staging ? Target).

• Validate business transformation rules against functional requirements.

• Ensure compliance with domain specific rules (property & casualty insurance)

• Collaborate with Business SMEs to ensure data meaning is preserved after transformation

• Create and maintain: ETL test strategy, Test scenarios and test cases, Data validation checklists

• Design test cases for: Full loads, Incremental loads, Delta and historical data loads

• Execute testing for: Smoke testing, System Integration Testing (SIT), UAT support, Reconciliation and regression testing

• Identify, log, and track ETL defects with clear 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."