Gunjan Kataria
Data Engineer
New Delhi
Summary
5 years of Hands on experience in ETL technologies using Python supported on Cloud (AWS) and creating data-driven workflows on the cloud platforms for orchestrating and automating data movement and data transformation.
Overview
2025
2025
years of professional experience
4
4
years of post-secondary education
Work History
Business Technology Solutions Associate Consultant
ZS Associates
4 2021 - Current
- Project : Heritage Systems Rationalization Assessment The projects aims to target decommissioning multiple heritage systems to one consolidated Cloud system
- All the applications & integrations including Inbound & Outbound integrations has been moved to Cloud by minimizing minimal business disruptions
- Project : SABRe SABRe Data Migration project migrates clinical studies and associated content to the new Clinical Data Repository & Statistical Computing Environment (CDR-SCE) system
- The migration service utilizes a Param File which specifies source to target directory mappings & migrates data based on specified folder paths without loss of data integrity
- Project : Regulatory Control tower Regulatory Control tower comprises of backend pipelines for extracting & transforming Regulatory data
- It comprises of different framework which involves Data ingestion, Data transformation, Data curation & consumption
Assistant System Engineer
TATA Consultancy Services
07.2019 - 04.2021
- Project : DataLake Automation The purpose of this project is to preserve data from various sources (Salesforce, Veeva, PRISM etc.) using API based ingestion or Cloud based ingestion
- Designed and developed automated pipeline to move data from source database (Oracle on-premises) to target database (AWS Aurora)
- Database connection from on premise database to AWS Aurora using AWS Database migration Service
Education
B.Tech - Information Technology
Maharaja Surajmal Institute of Technology
01.2015 - 01.2019
12th - CBSE
Sanjeevani Public School
10th - CBSE
Sanjeevani Public School
Skills
Life Sciences
Pharma
Cloud
Data Analysis
Python
Shell Scripting
EC2
IAM
RDS
Redshift
Lambda
Autoscaling
VPC
Step functions
S3
DatabaseMigration Service
Glue
CloudWatch
Cloud formation template
DataSync
EBS
EFS
Athena
Oracle
PostgreSQL
Putty
Jira
Anaconda
VS code
HP-ALM
Open shift
TOAD
SQL Workbench
Postman
Windows
Linux
GitLab
WinSCP
SVN Tortoise
Certificationsandachievements
- Promoted from Associate to Associate Consultant in 2023 at ZS Associates.
- Got Be My Star- Game Changer Award 2022 in recognition of impact created within the client space.
- SABRe Project was awarded with ZS Project Champions Award 2021.
Timeline
Assistant System Engineer
TATA Consultancy Services
07.2019 - 04.2021
B.Tech - Information Technology
Maharaja Surajmal Institute of Technology
01.2015 - 01.2019
12th - CBSE
Sanjeevani Public School
10th - CBSE
Sanjeevani Public School
Business Technology Solutions Associate Consultant
ZS Associates
4 2021 - Current