Prerna Gupta

Experience

• 

  Seedomics Inc.

  Aug 2020 - Aug 2021

  Software Engineer Intern

  Worked on various projects involving Python programming language. These projects were further optimized using Deep learning models.

• 

  GeeksforGeeks

  Dec 2020 - Feb 2021

  Technical Content Writer intern

  Contributed articles related to Computer science. Specifically, on data structures, C++, python, linux etc.https://auth.geeksforgeeks.org/user/prernaajitgupta/articles

• 

  Little ninjas 18

  May 2021 - Aug 2021

  Python Tutor

  Freelance Python Programming Tutor.

• 

  Shashwat foundation

  Jun 2021 - Aug 2021

  Intel AI4Youth Project Mentor

  Mentored students selected from all over the country, guided them through AI related projects under AI4Youth campaign. This was in association with Intel.

• 

  FACE Prep

  Aug 2021 - Apr 2022

  Coding Instructor
• 

  Argusoft

  Jan 2022 - May 2022

  Full-stack Web Development Intern
• 

  Corizo

  Apr 2022 - Jun 2022

  Web Development Mentor
• 

  Tata Consultancy Services

  Jun 2022 - now

  Data Engineer

  AWS Migration:- Skilled in writing and executing SQL queries, particularly for data migration and validation tasks.- Experienced in deploying and managing code on AWS EC2 servers, including running Step Functions for data processing.- Expertise in migrating data from Teradata to Amazon Redshift, ensuring data integrity and accuracy throughout the process.- Experienced in validating data to ensure accuracy and completeness after migration and processing.- Strong analytical skills to understand and replicate complex SQL code for migration purposes. - Meticulous in validating and ensuring the quality of data during migration and processing.GCP Migration: I was involved in a migration project aimed at moving applications, workloads, and data from on-premises or other cloud platforms to Google Cloud Platform (GCP).Airflow DAG Monitoring and Debugging: Airflow DAGs (Directed Acyclic Graphs) were used to define and manage data workflows and ETL processes. I was responsible for monitoring these DAGs and identifying and resolving issues or errors that occurred during the workflow execution.SQL File Debugging: As part of the data processing and ETL pipelines, SQL queries or scripts were used to extract, transform, and load data from different sources. I was involved in debugging and optimizing these SQL files to ensure their correctness and efficiency.Working with Multiple Data Sources: The project involved handling various data sources, including Hive, Informix, and Kafka.Issue Resolution: I collaborated with team members to troubleshoot and resolve errors encountered during DAG execution, SQL processing, or any other issues related to data pipelines.Performance Optimization: Throughout the project, I focused on optimizing DAGs, SQL queries, and data processing steps to improve overall performance and efficiency. Show less