Test Engineer

Randstad; City of Melbourne; Hybrid; AUD 110,000 - 170,000; Full time

Job summary

Randstad is seeking a Test Engineer (Guidewire) in Melbourne for a contract role (Full-Time) with 50% in-office, 50% WFH. The position sits within a large enterprise data-migration program and focuses on validating migrations across source and target systems.

We expect 5+ years in data migration QA testing (insurance preferred), strong SQL/PostgreSQL skills, and 2+ years with Guidewire plus Agile/Jira and DevOps tooling (Jenkins, GitHub).

Qualifications

• 5+ years of dedicated data migration QA testing experience on large-scale transformations.
• 5+ years of expert SQL querying with PostgreSQL for complex data validation.
• 5+ years of defect investigation, code triage and root cause analysis of data discrepancies.
• 2+ years of hands-on Guidewire experience.
• 2+ years working in Agile delivery and Jira.

Responsibilities

• Analyze requirements, mapping docs and schemas to create test coverage for data migration.
• Design, build, and maintain robust migration test scripts and validation routines.
• Execute end-to-end source-to-target data validation with count checks and duplicates.
• Triage and resolve defects using expert SQL and PostgreSQL skills.
• Collaborate with Developers and BAs to resolve data transformation issues.
• Support DevOps automation efforts with Jenkins and GitHub.
• Produce QA reporting on data quality risks, metrics, and business readiness.

Skills

SQL

PostgreSQL

Defect investigation

Root cause analysis

Agile delivery

Jira

DevOps automation

Jenkins

GitHub

Data migration

Guidewire

Tools

Jenkins

GitHub

Jira

Job description

Test Engineer (Guidewire)
Location: Melbourne
Employment Type: Contract (Full-Time) | 50% in-office, 50% WFH
Contract Length: June 30th, 2027 initial (Likely 6-12 month extension)

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.

All applications will be reviewed, however due to large demand, detailed feedback may not always be possible.