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

Atec, Inc.

Trades Helper I Job at Atec, Inc.

...SUMMARY ~ This job description outlines the duties and responsibilities for the Trades Helper I position at Vital Link Inc. The goal is to facilitate the employee's success within the chain of command by promoting transparent, effective, efficient, and quality corporate...

Emergent Preparatory Academy

Early Childhood Education Teacher Job at Emergent Preparatory Academy

Benefits: Competitive salary Health insurance Paid time off Training & development Dental insurance Position Overview: Emergent Preparatory Academy is seeking a passionate and dedicated Early Childhood Education Teacher to join our dynamic team of ...

Digitas

Associate Creative Director, Copy Job at Digitas

...Associate Creative Director We are seeking an Associate Creative Director to help lead creative development for a large, high-profile... ...with at least 3 years in an advertising or marketing agency ~ Strong portfolio demonstrating conceptual thinking, storytelling...

PB consulting

SAP MDG Consultant Job at PB consulting

...Roles and Responsibilities *Develop and implement MDM strategies across SAP and non-SAP systems. *Lead master data cleansing, validation, enrichment, and migration activities. *Support data conversion initiatives and plan for migration to non-SAP target systems....

Appian

Enterprise Account Executive - Department of Homeland Security Job at Appian

...trajectory.What Youll DoCommand Complex Sales Cycles: Lead complex, end-to-end enterprise sales cycles across the Department if Homeland Security, navigating from initial client discovery to a successful close.Build Top-of-Funnel Pipeline: Build a robust, sustainable...

ETL QA Engineer Job at United IT Solutions, Calabasas, CA