Job ID: JOB_ID_8748
Job Title: ETL Tester
We are seeking an experienced ETL Tester to join our team for a contract position with a duration of 9+ months. The ideal candidate will be responsible for ensuring the accuracy and integrity of data throughout the ETL process, collaborating with business stakeholders, and validating transformations and business rules.
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 of Snowflake architecture.
- Knowledge on Guidewire Policy Center – Create submissions, policy changes on GWPC screens for validations.
Education:
At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or a closely related field is required.
This role requires a strong understanding of data validation and ETL processes within the insurance domain. The candidate will work closely with business SMEs and development teams to ensure data accuracy and compliance.
Special Requirements
Domain specific rules (property & casualty insurance) must be ensured. Knowledge on Guidewire Policy center is a plus.
Compensation & Location
Salary: $60 – $85 per year (Estimated)
Location: Woodland Hills, CA
Recruiter / Company – Contact Information
Email: an.y@itech-us.com
Recruiter Notice:
To remove this job posting, please send an email from
an.y@itech-us.com with the subject:
DELETE_JOB_ID_8748