Amit Kumar

Results-driven Data Engineer with 10+ years of experience across Retail and Analytics domains, including 5+ years in Big Data & Cloud (Azure). Strong expertise in designing scalable ETL/ELT pipelines, processing large datasets using PySpark & Spark SQL, and delivering analytics-ready data for business intelligence. Proven ability to automate reporting, optimize performance, and collaborate with cross-functional teams.

Data Engineer – Retail Industry

Ekmatra LLP | Noida Jan 2024 – Present

Designed and maintained scalable ETL pipelines using PySpark on Azure, processing high-volume retail sales, inventory, and customer data.

- Developed data ingestion workflows in Azure Data Factory from POS, inventory, and billing systems.

- Performed complex transformations, joins, and aggregations using Spark SQL & SQL for daily, weekly, and monthly reporting.

- Managed curated datasets in Azure Data Lake and Azure SQL Database for analytics consumption.

- Automated sales, stock, and dealer performance reports, significantly reducing manual effort and improving data accuracy.

Big Data Analyst – Retail Industry KSS Syntax Private Ltd | Gurgaon Jun 2020 – Dec 2023

Built and optimized PySpark-based ETL pipelines on Azure for large-scale retail datasets. - Implemented ADF pipelines for reliable and scheduled data ingestion from multiple source systems. - Optimized Spark jobs to improve performance and reduce processing time. - Supported business users with accurate and timely dashboards by delivering analytics-ready datasets.

MIS Executive Sarvoday Ashram (Khadi) | Etah Apr 2009 – March 2020

Cleaned, validated, and analyzed sales, stock, and SKU-level data. - Automated Excel-based MIS reports for sales forecasting, billing, and dealer performance. - Collaborated with sales, supply chain, and warehouse teams to support data-driven decisions. - Streamlined weekly and monthly reporting processes, improving efficiency and accuracy.

Bachelor of Science (Mathematics) Dr. B.R. Ambedkar University, Agra