Build and maintain cloud data warehouse system. Worked with functional teams to gather & define business needs and translate to technical requirements. Identifying business needs, designing and developing solutions for meeting those needs.
Solution
- Maintained a single destination by migrating all the tables and views from legacy SQL Server to Snowflake and updated the tableau dashboards to migrate the data sources to Snowflake
- Centralized data into destination by creating Fivetran connectors to extract the data from multiple sources and load the data to Snowflake
- Simplified the data testing and validations using DBT. Created DBT models to transform the data within the data warehouse and produce trusted data sets for reporting
- Worked with functional teams to gather requirements and developed tableau reports
- Examined existing process and suggested improvements, new releases, testing, and implementation of production enhancements, and upgrades
Key Features
- Maintained a single destination by migrating SQL Server to Snowflake and developed Tableau reports.
- Identified issues in the existing data models and implemented solutions to fix the data issues.
Key Metrics
Reduced ELT run times and improved performance
2X
QUERY RESPONSE TIME FASTER
Technology Stack
