Thank you for the kind words. We have more than 25 mock interviews on our channel. Check the Data Engineering mock interview playlist. Please watch it in your free time, learn from it & let us know your thoughts.
Thank you Pulkit for your encouraging words. We have uploaded more than 22 Data Engineering and big data mock interviews. Do watch it in your free time. You will learn a lot & keep posting your encouraging words. It motivate us a lot.
2nd solution in PostgreSQL. WITH CTE1 AS (SELECT user_id, event_type, EXTRACT(MONTH FROM event_date) as month, DENSE_RANK() OVER(PARTITION BY user_id,EXTRACT(MONTH FROM event_date) ORDER BY EXTRACT(MONTH FROM event_date)) as rk FROM user_actions) SELECT month, COUNT(rk) AS montly_active_users FROM CTE1 WHERE rk = 2 GROUP BY month
Check the description. We have provided one link of TopMate for scheduling one call for the interview. We will connect with TopMate and discuss the next process
we can clearly see here that although she can solve SQL queries but didn't have any practical experience. And why I am saying because she didn't know how to debug.
Hi Rohan She is currently studying in University of Washington for her master & many things have changed in the last three years in Apache Spark. So it's very ok if someone who is on break for their study does not know any of the theoretical concepts like AQE in Spark. Why do we always go in judging someone instead of getting inspiration from someone courage to come out in public and give their best in the interview. It takes lots of courage and calibre. FYI, She had worked in Microsoft and Amazon as SDE and it is actually very much accepted having less theoretical ideas about Data Engineering. She was able to approach all the practical questions like SQL, DSA and even some level of system design questions. So kindly encourage someone, instead of passing judgement comments. On offence, BTW !!!
Nd even if the best coder in the world will go for 10 interviews and at least in 5 interviews, he or she will not be able to answer multiple questions. So judging someone is actually very bad and passing the comment. Instead of judging someone, try discussing some of the questions which were asked in the interview.
@@rohan5713 better to discuss questions and answers here. Why to pass judgement? If someone has been studying for the last two years then obviously some of the theoretical questions will be missed because that particular person is not writing code daily professionally & moreover Apache Spark is just a framework. Not knowing Apache Spark's questions is ok. Better to discuss questions then to pass comments that the interviewee doesn't know something. I hope you will understand what I am trying to convey. Do you have any questions which Kuldeep has asked in the interview and that you want to discuss then kindly comment that question. And, if you know the answer then also it will be great. I hope you will take this in a positive way.
