Chinmay Watve

Data Engineer @Tricolor Holdings

Led the efforts to build Snowflake Data Warehouse to rearchitect in-house data management tools • Implemented a two-tier deployment architecture while following RBAC best practices for Master and BI schemas allowing frictionless roll out of new features to production • Utilized Hubspot’s Snowflake Secure Data Sharing to publish near real-time data metrics to the management • Facilitated workflows comparison between Hubspot’s production and sandbox environments during its onboarding • Designed Matillion ELT pipelines to migrate data from Hubspot custom objects, Database Servers, SFTP servers and Blob storage • Isolated Matillion dev/testing from production pipeline activities by creating two environments to rollout new features seamlessly • Designed and implemented pipelines for migration of legacy data into snowflake. • Implemented a standardized process to consume customer PII and financial data from vendors like Five9 and Datavail to reconcile work tickets and to measure new campaign metrics • Led cross-functional projects to build Matillion CDC pipelines to accurately capture nightly deltas of changed data • Created automated Python scripts to- Track movement of car stocks through supply chain boards on Monday.com via GraphQL Monday APIs - Grab User and Sales teams information by scraping Hubspot APIs - Capture Credit Decision Modelling data from Phenx Azure Cosmos DB • Worked in an Agile environment and utilized Azure DevOps to track PBIs in each Sprint