As a dedicated SQL and Snowflake Developer with 2.6 years of hands-on experience, I specialize in designing, developing, and optimizing data solutions to drive business intelligence and analytics. My expertise lies in writing complex SQL queries, managing ETL processes, and maintaining high-performance data warehouses in Snowflake. I am adept at collaborating with cross-functional teams to translate business requirements into technical solutions, ensuring data accuracy and accessibility.
My commitment to continuous learning and my passion for data-driven insights enable me to deliver robust and scalable database solutions that support strategic decision-making.
SQl:
Designed and implemented complex SQL queries and stored procedures,functions,views for ETL processes.
Fine-tuned SQL queries, reducing execution times by up to 40%.
Experienced in writing T-SQL(DDL,DML,DCL) for creating and managing, stored procedures and views.
Proficient in SQL joins (INNER , LEFT RIGHT AND FULL) to combine data from multiple tables based on related columns.
ETL Processes:
Successfully designed and implemented complex ETL (Extract, Transform, Load) workflows using SSIS. Leveraged SSIS's robust data transformation capabilities to integrate data from multiple sources including SQL Server, and flat files, ensuring data accuracy and consistency across the organization and reduced data processing time by 50%.
Leveraged Matillion’s cloud-native ETL capabilities to build scalable and efficient data integration pipelines to transfer data into snowflake . Designed and implemented data workflows to handle large volumes of data, ensuring seamles .
Snowflake:
Led design of a new snowflake -based data warehouse, resulting in 40% improvement in data retrieval times.
Successfully led a team in migrating a large-scale data warehouse to Snowflake, resulting in a 50% reduction in storage costs and improved data accessibility.