ETL QA Engineer

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.