Omkar Deshpande

Data engineer II at Deloitte

Role
Data Engineer Ii at Deloitte
Location
Pune Division, MH, IN
LinkedIn followers
500 followers
Information TechnologyView LinkedIn profile

About Omkar Deshpande

Senior Data Modeler and Snowflake Data Engineer with 7 years of experience designing and delivering robust cloud data warehouse solutions for large-scale enterprise environments. Currently at Deloitte USI, architecting Data Vault 2.0 (DV 2.0) frameworks for Fortune 100 manufacturing clients to enable scalable, auditable, and high-performance analytics.Proven expertise in conceptual, logical, and physical data modeling, with hands-on experience architecting Snowflake-based data warehouses that enable scalable analytics, robust reporting, and seamless downstream data consumption. Demonstrated strengths in enterprise data modeling, data integration, data quality, and performance optimization.Hands-on experience across the full data lifecycle:• Data Vault 2.0 modeling (Hubs, Links, Satellites)• Dimensional modeling (Facts & Dimensions)• Snowflake schema design, DDL generation, and optimization• Source-to-target mappings, data profiling, and gap analysis• ETL / ELT pipelines using Apache NiFi and Ab Initio• Cloud data platforms: Snowflake, Azure ADLS Gen2• Modeling tools: Erwin Data Modeler• SCD Type 2, PL/SQL, and legacy-to-cloud migrationsPreviously at Amdocs, led and mentored engineers while designing Snowflake schemas, migrating high-volume data pipelines to Azure Data Lake, and improving query performance and scalability in cloud DWH environments.Recognized with an Applause Award for contributions across multiple workstreams. Known for bridging the gap between business requirements and technical data architecture, and for delivering clean, extensible, analytics-ready data models.Keywords:Snowflake | Data Vault 2.0 | DV 2.0 | Cloud Data Warehouse | Data Modeling | Enterprise Data Architecture | Dimensional Modeling | ETL | ELT | Azure Data Lake | Apache NiFi | Ab Initio | Erwin | Data Quality | SCD2 | Agile

Experience

  1. Data Engineer Ii

    Deloitte

    Jun 2026 — Present · Pune District, IN

Education

  • Karmel Vidya Bhavan Trust CHRIST College, Pune, Arts Science and Commerce College, Vadgaon Sheri, Pune 14

    Bachelor of Computer Applications (B.C.A), Computer Science

    2012 — 2015

  • Pimpri Chinchwad Education Trust'S. Pimpri Chinchwad College Of Engineering

    Master of Computer Applications (M.C.A.), Computer Science

    2015 — 2018

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.

Omkar Deshpande — Data Engineer Ii at Deloitte in Pune Division, MH, IN | Unifers