Data Engineer with expertise in data migration and cloud engineering. Developed and optimised complex SQL scripts for reporting and analysis while managing large-scale datasets in GCP BigQuery environments. Delivered impactful data solutions through effective data validation, cleansing, and reconciliation.
Overview
4
4
years of professional experience
1
1
Certification
Work History
SQL Data Engineer
Onix-Datametica Solutions Pvt. Ltd.
07.2024 - Current
Led modernization of Verizon's EDW by migrating large-scale Teradata workloads to Google BigQuery with improved performance and reliability.
Designed and developed scalable ETL/ELT pipelines using BigQuery, SQL, Informatica.
Optimized BigQuery performance using partitioning, clustering, query tuning, and cost-management strategies.
Developed complex SQL translation logic converting Teradata SQL, BTEQ, and stored procedures to optimized GoogleSQL.
Monitored ETL job execution and resolved data load failures to maintain service level agreements (SLAs).
Validated source-to-target mappings and transformation logic.
SQL Developer
MRO (FIGmd Pvt Ltd)
03.2022 - 07.2024
Successfully migrated over 10 million records to BigQuery with zero data loss.
Created reusable SQL scripts for data extraction, transformation, reconciliation, and audit reporting.
Write query on GCP and fetch data from server
Managed data extraction using Spine (internal ETL tool) to ensure timely and accurate data availability.
Validated and verified data to support decision-making and maintain data integrity.
Executed data cleanup processes to maintain accurate historical records and improve data quality.
Handled change requests via JIRA to facilitate effective communication and project tracking.
Education
BE - IT Engineering
DPCOE
Pune
02-2021
Skills
SQL
PL/SQL
BigQuery
Teradata
Oracle
RDBMS
ETL
Data Warehousing
Data pipeline design
GCP
Google Cloud Storage
Airflow
Linux commands
GIT
JIRA
Certification
Google Associate Cloud Engineer
Custom
I hereby declare that the information provided is true to the best of my knowledge.