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

ETL QA Engineer

Woodland Hills, California, United StatesOnsiteFull Time$130,000–$140,000 /yrPosted 2 months 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

The ETL QA Engineer will be responsible for ensuring the accuracy and integrity of data transformations and pipelines within the Property & Casualty Insurance domain. This role requires strong expertise in ETL testing, data validation, and SQL, along with a solid understanding of Agile methodologies and the SDLC. Key responsibilities include validating data mappings, transformations, and business rules, designing and executing various types of tests, and collaborating with development teams to resolve defects. The ideal candidate will possess excellent analytical and communication skills and experience with tools like Rally. Preferred qualifications include knowledge of Snowflake architecture and Guidewire PolicyCenter.

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

#LI-OJ1

Location

Woodland Hills, CA

Job Function

TECHNOLOGY

Role

Engineer

Job Id

403882

Desired Skills

ETL Testing

Salary Range

$130,000-$140,000 a year

Desired Candidate Profile

Qualifications : BACHELOR OF COMPUTER SCIENCE

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

Similar roles