Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
AMAN KUMAR

AMAN KUMAR

New Delhi

Summary

Experienced ETL Developer with 5.3 years in IT, specializing in SAP BODS, Data Analysis, and AWS Data Engineering. Certified Microsoft Azure data engineer proficient in SQL, Python, Azure, Databricks, and Data Lineage. Skilled in data extraction, transformation, and loading, with expertise in workflow development and transformation techniques. Proficient in ingesting legacy on-premise data into the cloud using ETL tools, Autosys, and Databricks jobs. Experienced in creating custom Databricks notebooks for data processing. Knowledgeable in Git, AWS Lambda, and Step Functions. Exceptional communicator and team player with strong analytical and problem-solving abilities.

Overview

5
5
years of professional experience

Work History

AWS Data Engineer

Deloitte
Gurgaon
01.2022 - Current
  • Experienced in Data modernization project to move data from on premises to cloud, repoint all existing process to cloud
  • Developed and managed data pipelines for ingesting, storing, processing, and analyzing large datasets in AWS S3 buckets
  • Implemented automated monitoring of data flows using CloudWatch and Lambda functions
  • Proficient in a wide range of AWS services including S3, Lambda, Kinesis, Athena, EC2, Glue, DynamoDB, SQS, SNS, EventBridge, and Step Functions
  • Demonstrated expertise in Delta Lake concepts for data storage and Databricks for processing
  • Skilled in Python and PySpark coding for data manipulation and analysis
  • Hands-on experience creating AWS resources using Terraform and deploying them via Jenkins pipelines
  • Expertise in writing Databricks code to flatten various file types
  • Optimized data workflows and processing scripts, resulting in a 20% reduction in data retrieval times
  • Validation of the data across all the layers from source to target ingestion using Athena or Databricks
  • Created multiple automation scripts for post-ingestion data validation in the cloud.

ETL Developer

Deloitte USI
12.2019 - 01.2022
  • Currently working on BOM & Trade ETL pods for different segments
  • End-to-End experience in working more than 3 development cycle (POD)
  • Worked in the data augmentation team as ETL and automation developer for data migration to Veritas system and BOM (Bill of Material) Analysis report generation of the Food and Petcare Nutrition deployment for Asia and North America Region for Mars Inc
  • Involved in gathering business requirements, functional requirements, and data specifications
  • Involved in Creation of jobs that specify data mappings and transformations by using Data Services Designer
  • Used designer to load data from different sources (SQL, Text files) to the target database
  • Improved the performance and reduced the coding with the use of @functions and variables
  • Worked with various transforms such as SQL, Table comparison, Row Generation, Query, Map Operation, Merge, Look Ups, Pivot, Case etc.

Data Analyst

Deloitte USI
03.2019 - 11.2019
  • Analyzed large datasets to identify trends, patterns and correlations for business insights
  • Navigating complex systems and creating profiling and mapping documents
  • Communicating with the source system team to address any questions or concerns about the data
  • Writing and evaluating SQL scripts for the data ingestion team post-profiling of the on-premises system
  • Validation of the data across all the layers from source to target ingestion using Python and Databricks
  • Automation for client-provided data validation and profiling rules using python or spark.

Education

B.E (Computer Science) -

RGPV

12th -

B.S.E.B

10th -

B.S.E.B

Skills

  • SAP Bods
  • SQL
  • Python
  • Pyspark
  • AWS services (S3, Lambda, Kinesis, Athena, EC2, DynamoDB, SQS, SNS, Eventbridge, Step Function etc)
  • Microsoft Azure
  • Databricks
  • Git

Accomplishments

  • Received a Spot Award in recognition of exceeding expectations by successfully managing migration and data loads despite numerous challenges.
  • Received an Applause Award for completing all template conversions within the allotted time frame.
  • Received an Applause Award for independently navigating a complex system and achieving successful data migration to AWS S3.

Timeline

AWS Data Engineer

Deloitte
01.2022 - Current

ETL Developer

Deloitte USI
12.2019 - 01.2022

Data Analyst

Deloitte USI
03.2019 - 11.2019

B.E (Computer Science) -

RGPV

12th -

B.S.E.B

10th -

B.S.E.B

Similar Profiles

CREATE PROFILE
AMAN KUMAR