Shubham santoshwar

Shubham santoshwar

GCP Data Engineer
India

About Me

Detail-oriented data engineer with 2 years and 6 months of experience specializing in Google Cloud Platform (GCP). Proficient in designing, implementing and optimizing data pipelines on GCP. Skilled in data ingestion, tr…

Experience

GCP data engineer

Fossil group inc
Aug 2021 - Present · 4 years 10 months

• Played a key role in the development and maintenance of a robust data pipeline on GCP.
• Create a new cloud function using Python to handle errors in data source CSV files.
• Collaborating with the data science and data analyst teams to design and optimize data models and existing SQL logic.
• Proactively established alerts for job failures and files with bad record errors within the GCP.
• Implemented GPOP in Looker and developed critical table check queries and a list of unused table queries.
• Demonstrated exceptional problem-solving skills by effectively debugging and investigating
Production issues, resolving them within specified timelines and conducting a thorough root cause analysis to prevent recurrence.

GCP Data Engineer

Fossil Group, Inc.
Aug 2021 - Present · 4 years 11 months

Managed the integration of various data sources including customer, transaction, inventory, open order, region-based forecast, and financial data.
Oversaw data extraction from SAP BW, SAP ECC, SAP SD, SAP MM, Navision, and Hyperion systems.
Implemented data transformation processes to ensure accuracy before loading into target systems.
Played a key role in the development and maintenance of a robust data pipeline on GCP.
Created a new cloud function using Python to handle errors in data source CSV files.
Collaborated with the data science and data analyst teams to design and optimize data models and existing SQL logic.
Proactively established alerts for job failures and files with bad record errors within GCP.
Implemented GPOP in Looker and developed critical table check queries and a list of unused table queries.
Debugged and investigated production issues, resolving them within specified timelines.
Conducted root cause analysis to prevent recurrence.

Skills

Cloud Services SQL Database Google Cloud Platform (GCP) SQL BigQuery Google Cloud Storage Cloud SQL Cloud Functions Cloud Dataflow Cloud Pub/Sub Cloud Scheduler Cloud Composer Python UNIX IBM Data Stage Master Data Management (MDM) Move It ServiceNow ETL SAP BW Looker
Report this Profile?