Job Description

ETL QA Engineer


Woodland Hills, Los Angeles, CA

Must Have Technical/Functional Skills


Agile & Scrum Expertise


Analytical & Decision-Making Skills


Communication & Stakeholder Management


Technical & Domain Awareness: Property & Casualty Insurance domain(Auto, Home, Umbrella LOBs)


Common Tools & Artifacts: Rally

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, 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.

Required Skills and Experience:


Hands-on experience in executing projects in Agile methodology


Strong experience in ETL testing and data validation.


Solid understanding of ETL architecture and data pipelines.


Hands on expertise in SQL (advanced queries, joins, aggregates).


Strong understanding of SDLC / STLC, especially in data centric projects

Nice to Have:


Technology Awareness


Communication & Influence Skills


Leadership & Soft Skills


Coaching & Facilitation


Risk management


Understanding on Snowflake architecture


Knowledge on Gui dewire Policy center - Create submissions, policy changes on GWPC screens for validations.

Job Tags

Similar Jobs