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 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.
No comments:
Post a Comment