DE&A - GWDM - Guidewire Data Management
Pune · Mid Level
Applicants who checked fit first are 3.1× more likely to hear back
Your score for this role already exists
ASAI compared this JD against 41 signals - skills, seniority, domain, stack overlap etc. Add a resume and it unlocks in about 30 seconds.
Always free · no credit card · 1 tap with Google
What we know about this role
LOW
Our tracked job listings for fa-etvl-saasfaprod1-cx1 show limited recent activity.
First 72 hours
Still inside it - posted 1d agoEarly applicants get seen before the pile builds.
Not a repost
The first time we've seen this listing - it hasn't been closed and reopened.
Skills required
15 listedYou almost certainly match several of these already. Unlock your skill map to see the matches, the gaps, and what to fix first.
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
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.
Tools to land this role
PremiumYour match score, skill map and tracker stay free.
Ground Reality
PremiumSpot the dealbreakers in this 596-word post before you apply
Skip jobs with hidden dealbreakers. See what they actually need, what's easy to miss, and how they describe the team.
Ground Reality on every job, plus Insider Path, practice interviews and resume tailoring.
Insider Path
PremiumFind someone who can refer you here
We help you find people there who worked or studied where you did, and draft your first message and follow-up.
Free · no signup
Get tomorrow's jobs before you have to search
Daily job drops, skill trends and free resources - posted straight to the group. Leave any time.
No spam. Just jobs and resources.
Why people use ASAI
Someone shared one job with you. ASAI keeps finding the rest.
Scored, not searched. Every role ranked against your actual profile.
Alerts as often as hourly. Reach new roles while the pile is still small.
Skill gaps, spelled out. See exactly which requirements you don't meet yet.
Verified jobs, only. Say no to ghost jobs. Your time deserves respect.
More Data Engineer roles in Pune
See all
Keep browsing