Summary
Overview
Work History
Education
Skills
Timeline
Generic
Kumar Prateek

Kumar Prateek

Noida

Summary

Accomplished and results-driven Data Engineer with a proven track record of designing and implementing ETL solutions tailored for pharmaceutical clients. Proficient in all stages of Data Pipelining and Data Warehousing.

My experience spans the development and delivery of end-to-end ETL solutions, empowering business to harness the full potential of their data assets. With a keen understanding of the Life Sciences and Healthcare domain.

Overview

3
3
years of professional experience

Work History

Data Engineer

Axtria - Ingenious Insights
Noida
05.2022 - Current
  • Analyzed business requirements, designed and developed ETL processes, Integrated structured datasets from multiple sources of like Specialty Pharmacy, 3PL, Veeva CRM and Network data into the Redshift and Snowflake Database.
  • Designed and implemented end-to-end workflows for data ingestion, DQ Implementation , Data Cleansing, ETL pipelines , Extract and provisioning , Batch creation over Matillion and Axtria DataMAx Rednode.
  • Created stored procedures for automating periodic tasks in SQL Server.
    Developed Python scripts for extracting data from S3 , SFTP and loading into databases, developed custom code to enable PGP encryption/decryption of data file to ensure security.
  • Worked to enable Datavant tokenization for PHI/PII data.
  • Captured and shared best-practice knowledge amongst team.

Assistant System Engineer

Tata Consultancy Services
Bangalore
10.2020 - 05.2022
  • Worked as a PL/SQL Developer on Oracle Retail Domain dealing with large data sets and providing solutions on Retail business.
  • Developed complex procedures functions to enable business ,worked on AJIO integration for Landmark to establish smooth gateway between client database to AJIO to consume and display Landmark products at AJIO via Ace-turtle for direct B2C.

Education

Bachelor of Technology -

National Institute of Science And Technology
Odisha
08-2020

High School Diploma -

Delhi Public School
Ranchi

Skills

  • Redshift
  • Snowflake
  • Python
  • Matillion
  • ETL
  • PLSQL
  • Problem-Solving
  • Data Warehousing
  • Data Migration
  • Data Modeling

Timeline

Data Engineer

Axtria - Ingenious Insights
05.2022 - Current

Assistant System Engineer

Tata Consultancy Services
10.2020 - 05.2022

Bachelor of Technology -

National Institute of Science And Technology

High School Diploma -

Delhi Public School
Kumar Prateek