ETL QA Engineer for Woodland Hills, Los Angeles, CA (Onsite Preferred) / Remote

Hi,

My name is Rohit Chauhan, and I am a Staffing Specialist at Novia Infotech LLC. I am reaching out to you on an exciting job opportunity with one of our clients.

 

Job Title: ETL QA Engineer

Location: Woodland Hills, Los Angeles, CA (Onsite Preferred) / Remote
Duration: 12+ Months

---

Job Summary:

We are seeking a detail-oriented ETL QA Engineer with strong expertise in data validation, ETL testing, and data pipelines. The ideal candidate will ensure data accuracy, integrity, and compliance across systems, with a focus on end-to-end data flow validation and business rule verification, particularly within the Property & Casualty Insurance domain.

---

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, and calculations
• Conduct end-to-end data validation (Source → Staging → Target)
• Validate business transformation rules against functional requirements
• Ensure compliance with domain-specific rules (P&C Insurance)
• Collaborate with Business SMEs to ensure data integrity and correctness
• Create and maintain:
• ETL test strategy
• Test scenarios and test cases
• Data validation checklists
• Design and execute test cases for:
• Full loads
• Incremental loads
• Delta and historical loads
• Perform:
• Smoke testing
• System Integration Testing (SIT)
• UAT support
• Regression and reconciliation testing
• Identify, log, and track defects with 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 & Experience:

• 8–10 years of overall IT experience
• Strong hands-on experience in ETL Testing and Data Validation
• Solid understanding of ETL architecture and data pipelines
• Advanced proficiency in SQL (joins, aggregates, complex queries)
• Experience working in Agile methodology
• Strong knowledge of SDLC / STLC, especially for data-centric projects

---

Preferred Qualifications:

• Experience with Informatica PowerCenter
• Knowledge of Test Management tools
• Understanding of Snowflake architecture
• Experience with Guidewire PolicyCenter (GWPC):
• Submissions
• Policy changes
• Validation on GWPC screens
• Strong communication, leadership, and stakeholder management skills
• Experience in risk management and coaching/mentoring

---

Key Deliverables:

• Accurate and validated data pipelines and ETL processes
• High-quality test cases and validation frameworks
• Reduced defects through thorough testing and RCA
• Reliable and consistent data quality reporting

 

 

Rohit Chauhan IT Recruiter E: rohit.c@noviainfotech.com www.noviainfotech.com A: 4421 Avenida Ln, McKinney, TX, 75070

 

 

--
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CAJ0-OE-pCb1vDT%3DxpmXdXuZw09K0SDX%2By0OGVQCXMztQoGu9bw%40mail.gmail.com.