ETL QA Engineer

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

Do you have experience in SQL databases?, Do you have a Bachelor's degree?, 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, * 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., Qualifications : BACHELOR OF COMPUTER SCIENCE