ETL QA Engineer C2C Woodland Hills, CA​/Los Angeles, CA

Position: ETL QA Engineer

Location:

Woodland Hills, CA / Los Angeles, CA (Onsite)

Duration: 6+ months contract

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

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

• 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 Powercentre~Test Management Experience

Required:

8-10