Urgent requirement of ETL QA Engineer for Woodland Hills, Los Angeles, CA (Onsite/Remote)

Hi,

This is Diksha Chaudhary working with Novia Infotech. We have the below contract job opportunity with one of our direct clients and would like to check if you have any resources available. Please send across the resume of your consultants along with the contact information at the earliest to diksha.c@noviainfotech.com.

 

Role: ETL QA Engineer

Location: Woodland Hills, Los Angeles, CA (Onsite Preferred) / Remote

Duration: 12+ Months

 

Description:

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

 

 

 

'

Diksha Chaudhary US IT Recruiter www.noviainfotech.com

E: diksha.c@noviainfotech.com A: 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/CAEm%3D8YXrB1LULk4Ke_zuU384G%3DWDixUgGR%2BV8S2FtLWFHQdK7A%40mail.gmail.com.