• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Using the ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Worked on Snowflake environment to remove redundancy and load real time data from various data sources into HDFS using Kafka
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.