RiseMe
LoginSign Up
Tata Consultancy Services logo
Tata Consultancy Services Verified
Information Technology & Services

ETL QA Engineer

Los Angeles, California, United StatesOnsiteFull Time$130,000–$140,000 /yrPosted 1 month agoVisa sponsorship available

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

Seeking an ETL QA Engineer with expertise in Agile and Scrum methodologies to validate data accuracy and integrity within Property & Casualty Insurance domain projects. Responsibilities include data mapping validation, ETL transformation verification, end-to-end data flow testing, and defect management. Requires strong SQL skills, understanding of SDLC/STLC, and experience with data-centric projects. Familiarity with Snowflake and Guidewire Policy Center is a plus.

Job Description
ETL QA Engineer
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.

Salary Range- $130,000-$140,000 a year
Qualifications:
BACHELOR OF COMPUTER SCIENCE

Ready to apply?
You'll be redirected to Tata Consultancy Services's application page.

Similar roles