Looking for ETL QA Engineer - Woodland Hills, CA / Los Angeles, CA (Onsite)
Jyothi Shivampeta
Hi,
Greetings from iTech US.
I am trying to reach you regarding an opportunity copied below. Please reply to me if you are available & interested in the below opportunity with a word version of your resume, best time & number to contact you. Please feel free to contact me to discuss more about this opportunity.
Position: ETL QA Engineer
Location: Woodland Hills, CA / Los Angeles, CA (Onsite)
Duration: 6+ months contract
H1B candidates ONLY – Passport number MUST
Job Description:
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 Guidewire Policy center - Create submissions, policy changes on GWPC screens for validations.
Skills: Informatica Powercentre~Test Management Experience Required: 8-10
Education: At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required.
Thanks & Regards
Jyothi S
ITech US, Inc,