leetCode
Vishal Jadhav LEETCODE HotList Questions 📍Arrays and Strings 1. Two Sum (LeetCode 1)2. Longest Substring Without Repeating Characters (LeetCode 3)3. Product of Array Except Self (LeetCode 238)4. Maximum Subarray (LeetCode 53)5. Merge…
2025
Data Engineer interview.
CAP theorem Lambda vs kapp architecture Star vs snowflake schema Data warehouse , data lake, delta lake, dataware house Scd types SQL How would you write a query to calculate…
partition vs buckting
Difference between Partitioning & bucketing similarity divide the data into many parts and then scan only one part of it. differences partition is a folder and bucket is a file…
pyspark
The following question was asked in the top 10 product-based companies. How would you handle skewed data in PySpark? How to Join Two Large DataFrames in PySpark Efficiently 📌 PySpark…
spark/pyspark performance optimization techniques
best playlist for understanding performance turning narrow(no data shuffling) vs wide(shuffling data across multiple partition ) transformation partitioning and buckting – when we should go with bucket and when shoud…
Surrogate key
Surrogate keys are artificially generated primary keys, typically integers, used to uniquely identify records. In data warehouse you may have same record with multiple entries(this records columns value may change…