Aman Maheshwari’s Post

Kusuma V E Sumit Mittal Completed Data modeling and system design and learned below topics. Normalization - 1NF, 2NF and 3NF (Normal Form) Modeling a Datawarehouse Fact and Dimension Table Surrogate Key Snowflake Schema Slowly Changing Dimension SCD- 0,1,2,3 One Big Table (OBT) #Bigdata #Dataengineering #SQL #Pyspark #ADF #Databricks #Structuredstreaming

Database, Data Warehouse, Data Lake? Here's a good video explaining the differences and here's a documentation on Apache Pulsar's Lakehouse Tiered Storage: https://lnkd.in/ea3M3W7T https://lnkd.in/ehgjXZTy #database #datalake #datawarehouse #datalakehouse #pulsar

Embarking on a new journey of data exploration! 🚀 Just completed my SQL course with ETL Hive. Ready to unlock the power of databases and transform data into insights! 💡🔍 #DataJourney #SQLSkills #ETLHive #SQLJourney

Unlocking the power of data: Your crash course on ETL in 90 seconds! #BigData #datavisualization #datascience #dataanalytics #database #etl #dataengineer #datawarehouse

Journey to master practical data engineering 📊✨ 🔍 Task 2 of N: Data Warehousing Concepts 🏢? 🔍 🗝 Key Insights: 🎯 Database for real time transactions in OLTP 🎯 Data Warehouse for periodically freshened and summarized data produced after ETL on databases under OLAP (analytics ready data) 🎯 Data Lake is to store and manipulate all type of structed , un structured , semi structured data for ML/AI Tasks. 🎯 Extraction from OLTP source and application of data processing technique e.g. Aggregation and Normalization to store in OLAP instances is ETL 🎯 In normalized databases, main table is a facts table and supported ones are dimension tables resulting into Star Schema. An interconnected network it will snowflake schema and the process is Data Modeling ETL: Extract, Transform, load OLTP: Online transaction processing OLAP: Online analytical processing #ETL #Datalake #DataEngineering #LearningJourney #Data #warehousing #Databases #DataScience #TechExploration #CareerGrowth #Snowflake ↘ Resource(s): https://lnkd.in/dGx_2Wib https://lnkd.in/d3dQbhkv

#DidYouKnow SOL BI builds a data lake with ETL services from your business data? Visit www.solbi.ai to explore how it works! #SOLBI #GenerativeAI #datalake #database #businessintelligence

Just completed the Teradata SQL for Data Science and Data Analytics course! A great introduction to Teradata SQL – thoroughly enjoyed it! #DataScience #DataAnalytics #TeradataSQL

Very well optimized and efficient Databricks cluster configuration solution for processing 1TB of data

Remember our Data Engineering beginnings? From ETL to data pipelines, it all started here! Share your favorite memory! Contact us today - https://lnkd.in/d9swWvxR #ThrowbackThursday #DataEngineering #LearnAtRISE #DataJourney

Cracking the Code: Mastering Databricks for 1TB Data Processing with Pro-Level Performance Tuning #dataengineer #bigdata #databricks #dataanaytics