๐๐จ ๐๐ง๐ก๐๐ง๐๐ ๐ฒ๐จ๐ฎ๐ซ ๐๐๐ซ๐๐๐ซ ๐๐ฌ ๐ ๐๐ฅ๐จ๐ฎ๐ ๐๐๐ญ๐ ๐๐ง๐ ๐ข๐ง๐๐๐ซ, ๐๐ก๐๐๐ค https://trendytech.in/?src=youtube&sub=mockdec for curated courses developed by me.
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
๐๐๐ง๐ญ ๐ญ๐จ ๐๐๐ฌ๐ญ๐๐ซ ๐๐๐? ๐๐๐๐ซ๐ง ๐๐๐ ๐ญ๐ก๐ ๐ซ๐ข๐ ๐ก๐ญ ๐ฐ๐๐ฒ ๐ญ๐ก๐ซ๐จ๐ฎ๐ ๐ก ๐ญ๐ก๐ ๐ฆ๐จ๐ฌ๐ญ ๐ฌ๐จ๐ฎ๐ ๐ก๐ญ ๐๐๐ญ๐๐ซ ๐๐จ๐ฎ๐ซ๐ฌ๐ - ๐๐๐ ๐๐ก๐๐ฆ๐ฉ๐ข๐จ๐ง๐ฌ ๐๐ซ๐จ๐ ๐ซ๐๐ฆ!
"๐ 8 ๐ฐ๐๐๐ค ๐๐ซ๐จ๐ ๐ซ๐๐ฆ ๐๐๐ฌ๐ข๐ ๐ง๐๐ ๐ญ๐จ ๐ก๐๐ฅ๐ฉ ๐ฒ๐จ๐ฎ ๐๐ซ๐๐๐ค ๐ญ๐ก๐ ๐ข๐ง๐ญ๐๐ซ๐ฏ๐ข๐๐ฐ๐ฌ ๐จ๐ ๐ญ๐จ๐ฉ ๐ฉ๐ซ๐จ๐๐ฎ๐๐ญ ๐๐๐ฌ๐๐ ๐๐จ๐ฆ๐ฉ๐๐ง๐ข๐๐ฌ ๐๐ฒ ๐๐๐ฏ๐๐ฅ๐จ๐ฉ๐ข๐ง๐ ๐ ๐ญ๐ก๐จ๐ฎ๐ ๐ก๐ญ ๐ฉ๐ซ๐จ๐๐๐ฌ๐ฌ ๐๐ง๐ ๐๐ง ๐๐ฉ๐ฉ๐ซ๐จ๐๐๐ก ๐ญ๐จ ๐ฌ๐จ๐ฅ๐ฏ๐ ๐๐ง ๐ฎ๐ง๐ฌ๐๐๐ง ๐๐ซ๐จ๐๐ฅ๐๐ฆ."
๐๐๐ซ๐ ๐ข๐ฌ ๐ก๐จ๐ฐ ๐ฒ๐จ๐ฎ ๐๐๐ง ๐ซ๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ซ ๐ญ๐ก๐ ๐๐ซ๐จ๐ ๐ซ๐๐ฆ -
๐๐๐ ๐ข๐ฌ๐ญ๐ซ๐๐ญ๐ข๐จ๐ง ๐๐ข๐ง๐ค (๐๐จ๐ฎ๐ซ๐ฌ๐ ๐๐๐๐๐ฌ๐ฌ ๐๐ซ๐จ๐ฆ ๐๐ง๐๐ข๐) : https://rzp.io/l/SQLINR
๐๐๐ ๐ข๐ฌ๐ญ๐ซ๐๐ญ๐ข๐จ๐ง ๐๐ข๐ง๐ค (๐๐จ๐ฎ๐ซ๐ฌ๐ ๐๐๐๐๐ฌ๐ฌ ๐๐ซ๐จ๐ฆ ๐จ๐ฎ๐ญ๐ฌ๐ข๐๐ ๐๐ง๐๐ข๐) : https://rzp.io/l/SQLUSD
BIG DATA INTERVIEW SERIES
This mock interview series is launched as a community initiative under Data Engineers Club aimed at aiding the community's growth and development
Our highly experienced guest interviewer, Umesh Kumar Roy, https://www.linkedin.com/in/umesh-kumar-roy/ shares invaluable insights and practical guidance drawn from his extensive expertise in the Big Data Domain.
Our expert guest interviewee, Satyam Meena, https://www.linkedin.com/in/satyam-meena-0a1b46138/ has an interesting approach to answering the interview questions on Apache Spark, SQL and Azure Cloud Services.
Link of Free SQL & Python series developed by me are given below -
SQL Playlist - https://www.youtube.com/playlist?list=PLtgiThe4j67rAoPmnCQmcgLS4iIc5ungg
Python Playlist - https://www.youtube.com/playlist?list=PLtgiThe4j67pQSwkaEF9uHXzr8Td9IEpV
Don't miss out - Subscribe to the channel for more such informative interviews and unlock the secrets to success in this thriving field!
Social Media Links :
LinkedIn - https://www.linkedin.com/in/bigdatabysumit/
Twitter - https://twitter.com/bigdatasumit
Instagram - https://www.instagram.com/bigdatabysumit/
Student Testimonials - https://trendytech.in/#testimonials
TIMESTAMPS : Questions Discussed
00:50 Introduction
02:10 What sources do you use for data ingestion?
02:25 What connectors do you use for data ingestion?
02:45 How do you store and transform data after ingestion?
03:58 How are you preprocessing the data?
04:41 How do you eliminate duplicate records?
05:12 How do you ensure the correct records when handling duplicates?
05:50 How is your storage layer designed? Do you use mounting techniques?
06:04 Do you use delta files? Why?
07:00 What optimization techniques have you implemented?
08:05 Do you use partitions?
08:24 What factors do you consider when partitioning?
09:11 Do you use bucketing?
09:36 What are the use cases for partitioning and bucketing?
10:33 Besides broadcast joins, what other joins do you use?
10:52 Which join is the most efficient?
11:50 What is the difference between narrow and wide transformations?
12:26 What is your understanding about Spark and Databricks?
13:22 How do you consume data from the gold layer?
14:42 How do you connect Power BI to Azure Synapse?
15:46 Can you outline Spark architecture?
17:07 What is a DAG?
18:15 What is the difference between client mode and cluster mode?
19:29 Have you faced any challenges with cluster mode?
20:50 Why do DataFrames and Datasets exist?
22:17 What do you understand by normalization?
22:51 What other optimization techniques do you use?
23:33 SQL query
Music track: Retro by Chill Pulse
Source: https://freetouse.com/music
Background Music for Video (Free)
Tags
#mockinterview #bigdata #career #dataengineering #data #datascience #dataanalysis #productbasedcompanies #interviewquestions #apachespark #google #interview #faang #companies #amazon #walmart #flipkart #microsoft #azure #databricks #jobs