Kaustav Purkayastha
Data Engineer @ Deloitte USI | Cloud & Data Platforms | AI Enablement
- Role
- Associate Analyst at Deloitte
- Location
- Hyderabad, TG, IN
- LinkedIn followers
- 500 followers
About Kaustav Purkayastha
Data Engineer at Deloitte (Financial Services, Insurance) with 3+ years building…
Experience
Associate Analyst
Oct 2023 — Present · Hyderabad, IN
Business: Technology & TransformationPortfolio: AI & Engineering → AI & DataIndustry: Financial Services → Insurance🧩 Experience SummaryDelivered a centralized data platform for a Fortune 500 insurance client’s Retail Annuities LOB—supporting analytics, regulatory reporting, and SLA-driven delivery. Reverse-engineered 500+ legacy tables and authored 100+ STTM docs for seamless integration. Built 70+ Spark-based ETL jobs in Informatica IDMC; loaded 60+ Redshift tables with 25+ years of data using ELT, CDC, SCD, and snapshot logic. Created 50+ parameterized Redshift views enabling scalable analytics and downstream use. Designed reusable parameter sets, reducing config overhead across 30+ pipelines. Assisted data ingestion via AWS Glue into raw layer; transformed using Redshift pipelines; orchestrated via Stonebranch. Used Aurora (audit/config), EC2 (param files), and S3 (file ingestion, job triggers). Integrated Claude + Amazon Bedrock to optimize jobs and halve dev time—cutting compute costs. Unified Annuity and Life models by resolving schema, mapping, and master data conflicts. Owned patching, metadata lineage, QA handoffs, and decoding complex business rules. Awards & Recognition Outstanding Performance Award (Q1 FY25) Mr. Dependable – USI S&A Newsletter (May 2025) Applause Award – Delivery Excellence (Jul 2024) Rising Star – Top Campus Hire (FY24)
Education
South Point High School, Silchar
HSLC
2010 — 2018
Gurucharan College, Silchar
Bachelor of Science - B.Sc.
2020 — 2023
Ramanuj Gupta Junior College, Silchar
Higher Secondary
2018 — 2020
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.