Priyanka Gore

HSBC

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

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