•Developed over 20+ Azure Data Factory pipelines to efficiently pull data from client databases into Azure Data Lake Storage, and from Azure SQL Database to Snowflake, ensuring seamless data integration into corresponding folders.•Developed and implemented triggers for handling incoming incremental data loads efficiently.•Analysed requirements and designed tables, views, and procedures in Snowflake across three different layers to ensure optimal data organization and retrieval.•Conducted thorough unit testing in Snowflake for Development (DEV), User Acceptance Testing (UAT), and Production (PROD) environments to ensure data integrity and performance.•Actively participated in sprint planning and requirement refinement sessions, contributing to project management and task prioritization.•Demonstrated a strong understanding of storing and reading data from cloud storage solutions such as Azure Blob Storage.•Skilled in writing SQL queries to extract business insights, providing valuable data analysis and reporting.

•Acquired skills in SQL, Unix, Java, and Data Warehouse during internship training.•Successfully completed milestones associated with various tools, including assessment tests.•Intend to apply the gained skills towards the successful execution of the final internship project