test engineer

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