DEandA - GWDM - Guidewire Data Management

Zensar Technologies; Pune District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Zensar Technologies recruits for a Data Migration Specialist to drive end-to-end data extraction, transformation, loading, and governance for large-scale insurance data migration projects. You will work with legacy mainframe data, Guidewire targets, and secure data transfers via SFTP, ensuring quality and traceability.

You will design repeatable ETL processes, map data rules, enable validation, and support cutover activities across migrations.

Qualifications

• 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.

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.
• 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

Skills

ETL development

Data migration

Guidewire

Mainframe data

Data quality

SFTP transfer

Stakeholder engagement

Tools

Guidewire

ETL tools

Job description

Job Description:

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

Responsibilities

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

Qualifications

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.

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: “Together, we shape experiences for better futures”. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is “ONE with Client” - a set of four core values that reflect who we are and how we work: “One Zensar, Nurturing, Empowering, and Client Focus”.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensarand join us to Grow. Own. Achieve. Learn.to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.