Intern
Bangalore, Karnataka, India
During my internship, I gained hands-on experience in data engineering concepts, focusing on the design and implementation of data warehousing solutions. I successfully utilized SQLDBM, SSIS, and SQL Server to create a data warehouse for an e-commerce platform, consolidating various database objects to enhance data accessibility and reporting. I developed a foundational understanding of ETL processes, including data extraction, cleansing, and loading. Collaborating with experienced professionals, I honed my skills in writing complex SQL queries and gained practical knowledge in data management tools.RDBMS Concepts and Database internals- Logical and Physical Data Modelling (Relational & Dimensional)- Designing database objects in MS SQL Server 2019 - Data Integration techniques using SQL Server Integration Services (SSIS)- Introduction to Azure- Implementation of an end to end data engineering solution that involves,o Data Modellingo Azure Data Factoryo Azure Data Lakeo Azure SQL