Ankit Tambe

About Ankit Tambe

I’m a Data Engineer with 5+ years of hands-on experience, crafting scalable, efficient…

Experience

1. Data Engineer

   TO THE NEW

   Sep 2022 — Present · Noida, IN

   Working with the Customer Data Platform (CDP) team of a global leader in medical devices, microscopy, and optics. I drive end-to-end Data Engineering and Adobe Experience Platform (AEP) integration to support personalised marketing and customer intelligence across business units.Data Engineering & Pipelines• Built Synapse Spark and Databricks pipelines to extract, flatten, and transform unstructured MongoDB and ADLS Gen2 JSON data for ingestion• Created SQL views in Synapse and custom JSON restructures to align with AEP schema requirements• Developed pre-ingestion extractors to flatten complex JSONs for feasibility checks and EDA• Enabled automated ingestion via AEP’s Synapse and Data Lake connectorsCloud Integrations & Streaming• Set up AEP HTTP API connector for real-time ingestion from Rudderstack• Aligned schema and cadence for daily ingestion via ADLS Gen2Ingestion Monitoring & Automation• Built Python-based monitoring to extract batch-level stats from AEP APIs• Identified row/batch errors, stored outputs in ADLS, and visualized via Power BI• Automated via ADF and Key Vault, reducing troubleshooting time by 90%• Adopted by 3 BUs, 8 source teams, and CDP ops for ongoing monitoringSchema Management & Data Distillers• Maintained and evolved AEP XDM schemas across multiple data sources• Built SQL-based AEP Distillers to support audience segmentation and activationEDA & Use Case Validation• Evaluated source relevance via EDA—assessing profile enrichment, cadence, connector support, and schema gapsCampaign Support & Stakeholder Enablement• Liaised with 6 business teams to translate campaign goals into data requirements• Onboarded new sources, analysed sample data, resolved ingestion issues, and supported 8 total campaigns (3 completed, 5 active)Collaboration & Mentorship• Worked with teams across India and Germany; contributed to architectural decisions• Delivered 5+ training sessions on Azure DE tooling and AEP best practices

Education

• K J Somaiya College of Engineering Vidyanagar Campus Vidyavihar Mumbai-400 077

  Bachelor of Engineering (B.E.), Information Technology

  2011 — 2015

• Department of Management Sciences (PUMBA), Savitribai Phule Pune University

  Master of Business Administration - MBA, Marketing

  2017 — 2019

• St. Pius X High School

  SSC, Secondary Education

  2009

• International Institute of Information Technology Bangalore

  Executive Post Graduate Programme in Data Science , Data Science