Role Overview An opportunity to join a major enterprise organisation undergoing a large-scale system transformation to assure the quality, accuracy, and integrity of critical data as it migrates from legacy environments into modern target platforms. In this technical, hands-on role, you will design migration test strategies, validate complex source-to-target data transformations, reconcile high-volume data sets, and collaborate across Agile delivery teams to drive business readiness.
Key Criteria
- 5+ years of dedicated data migration QA testing experience on large-scale transformation programs (Insurance industry experience strongly preferred).
- 5+ years of expert-level SQL querying skills and hands-on experience with PostgreSQL, including translating business requirements into complex SQL query statements.
- 5+ years of experience in defect investigation, code triage, and root cause analysis of data discrepancies.
- 2+ years of hands-on experience working with Guidewire platforms.
- 2+ years of experience operating within Agile delivery methodologies and utilizing Jira.
- Technical expertise setting up DevOps automation pipelines using tools such as Jenkins and GitHub.
- Strong background in database schema interpretation, count validation, and duplicate testing across high-volume data environments.
Key Relationships
- QA Leads & Delivery Managers
- Business Analysts & System Developers
- Subject Matter Experts (SMEs) & Agile Delivery Squads
Key Responsibilities
- Analyze business requirements, mapping documentation, and database schemas to construct comprehensive test coverage for data migration initiatives.
- Design, build, and maintain robust migration test scripts and validation routines.
- Execute end-to-end source-to-target data validation, count checks, and duplicate reconciliation across core data layers.
- Triage, investigate, and manage technical defects to resolution using expert SQL and PostgreSQL.
- Partner with Developers and Business Analysts to resolve data transformation issues and clarify operational rules.
- Support technical automation efforts within DevOps frameworks using tools like Jenkins and GitHub.
- Produce quality assurance reporting to track data quality risks, testing metrics, and final business readiness.
If this sounds like you, someone you know, or you're ready for a confidential chat regarding your next career step, then apply below and/or send your email to nick.shannon@randstaddigital.com.au. All applications will be reviewed, however due to large demand, detailed feedback may not always be possible.
experience
5 years