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

(2024-01)

• 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

(2020-06 - 2023-12)

• 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

(2009-04 - 2020-03)

• 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