Sanjay B
ETL Developer Business Analyst
Kompetenzen
Meine Dienstleistungen

Portfolio
Arbeitserfahrung
Data Business Analyst and ETL developer
PwC • Vollzeit
May 2025 - Present • 1 yr
• Working as a Business Analyst and ETL Developer on a Guidewire DataHub and InfoCenter program, transforming legacy P&C insurance data to align with the Guidewire data model using Snowflake and Azure Databricks. • Gathering business requirements from stakeholders and translating them into detailed data specifications (SCD Type 1/2, PublicID, BeanVersion, Retired flags) for developer and QA consumption. • Designing and executing data transformation logic across Policy Center, Billing Center, and Claims Center domains — mapping legacy source structures to Guidewire ODS and IC layers.
Analyst
EY • Vollzeit
Apr 2023 - Apr 2025 • 2 yrs
Developed and maintained ETL pipelines using SAP BODS and Guidewire DHIC framework (Policy Center, Billing Center, Claims Center) for P&C insurance clients, supporting end-to-end data flows from source to reporting layer. Designed SQL-based transformations and data validation routines for insurance data warehouse pipelines, ensuring accuracy for actuarial, finance, and compliance reporting. Worked within the Guidewire DataHub and InfoCenter ecosystem.
ETL Developer
Tata Consultancy Services • Vollzeit
Jan 2021 - Apr 2023 • 2 yrs 3 mos
Developed and maintained ETL pipelines using Oracle SQL and PL/SQL, supporting data extraction, transformation, and loading for BFSI clients including Silicon Valley Bank. Designed and debugged new and existing ETL workflows, resolving data quality issues and ensuring consistent data delivery to downstream reporting systems. Worked on data validation, unit testing, and defect resolution across multiple project deliverables within tight deadlines.