v
vebs_25

Vaibhav S

@vebs_25

Senior Data Migration ETL Specialist

Singapore
English, Hindi
About me
I am a Senior Data Migration & ETL Specialist with expertise in the Life Insurance domain. I have experience in leading data migration projects, designing scalable ETL pipelines, and utilizing AWS for efficient data hosting and migration. I excel in data validation, reconciliation, and cutover management.... Read more

Skills

v
vebs_25
Vaibhav S
Offline • 

See my services

Automations
I will automate your excel, alteryx, talend and database workflows
From$20 / projectMore details

Work experience

DXC_Technology

DXC Technology

Full-time • 6 yrs

Senior Application Designer

Feb 2025 - Present • 1 yr 3 mos

Leading data migration from Integral LIFE and legacy systems (CDMS, Arima, Smart Life, Hancassurance, SLAMS) to DXC Assure SaaS across Africa markets (Kenya, Uganda, Zambia). Designing scalable ETL pipelines in Talend for multi-DB environments (DB2, Oracle, MSSQL, MySQL, Postgres). Utilizing AWS (EC2, RDS, DMS, S3) for secure, efficient data hosting and migration. Executing data mapping, cleansing, and validation frameworks ensuring business rule compliance. Conduct data validation, reconciliation, and quality checks to ensure integrity and completeness post-migration. Leading cutover planning, dry-runs, and post-migration support, ensuring minimal downtime.

Senior Application Designer

Jul 2023 - Feb 2025 • 1 yr 7 mos

Led end-to-end data migration for Allianz PNB Life Insurance Philippines migrating large-scale data to DXC Assure SaaS. Developed incremental migration, CDC, and automated data quality checks using Talend. Leveraged AWS Lambda and Step Functions for orchestrating ETL workflows and validation checks. Implemented rollbacks and backup strategies for migration, risk mitigation. Tuned Talend jobs for parallel processing and partitioning significantly reducing ETL runtimes for high-volume tables. Leveraged REST integrations in Talend to fetch internal validation rules and parameters dynamically from VPMS, reducing manual dependency updates Led cutover activities ensuring minimal downtime, achieving a successful migration with 99% go-ahead and approval from business users and management committees (ManCom).

Senior Application Designer

Apr 2020 - Jun 2023 • 3 yrs 2 mos

Developed and supported IFRS, Compensation, Accounting, and Payment Hub modules on IBM AS/00 (SMART/00, LIFE/00, DB2/00). Coordinated with ETL teams to align reporting structures and data flows for financial compliance. Designed and implemented automated reporting and validation modules Dealing with bonus, commissions and allowance paid to the agents in Life Asia