Summary
Overview
Work History
Education
Skills
Timeline
Generic

Akshat Srivastava

Summary

A seasoned Data Engineering Professional with over 8 years of rich experience of hands-on expertise in ETL Development and crafting robust Data Engineering Solutions. Proficient in a spectrum of technologies including Informatica PowerCenter, Pyspark, SQL, and Unix .

- Experience in independently leading and managing data engineering projects and building innovating solutions for complex problems

- Possess a rich exposure in Big Data, Hive, Amazon Redshift, Dataiku.

- Having exposure in Life Sciences and Insurance domain.

- Proficient in both Agile/Scrum and Waterfall methodologies, Experienced in working with bitbucket, confluence, JIRA. Ensuring adaptability and efficiency across diverse project frameworks.

- Previously worked with Tata Consultancy Services for about 3.4 years and NIIT Technologies for 1 year .

- Currently working with Axtria, designated as Project Leader in Noida for the role of Data Engineering Lead .

Overview

9
9
years of professional experience

Work History

Project Leader

Axtria
05.2020 - Current

Projects:


1. JET Wave 2: JET is a Data Science model designed to enhance the sales rep and health care professionals' partnership. The model creates suggestions for the sales rep to target the HCP based on their specialty using feature engineering to make aware about the latest products and enhance their experience with our clients.

Role: Responsible as a data engineering lead to communicate with different stake holders to gather requirements, design, develop and deliver the data engineering solutions.


2. Python-Pyspark Migration: The code of existing project was written in python which was migrated to pyspark to improve efficiency and save project effort and time.

Role: Responsible as a techinical lead to understand the current structure of project and create a new design to overcome the existing short comings and deliver efficient solutions.


3. Talend Moveout: The ETL jobs which were built using Talend Data Integrator and Oracle, were converted to Pyspark/Python. The data which was earlier stored in Oracle was now moved to hive/redshift.

Role: Responsible to convert already existing Talend jobs and convert them to pyspark scripts.

Software Engineer

Tata Consultancy Services
11.2015 - 03.2019

Projects:

1. eCOA: Electronic Clinical Outcome Assessment is a system which captures the real-time clinical results data. eCOA system enables data from the vendors to be ingested and integrated into the Information Hub. Data is captured through the electronic devices in the form of xml files, is received through message queues, and shredded and stored in the tables with the help of informatica code.

Role: Responsible as a developer to design and build the end to end pipelines of the system.

Education

B-Tech in Information Technology -

ABES Engineering College (Uttar Pradesh Technical University)
01.2015

Skills

  • Experienced in working on AWS services (Redshift, S3 , EC2 etc)
  • ETL development using Pyspark/Python , Informatica PowerCenter, SQL, Unix Shell Scripting
  • Data Warehousing & Modeling
  • Data pipelines design using Databricks and Dataiku
  • Scheduler tools like Control-M
  • Project Management

Timeline

Project Leader

Axtria
05.2020 - Current

Software Engineer

Tata Consultancy Services
11.2015 - 03.2019

B-Tech in Information Technology -

ABES Engineering College (Uttar Pradesh Technical University)
Akshat Srivastava