ETL Test Lead with strong expertise in Guidewire insurance systems and Snowflake cloud data warehouse, ensuring high-quality data validation and delivery
<p>Oversee data integrity across multiple data flows in a Snowflake environment.<br>
Identify and resolve discrepancies.<br>
Ensure accurate migration through comprehensive test scenario design.<br>
Perform data validation and verification of all key data elements.<br>
Write and execute complex SQL queries to validate source-to-target mappings.<br>
Support data quality assurance.<br>
Validate data against source-to-target mappings and transformation rules.<br>
Perform metadata checks, including data types, lengths, indexes, and constraints.<br>
Execute regression, functional, and end-to-end testing for Guidewire ClaimCenter and related data flows.<br>
Create and run SQL test cases.<br>
Log defects and coordinate defect triage with development teams.<br>
Develop business-level test scenarios to ensure data quality and accuracy across systems.</p>
Core Responsblity: Validate data against source-to-target mappings and transformation rules. Perform metadata checks, including data types, lengths, indexes, and constraints. Execute regression, functional, and end-to-end testing for Guidewire ClaimCenter and related data flows. Create and run SQL test cases, log defects, and coordinate defect triage with development teams. Develop business-level test scenarios to ensure data quality and accuracy across systems.
<p>Data Integration Program for a leading Canadian bank, migrating the legacy DB2 and SSIS-based integration system to Netezza through a lift-and-shift approach.<br>
Enabling improved performance and ensuring zero disruption to critical banking operations.<br>
Perform format level validation for output files or database tables, including checking file name, file extension, column names, column format, column count, and record count.<br>
Perform unit testing and integration testing for all impacted modules.</p>
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
