Summary
Overview
Work History
Education
Skills
Personal Information
Languages
Timeline
Generic
Abhinav Roy

Abhinav Roy

Gurgaon

Summary

Seasoned Senior Data Engineer with background in developing, testing, and maintaining data architectures. Possess strong skills in database management systems, Big Data processing frameworks, data modeling and warehousing. Have successfully led teams in creating innovative data solutions to improve system efficiency and business decision-making processes. Demonstrated impact through enhanced data availability and accuracy in previous roles.

Overview

11
11
years of professional experience

Work History

Team Lead/Architect

Fractal Analytics
Gurgaon
04.2023 - Current
  • Understanding the requirement documents from the business.
  • Coordinating with onshore partners to understand the requirements and ensure continuous delivery.
  • Drafting the final BRD after multiple requirements-gathering calls.
  • Creating a design for the ingestion framework, with details of services, scripts, etc.
  • Writing complex Python scripts in AWS Lambda and AWS Glue for cloud data integration.
  • Creating complex snowflake procedures to load historical data from an external stage.
  • Assist the developers in achieving the requirement.
  • Developing, unit testing, and deploying the code in UAT and Prod.
  • Post release support.
  • Dividing and consolidating the task among team.
  • Daily status call with the stakeholders.

Team Lead

Publicis Sapient
Gurgaon
04.2021 - 04.2023
  • Understanding the requirement documents from the business.
  • Coordinating with onshore partners to understand the requirements and ensure continuous delivery.
  • Creating Low-Level Design Documents.
  • Involved in converting BDM mappings into PySpark scripts.
  • Designing the code according to the existing ingestion and curation framework.
  • Developing, unit testing, and deploying the code in UAT and Prod.
  • Post-release support.
  • Dividing and consolidating the tasks among the team.
  • Daily status call with the stakeholders.

Incedo Technology
02.2020 - 04.2021

Ilabz Technology
10.2018 - 02.2020

Teradata India
05.2017 - 10.2018

Capgemini
07.2014 - 05.2017

Education

B.E - Computer Science

Dayananda Sagar College of Engineering
Bangalore
06-2014

Skills

  • SQL
  • Python
  • Spark
  • Hive
  • Snowflake(ELT)
  • AWS
  • Airflow
  • ETL solution design and implementation with Informatica and Datastage
  • RDBMS: Oracle
  • RDBMS: Teradata
  • RDBMS: DB2
  • RDBMS: SQL Server
  • PLSQL

Personal Information

Date of Birth: 05/02/92

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

Team Lead/Architect

Fractal Analytics
04.2023 - Current

Team Lead

Publicis Sapient
04.2021 - 04.2023

Incedo Technology
02.2020 - 04.2021

Ilabz Technology
10.2018 - 02.2020

Teradata India
05.2017 - 10.2018

Capgemini
07.2014 - 05.2017

B.E - Computer Science

Dayananda Sagar College of Engineering
Abhinav Roy