Working in a Multinational Company as Data Engineer for last 3 years with total experience of 6 years including various technology stack including Apache Hadoop,Spark,Kafka,Java,Scala etc.

Key Skills

HDFS
Spark
Kafka
Sqoop
Impala
Hive
Oozie
Scala
Java
AWS S3,EC2,Glue,Redshift
Kerberos

Professional Experience

Aug 2018
Present
Data Engineer
Tata Consultancy services Kolkata, IN
• Developed a Data Flow in spark using Scala that process application logs in batch mode and referenced to reconcile with the production data.
• Scheduled Spark job using oozie, developed workflow modeling to control data process flow .
• Extensively worked with team to tune the spark job ,Troubleshoot  errors using Resource Manager,Hue,Autosys log and Fix them
• Developed around 100 Sqoop import and export jobs for extracting data from Oracle, SQL server, Netezza, MySQL into HDFS and populating in impala tables and vice versa.
• Working on a POC which involves Kafka Data streaming of frequent transnational data which will be saved into hdfs in batch mode as well as update of infrequent row in real time . We are working on kafka consumer to receive and store the data.
• Implemented Kerberos authentication to secure the cluster. Added token based authentication in existing module to get connection with impala and other DB from hdfs .
• Worked in a project which involves data migration for specific views of impala to AWS redshift. As there is no direct AWS Glue connectivity we developed Jobs which first copy data from hdfs to s3 and s3 to Redshift via AWS glue job.
• Worked in various AWS service like,athena,EC2,EMR etc

Feb 2015
Sep 2018
Web Developer
Tata Consultancy services Mumbai, IN
• Developed several screen based on the customer requirement such as showing available dates for movie release in a specific zone, Calculating artists expenses of a movie using UI App, Calculating logic for CD,DVD packaging etc 
• Worked in digital release of webseries deciding air Date by creating UI which calculate the premier date also suitable vendor in specific region etc.
• Also worked in few oracle procs to implement business logic .
• Key technology here is j2ee/Adobe Flex/Rest/PlSQL

Education

May 2010
Sep 2014
Btech in Supreme Knowledge of Foundation
WBUT

Certifications

2020
AWS cloud Practitioner
Amazon

Achievements

2020
Award Received ‘Technical Excellence award’
Achieved this award for extensive contribution for an ongoing project by providing innovative ideas and resolving critical issues which were impacting revenue for long time.  

Quote

"Stay hungry stay foolish"

steve jobs

Languages

English
(Fluent)
HINDI
(Fluent)
Bengali
(Native)

Get in touch with Ankur