Piyush Agarwal

Data Engineer

Bengaluru, Karnataka, India6 yrs 6 mos experience
AI EnabledAI ML Practitioner

Key Highlights

  • Redesigned 25+ legacy procedures into Spark pipelines.
  • Built AI-powered analytics reducing ad-hoc effort by 50%.
  • Contributed to projects driving $300M+ business impact.
Stackforce AI infers this person is a Data Engineering expert with a strong focus on AI-driven analytics in the SaaS industry.

Contact

Skills

Core Skills

Data EngineeringCloud ComputingAiBig DataBusiness IntelligenceData MigrationData Analysis

Other Skills

Azure DatabricksPySparkDelta LakeData GovernanceCI/CDGitHub ActionsNL2SQLStatistical Insight PipelinesPythonAzureTeradataETLData QualityData ModelingDataIKU

About

🚀 Senior Data Engineer | Azure | Databricks | Big Data | AI-Driven Analytics I build scalable, enterprise-grade data platforms that transform complex data into real-time, decision-ready insights. With 6.5+ years of experience across Adobe, EY, and TCS, I specialize in designing modern data architectures, distributed pipelines, and cloud-native analytics systems. 💡 What I Bring: • End-to-end Data Engineering (Ingestion → Transformation → Serving) • Scalable ETL/ELT pipelines using PySpark, SQL, Airflow • Cloud expertise: Azure (ADF, ADLS, Databricks, Delta Lake) & GCP • Real-time & batch processing using Kafka & Spark • Dimensional modeling & performance optimization 📈 Impact Highlights: • Redesigned 25+ legacy procedures into Spark pipelines → ⚡ 35% performance boost • Reduced SLA breaches by 40% through automated orchestration • Built AI-powered analytics (NL2SQL + anomaly detection) → 📊 50% reduction in ad-hoc effort • Delivered systems supporting multi-region enterprise reporting • Contributed to projects driving $300M+ business impact 🏢 Currently at Adobe, building Sales Operations Data Platforms with a focus on scalability, governance, and AI-driven insights. 🌐 Portfolio: https://piyush-agarwal-portfolio.netlify.app/ 🎯 I’m passionate about pushing the boundaries of Data Engineering by integrating AI, automation, and modern data stack technologies. 💼 Open to opportunities in Senior Data Engineering, Data Platform, and AI/Data roles.

Experience

6 yrs 6 mos
Total Experience
1 yr 9 mos
Average Tenure
1 yr
Current Experience

Adobe

Data Engineer

May 2025Present · 1 yr · Bengaluru · Hybrid

  • Architected and delivered a scalable Sales Operations data warehouse on Azure Databricks (PySpark, Delta Lake), redesigning 25+ legacy stored procedures into distributed Spark pipelines and dimensional data models, improving performance by 35%.
  • Implemented enterprise-grade data governance and CI/CD framework using Unity Catalog and GitHub Actions, enabling secure Dev-QA-Prod deployments and ensuring audit-compliant reporting.
  • Engineered an AI-enabled self-service analytics framework leveraging NL2SQL and automated statistical insight pipelines (trend, variance, anomaly detection), reducing ad-hoc reporting effort by 50%.
Azure DatabricksPySparkDelta LakeData GovernanceCI/CDGitHub Actions+4

Ey

Data Engineer

Jul 2024May 2025 · 10 mos · Bengaluru, Karnataka, India · Hybrid

  • Designed and implemented large-scale data models and Big Data pipelines for eCommerce finance using Azure, Python, PySpark, and Teradata.
  • Optimized ETL workflows to ingest data from diverse sources into Databricks using Azure services.
  • Automated data quality checks with Python scripts, saving 15+ hours per week and enhancing data accuracy.
AzurePythonPySparkTeradataETLData Quality+3

Tata consultancy services

2 roles

Data Engineer

Promoted

Jul 2023Jul 2024 · 1 yr · Bengaluru, Karnataka, India

  • Led the Market Price as Service (MPS) project, saving 120+ hours and generating $300M annual revenue using DataIKU, SQL, Python, and PySpark.
  • Managed the Click2Camping (C2C) project, optimizing pricing and customer discount strategies through over 100 conditions using DataIKU, SQL, and Python.
  • Implemented Apache Airflow to automate and monitor ETL workflows, improving data pipeline reliability and efficiency.
DataIKUSQLPythonPySparkETLPricing Optimization+2

System Engineer

Aug 2022Jun 2023 · 10 mos · Bengaluru, Karnataka, India

  • Spearheaded the migration of Informatica PowerCenter to Informatica Intelligent Cloud Services, optimizing performance and scalability.
  • Conducted pre-migration analysis to identify challenges and ensure a smooth transition to cloud infrastructure.
  • Designed post-migration validation strategies using SQL and Unix scripts to automate data pipeline testing, ensuring data accuracy.
Informatica PowerCenterSQLUnixData MigrationData Engineering

Capgemini

3 roles

Associate Consultant

Sep 2021Jul 2022 · 10 mos

  • Collaborated with stakeholders to align technical solutions with strategic goals, enhancing data pipeline efficiency.
  • Resolved critical production issues in Data Warehouse environments, ensuring high-quality reporting in MicroStrategy.
  • Introduced data validation methodologies, reducing error rates by 15% through automated processes.
Data WarehousingMicroStrategyData ValidationData AnalysisData EngineeringBusiness Intelligence

Senior Analyst

Promoted

Sep 2020Sep 2021 · 1 yr

  • Resolved critical production issues and provided technical solutions for application and batch job-related problems.
  • Pioneered process improvement initiatives for development, deployment, and application monitoring, driving efficiency gains and performance enhancements.
  • Managed full project lifecycle, including service level agreement (SLA) definitions, ITIL process implementation, and cross-functional team coordination to meet organizational standards.
Data WarehousingAppDynamicsBusiness IntelligenceData Engineering

Analyst

Sep 2019Sep 2020 · 1 yr

  • Conducted comprehensive data analysis on flat files, defining precise data requirements for seamless system integration.
  • Designed and implemented ETL workflows using SQL for efficient data extraction from multiple databases.
  • Applied performance optimization techniques to ETL processes, improving data loading efficiency and query execution times.
Data AnalysisETLSQLData Engineering

Bharat heavy electricals limited

Computerized numerical controlled machine

May 2018Jun 2018 · 1 mo · Haridwar, Uttarakhand, India

Bharat sanchar nigam limited

Broadband

May 2017Jun 2017 · 1 mo · Bareilly, Uttar Pradesh, India

Education

DIT UNIVERSITY

Bachelor of Technology - BTech

Jul 2015Jun 2019

ST. Francis Convent Sr. Sec. School, Bareilly, UP

Higher Secondary Certificate — PCM

Apr 2014May 2015

ST. Francis Convent Sr. Sec. School, Bareilly, UP

Secondary School Certificate

Apr 2012Mar 2013

Stackforce found 100+ more professionals with Data Engineering & Cloud Computing

Explore similar profiles based on matching skills and experience