About this role
Data Extraction
•
Analyse and understand legacy mainframe claims data structures and relationships.
•
Design and implement repeatable, auditable data extraction processes.
•
Extract mainframe data into flat-file formats and securely transfer datasets via SFTP for downstream processing.
•
Identify data dependencies, historical data requirements, and migration scope boundaries.
Data Transformation
•
Design and develop ETL transformation processes aligned to Guidewire target-state data requirements.
•
Define and implement data mapping, conversion rules, and business transformation logic.
•
Perform data cleansing, standardisation, enrichment, and validation activities.
•
Identify, manage, and resolve data quality issues throughout migration cycles.
Data Loading
•
Develop, execute, and optimise data load processes into Guidewire and associated target platforms.
•
Support multiple migration rehearsals, and production migration events.
•
Optimise ETL processes for performance ensuring processes are scalable, efficient, and reliable.
•
Deliver migration activities in line with agreed cutover and deployment timelines.
Data Quality and Reconciliation
•
Design and implement automated reconciliation and validation controls.
•
Develop exception reporting and migration monitoring dashboards.
•
Investigate, analyse, and resolve data discrepancies and reconciliation variances.
•
Support business validation, data verification, and migration sign-off activities.
Testing and Migration Support
•
Support system, integration, user acceptance, and migration testing activities.
•
Troubleshoot ETL defects, data issues, and migration failures.
•
Provide production cutover and post-migration support to ensure a stable transition.
Documentation and Governance
•
Produce and maintain ETL design documentation, technical specifications, and operational procedures.
•
Maintain comprehensive source-to-target mapping and data lineage documentation.
•
Ensure compliance with Santam governance, security, risk, and audit requirements.
•
Adhere to migration standards, controls, and best practices throughout the programme
Preferred Experience
•
Proven experience delivering large-scale data migration and ETL initiatives.
•
Strong understanding of insurance data domains particularly Claims and Policy administration.
•
Hands-on experience with Guidewire data migration, integration, and data conversion activities.
•
Experience working with legacy mainframe environments, flat-file processing, and secure data transfer mechanisms.
•
Strong analytical, troubleshooting, and stakeholder engagement skills.