ETL QA Engineer Job Los Angeles California USA,IT/Tech

ETL QA Engineer

Location:

ONSITE
- Woodland Hills, Los Angeles, CA (Preferred)/ Remote Work Duration: 6 months Role: ETL QA Engineer

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 Guidewire Policy center - Create submissions, policy changes on GWPC screens for validations.

Skills:

Informatica Power centre~Test Management

Experience

Required:

8-10 Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.