Having 11 years of IT experience in Data Warehousing & Data Mart projects with extensive use of ETL tools SnapLogic and dbt.
Experience with Snowflake Virtual Warehouses, Snowpipe, Snowflake Database, Schema and Table structures.
Developed and maintained dbt transformation models on Snowflake for staging, intermediate, and mart layers; implemented incremental models and data quality tests.
Basic knowledge of Power BI for data visualization, dashboards, and connecting to Snowflake data sources.
Basic knowledge of Snowflake Streamlit for building lightweight data apps and APIs within the Snowflake ecosystem.
Extensively worked with implementation of Dimension models, Star schema, Snowflake schema, fact and dimension tables.
Prime focus on Design, Development, Maintenance and Enhancement of ETL applications.
Extensively used Informatica Power Center 10.1, DataStage 11.7, and SnapLogic.
Good knowledge of Oracle, SQL Server and Teradata platform.
Extensively worked on UNIX Shell Scripting and Python.