Job highlights
- Preferred Experience
- Proven experience delivering large-scale data migration and ETL initiatives
- 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
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.
Robust analytical, troubleshooting, and stakeholder engagement skills.
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 Disclaimer: This job posting has been aggregated from external source.
Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 DE&A - GWDM - Guidewire Data Management Professional (Pune)
🏢 Zensar
📍 Pune