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
Odisha08-2020
High School Diploma -
Delhi Public School
RanchiSkills
- 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