Phani Raj profile photo 1 on Tal

Phani Raj

Software Engineer | P&C Insurance | Azure Data Engineering | ADF · Databricks · PySpark |

Bengaluru

11+ years of work experience

Sapiens
May 20224 yrsApr 2026

Bengaluru

• Designed and implemented scalable ETL pipelines using Azure Data Factory to ingest, transform, and load P&C insurance data (claims, policy, premium, underwriting) from diverse sources into Azure Data Lake Gen2, Azure Blob Storage, and Azure SQL DB. • Built high-performance Spark applications in Databricks using PySpark and Spark SQL, leveraging Medallion Architecture (Bronze → Silver → Gold) to process large-scale insurance datasets across Auto, Property, and Liability lines. • Engineered data integration pipelines via ADF Linked Services, Datasets, and Pipelines to consolidate data from Sapiens IDIT, Oracle DB, and REST APIs, with automated workflow scheduling through triggers. • Standardised and harmonised heterogeneous P&C insurance data from Sapiens StepWise and legacy systems, ensuring schema compliance, referential integrity, and regulatory alignment. • Designed fine-tuned SQL queries to build scalable data solutions for claims settlement reporting, loss reserving, and policy lifecycle management. • Implemented CI/CD pipelines using Azure DevOps with ARM templates and Git-based version control, automating deployments across Dev, Test, UAT, and Production environments. • Collaborated with actuaries, underwriters, and BI teams to deliver curated datasets enabling insights into loss ratios, risk exposure, claims frequency, and premium leakage. • Integrated unit testing frameworks within ADF pipelines to validate insurance data transformations, guaranteeing accuracy across ETL workflows handling sensitive policy and claims data.
Wooyoung India Pvt Ltd
Jan 20193 yrs 3 mosMar 2022

Ananthapur, Andhra Pradesh, India

Research Centre Imarat (RCI)•DRDO
Sep 20171 yrAug 2018

Greater Hyderabad Area

Defence Research and Development Laboratory (DRDL) - DRDO
Aug 20123 yrs 11 mosJun 2016

Hyderabad, Telangana, India

Phani’s AI Stack

hugging face
hugging face
langchain
langchain
langgraph
langgraph
openai
openai

Education

Lancaster University

Bachelor of Technology - BTech, Mechanical Engineering

Lancaster University

20074 yrs2011
VNR Vignana Jyothi Institute of Engineering and Technology (VNRVJIET)

M-Tech, CAD/CAM

VNR Vignana Jyothi Institute of Engineering and Technology (VNRVJIET)

20162 yrs2018

Join Phani and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Phani Raj on Tal

Headline

Software Engineer | P&C Insurance | Azure Data Engineering | ADF · Databricks · PySpark |

About

Software Engineer with 4 years of experience building data-intensive solutions in the Property & Casualty (P&C) insurance domain at Sapiens Insurance Technology. I specialise in designing and implementing scalable ETL pipelines using Azure Data Factory, Azure Databricks, and PySpark - processing large-scale insurance datasets including claims, policy, underwriting, and premium records across multiple lines of business (Auto, Property, Liability). What I do: • Build end-to-end data pipelines using ADF, Databricks & Medallion Architecture (Bronze → Silver → Gold) • Transform and harmonise complex P&C insurance data from Sapiens IDIT, Oracle DB & REST APIs • Optimise Spark applications and SQL queries for high-performance insurance analytics • Implement CI/CD pipelines via Azure DevOps across Dev / Test / UAT / Prod environments • Collaborate with actuaries, underwriters & BI teams to deliver actionable data insights Tech stack: Azure Data Factory · Azure Databricks · Azure Data Lake Gen2 · PySpark · Spark SQL · Azure Blob Storage · Azure SQL DB · Oracle DB · Python · SQL Server · REST APIs · XML/JSON · Azure DevOps · Git · Microsoft Fabric

Location

Bengaluru

AI stack

hugging face

langchain

langgraph

openai

Work experience

Software Engineer at Sapiens, May 2022 - Apr 2026 · 4 yrs, Bengaluru, • Designed and implemented scalable ETL pipelines using Azure Data Factory to ingest, transform, and load P&C insurance data (claims, policy, premium, underwriting) from diverse sources into Azure Data Lake Gen2, Azure Blob Storage, and Azure SQL DB. • Built high-performance Spark applications in Databricks using PySpark and Spark SQL, leveraging Medallion Architecture (Bronze → Silver → Gold) to process large-scale insurance datasets across Auto, Property, and Liability lines. • Engineered data integration pipelines via ADF Linked Services, Datasets, and Pipelines to consolidate data from Sapiens IDIT, Oracle DB, and REST APIs, with automated workflow scheduling through triggers. • Standardised and harmonised heterogeneous P&C insurance data from Sapiens StepWise and legacy systems, ensuring schema compliance, referential integrity, and regulatory alignment. • Designed fine-tuned SQL queries to build scalable data solutions for claims settlement reporting, loss reserving, and policy lifecycle management. • Implemented CI/CD pipelines using Azure DevOps with ARM templates and Git-based version control, automating deployments across Dev, Test, UAT, and Production environments. • Collaborated with actuaries, underwriters, and BI teams to deliver curated datasets enabling insights into loss ratios, risk exposure, claims frequency, and premium leakage. • Integrated unit testing frameworks within ADF pipelines to validate insurance data transformations, guaranteeing accuracy across ETL workflows handling sensitive policy and claims data.

Engineer at Wooyoung India Pvt Ltd, Jan 2019 - Mar 2022 · 3 yrs 3 mos, Ananthapur, Andhra Pradesh, India

Engineer at Research Centre Imarat (RCI)•DRDO, Sep 2017 - Aug 2018 · 1 yr, Greater Hyderabad Area

QA Engineer at Defence Research and Development Laboratory (DRDL) - DRDO, Aug 2012 - Jun 2016 · 3 yrs 11 mos, Hyderabad, Telangana, India

Education

Bachelor of Technology - BTech, Mechanical Engineering, Lancaster University

M-Tech, CAD/CAM, VNR Vignana Jyothi Institute of Engineering and Technology (VNRVJIET)