Summary
Overview
Work History
Education
Skills
Awards / Achievement
Timeline
Generic

Priyanka Gore

Senior Data Engineer
Pune

Summary

Efficient Data Engineer with 4+ years of experience developing Data pipelines into GCP.

Overview

4
4
years of professional experience

Work History

Senior Data Engineer

LTIMindtree
11.2024 - Current

HSBC

  • Working on development of GCS to Bigquery data pipelines using Google Cloud Composer
  • Technologies Used: Cloud Composer, BigQuery, SQL, GitHub

Data Engineer

Datametica Birds
08.2021 - 11.2024

Pizza Pizza Ltd

  • Designed ETL pipelines using Google DataForm and BigQuery
  • Developed SCD Type-1 BigQuery Procedures
  • Technologies Used: DataForm, BigQuery, SQL


Telus - Oracle to GCP Migration

  • Worked on Oracle to BQ Migration. Converted informatica workflows, mappings into equivalent GCP queries. Worked on file ingestions (i.e. CSV,TXT) to load it to BQ.
  • Attended Job Failures by analyzing the root cause, resolving the failure. Prepared approval documents for various data mismatches observed between BQ and Oracle. Worked on YAML files for DAG creation. Handled Type-2, DNTL data. Discussed data issue with client.
  • Worked on multiple BQ tables in the absence of team members. Worked on Production Deployment activity.
  • Technologies Used - Informatica, Cloud Composer, BigQuery, Oracle, SQL


Mattel - Oracle to GCP Migration

  • Devised simple and complex SQL scripts to check and validate Data flow in various applications.
  • Developed and implemented ETL processes to improve data quality, resulting in a 20% increase in data accuracy
  • Responsible for the quality check before moving jobs into production
  • Technologies Used - Informatica, Cloud Composer, BigQuery, Oracle, SQL


AEO - Teradata to GCP Migration

  • Worked with team on migration of a legacy Data Warehouse from on-premise (Teradata) to GCP
  • Constructed a data pipeline to process structured data using GCP Cloud Data Fusion Service.
  • Developed Airflow DAG’s to create, schedule, monitor, and manage workflows also worked on performance related issues.
  • Performed Impact Analysis on the existing mappings and providing Feedback.
  • Coordinated with multiple cross-functional teams.
  • Involved extensively on data validation part.
  • Technologies Used - Informatica, Cloud Composer, Data Fusion, BigQuery, Oracle, Cloud Function

Education

Bachelors - Computer Engineering

JSPM'S JSCOE
Pune, India
07-2021

Diploma - Computer Engineering

Cusrow Wadia Institute Of Technology
Pune, India
05.2018

Skills

Data - ETL/ELT - Informatica, Teradata, Oracle, Data Warehousing

Cloud - BigQuery, GCP Data Fusion, Airflow Composer, Data Storage, Cloud Shell, Data Form, Cloud Function

Programming - Python, SQL, Shell

Version Control - GitHub

Awards / Achievement

  • Google Cloud Certified Associate Cloud Engineer
  • Infosys certified Software Programmer
  • Datametica Spot Award Nov 2024
  • Datametica Spot Award Dec 2022
  • Datametica Rising Star Award Sep 2021

Timeline

Senior Data Engineer

LTIMindtree
11.2024 - Current

Data Engineer

Datametica Birds
08.2021 - 11.2024

Bachelors - Computer Engineering

JSPM'S JSCOE

Diploma - Computer Engineering

Cusrow Wadia Institute Of Technology
Priyanka GoreSenior Data Engineer