CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

DE&A - GWDM - Guidewire Data Management

Zensar Technologies

Full time On-site
Location
Pune
Work mode
On-site
Salary
₹15L – ₹25L a year estimatetypical for IT Jobs in Pune, 56 posts
Posted 22 days ago

Free · takes a minute · your resume fills your profile

CoreHRx never asks candidates for money. If anyone does, .

How well do your skills match this job?

Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.

Job description

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.



Key skills

Preferred

ETL

Tags

Job market insights

₹15L – ₹25L advertised yearly salary for IT Jobs in Pune (middle half of 56 posts that show a salary; median ₹19L)
78 more open jobs at Zensar Technologies

Most IT Jobs posts in Pune ask for 3–6 years of experience (43% of 910 that say).

Hiring most for IT Jobs in Pune

  • T-Systems ICT India Pvt. Ltd.39 open jobs
  • Eaton36 open jobs
  • Capco33 open jobs

From live job posts on CoreHRx, updated 7 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.

Questions about this job

What is the salary for this DE&A - GWDM - Guidewire Data Management job?

The post does not state the pay. As an estimate, comparable posts on CoreHRx advertise ₹15L – ₹25L a year (typical for IT Jobs in Pune, 56 posts).

Where is this job based?

In Pune (on-site).

What kind of job is this?

It is a full time job.

Preparing for an IT or software developer interview in India? This guide covers the rounds companies run, the technical and HR interview questions asked most often for freshers and experienced developers, sample answers you can adapt, and a simple preparation plan.

Questions you may be asked

  1. Tell me about yourself.
  2. Explain the four pillars of object-oriented programming.
  3. What is the difference between a process and a thread?
  4. How do you find the second highest salary in SQL?

Get IT jobs in Pune by email

Create a free profile and we email you new IT jobs in Pune, at most once a week.

Similar jobs

Free · takes a minute · your resume fills your profile