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
2023.04 - 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
2021.04 - 2023.04
  • 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
2020.02 - 2021.04

Ilabz Technology
2018.10 - 2020.02

Teradata India
2017.05 - 2018.10

Capgemini
2014.07 - 2017.05

Education

B.E - Computer Science

Dayananda Sagar College of Engineering
Bangalore
2014-06

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
2023.04 - Current

Team Lead

Publicis Sapient
2021.04 - 2023.04

Incedo Technology
2020.02 - 2021.04

Ilabz Technology
2018.10 - 2020.02

Teradata India
2017.05 - 2018.10

Capgemini
2014.07 - 2017.05

B.E - Computer Science

Dayananda Sagar College of Engineering
Abhinav Roy