Project Overview: Led the design and implementation of a scalable data warehouse solution using Snowflake and dbt, optimizing the ETL/ELT processes to manage large datasets, improve performance, and ensure high data quality.Key Responsibilities:Architected and developed data pipelines to ingest and transform data from multiple sources, including SQL Server and cloud-based APIs, into Snowflake.Designed and implemented dbt models for both staging and production layers, ensuring modular, reusable transformations.Developed incremental models using dbt to optimize data processing and reduce compute costs by processing only new and changed records.Implemented SCD Type 1 and Type 2 strategies using dbt snapshots, tracking historical changes and ensuring accurate reporting for dimension tables.Managed the loading of fact and dimension tables across multiple schemas (raw, refined, and produced) and applied data reconciliation strategies to ensure consistency across the bronze, silver, and gold layers.Used Snowflake’s virtual warehouses to handle scaling needs, improving query performance, and efficiently managing costs.Collaborated with business stakeholders to design the data warehouse schema, ensuring it aligned with business needs for analytics and reporting.Worked on performance tuning and optimization of dbt models and Snowflake queries by utilizing clustering keys, partitioning strategies, and materialized views.Implemented data quality checks and automated testing using dbt tests, ensuring high data accuracy and consistency across transformations.Key Achievements:Reduced ETL processing time by 30% by optimizing dbt models and implementing incremental loading strategies.Successfully migrated legacy ETL pipelines to dbt, reducing manual intervention and automating daily data loads into Snowflake.

1. Worked as Tech Arch across multiple projects/modules and worked on various technology skills like Azure Data Factory, Data bricks, Azure Data App Azure SQL DB, SSIS, T-SQL, Power BI.2. Leading a team of 2 Leads and 22 members on data visualization and analytics projects.3. Created project plans - HLP/LLD and estimation for Development/migration/reporting projects.4. Conducted Technical Interviews, facilitated on-boarding and mentoring of team members. 5. Created Data Model and ETL architecture for Data warehousing projects.6. Implemented ETL solutions on disparate source systems using SSIS.7. Worked as an Onsite Lead and coordinator for more than 5 yearsSpecialties: Azure Data Factory, Azure Databricks, Python, SSIS, Power BI, C#

Development and Production support of .NET Applications

Design, Development for Web Applications