About

Ankur Garg is a committed and highly focused professional with around 9+ years of IT experience. He is currently working as a Sr. AWS Data Engineer at Amazon, where he has participated in business meetings to understand the business needs and developed source to target data mapping and data transformation rules to support ETL process using Python-Spark. He has also created scripts for data quality using AWS EMR job and provided regulatory data to BA/higher management for analysis purposes. Ankur is proficient in writing DDL and DML statements as per the requirement and creating real-time dashboards using AWS Kinesis, Glue, Athena, and QuickSight. Prior to Amazon, Ankur worked as a Manager at Citibank, where he developed source to target data mapping and data transformation rules to support ETL process using Python-Spark and created various statistical models such as linear regression and sentiment analysis. He also scheduled jobs in SQL Management Tool/Autosys, monitored daily ETL, and handled L1 support team. Ankur has experience in writing DDL and DML statements as per the requirement and taking care of release-related activities. Ankur has also worked as a System Integration Senior Analyst at Dell, where he developed source to target data mapping and data transformation rules to support ETL process using SSIS/Talend. He created pre-data processing jobs in Python for data cleaning/data encoding and feature selection, scheduled jobs in SQL Management Tool, and developed/troubleshoot SQL table, views, and T-SQL functions, triggers, procedures, and packages. Ankur holds a B.Tech degree in Computer Science Engineering from Guru Gobind Singh Indraprastha University and Maharaja Agrasen Institute of Technology. He is proficient in AWS, SQL, Spark, Data Engineering, ETL, Python, Hadoop, Amazon Athena, Apache Hive, ML, AWS Glue, Sentiment Analysis, NoSQL, MSSQL, Neo4j, and Big Data. Ankur has a relevant experience of 12.87 years.