Google Data Engineer Mock Interview | SQL & DSA Round | Top Product Based Companies
HTML-код
- Опубликовано: 28 мар 2024
- To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&su... for curated courses developed by me.
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
30 INTERVIEWS IN 30 DAYS- 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
An interesting mock interview featuring participants who are working for top product based companies like Google & CNH
Our highly experienced guest interviewer, Suddhasatwa Bhaumik, / suddhasatwa-bhaumik shares invaluable insights and practical advice coming from his extensive experience in the Big Data Domain
Our expert guest interviewee, Surbhi Walecha, / surbhi-walecha has a remarkable approach to answering the coding round interview questions on SQL and DSA.
Link of Free SQL & Python series developed by me are given below -
SQL Playlist - • SQL tutorial for every...
Python Playlist - • Complete Python By Sum...
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 - / bigdatabysumit
Twitter - / bigdatasumit
Instagram - / bigdatabysumit
Student Testimonials - trendytech.in/#testimonials
Discussed Questions with Timestamp
1:13 Introduction
3:18 DSA Coding Question
17:07 SQL Coding Question
Tags
#mockinterview #bigdata #career #dataengineering #data #datascience #dataanalysis #productbasedcompanies #interviewquestions #apachespark #google #interview #faang #companies #amazon #walmart #flipkart #microsoft #azure #databricks #jobs
Great 🎉
Good questions and very engaging interview!!
Great interview, thank you to all the participants and organizers!
One note: I think that DSA problem-s solution presented will consider subsequences and not substring as required by the problem statement, it will work for "abcabcbb" and for "bbbbb" but not for "pwwkew". For pwwkew it will return 4 (pwke) and not 3 (wke).
My solution will work for all 3 cases, instead of incrementing left by one I "reset" it and make it = idx, however it wont work for more complicated case like this one: 'cyraffjhzxc' .
I am curios what would be a complete solution.
def solution_99 (text) -> str:
left = max_len = 0
my_set = set()
for idx, val in enumerate(text):
while val in my_set:
my_set.remove(val)
left = idx
my_set.add(val)
max_len = max(max_len, idx-left+1)
return max_len
Why to use join in the sql question???
How about this Solution:
With cte as
( select * ,
Case when shipping_add != bill_add then “invalid”
Else “valid” end as Order_check
from orders)
Select order_id from cte where
Cust_id in (select Cust_id from cte where order_check= “invalid”)
Inline subqueries are costly
@@SuddhasatwaBhaumik
Why will this simple select statement wont work. Am I missing something?
Select * from orders
where billing_address!=shipping_address;
I didn't get the second question at all.
A customer can order to different addresses, with different order ids.
Suppose, I place an order today for myself for the address pune with both addresses being same, tomorrow I can place it for my friend for the address Mumbai with both billing and shipping address for Mumbai.
No matter what, in the context of the question, all of the rows will be marked respective of anything, because how would we know, which address to be called as customers real address to compare to? _ i think candidate should have asked / interviewer should have clarified.
E.g. she was assuming first record to be real address and was comparing others to it. So i don't.
Please help me understand the question again.
I think simple where condition should do the work - her first approach
The question was only to check how one can use simple solutions to find row wise differences