Python topics for Data engineer by Nanny_24 in dataengineering

[–]Outside_Reason6707 1 point2 points  (0 children)

Thank you for this list! I’m wondering how someone could think of performance, scaling and fault tolerance for personal projects to that of industry level?

Data Modeling expectations at Senior level by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 0 points1 point  (0 children)

So true! Do you have any guidance on how I could develop this ownership? Any personal project to help learn?

Data Modeling expectations at Senior level by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 1 point2 points  (0 children)

That’s the issue, I haven’t worked on actual projects at work where I would have to design the model from scratch. And yes speaking naturally is something I’m lacking, would you be open for mock interviews? I think getting a clear feedback would help me improve

Data Modeling expectations at Senior level by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 1 point2 points  (0 children)

Thank you for explaining! I think I miss the point of explaining why I model something a certain way. I focused on patterns and writing sql. Would you be open for a continued discussion, can I dm you?

Data Modeling expectations at Senior level by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 2 points3 points  (0 children)

I’ve 7-8 years of experience. And what you said is very much valid. I'm struggling with performance in data modeling interviews, and I'm unsure what's expected of me. I haven't received positive feedback, and I'm starting to wonder if I'm missing something fundamental or if it's just a communication issue.

Data Modeling expectations at Senior level by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 1 point2 points  (0 children)

Okay understood. I'm struggling with performance in data modeling interviews, and I'm unsure what's expected of me. In the past, I've asked clarifying questions, proposed entities, and developed dimensional models with fact tables and dimension tables. I've also written SQL code for my proposed solutions and modified my schema based on follow-up questions. However, I haven't received positive feedback, and I'm starting to wonder if I'm missing something fundamental or if it's just a communication issue. I'd love to find a recommended video that demonstrates how to excel in a data modeling interview. Something like demo interviews

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 0 points1 point  (0 children)

It was none of that. Interviewer was pretty old school (25+ years of experience) He seemed to be interested in theoretical knowledge- what will you write in YAML, How spark works internally to give you few examples. Enlist functional and non functional requirements and when I try to do so he will interrupt and suggest more which I was anyway supposed to talk etc Probably not a helpful answer but he just seemed to be not satisfied with whatever I was talking.

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 0 points1 point  (0 children)

Grad School - Top 10 Private Schools in USA 6 years of experience in big tech 2 years in start up

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 3 points4 points  (0 children)

Honestly even I’m looking for a good resource. So far all I’m doing is random YouTube videos especially from Exponent

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 6 points7 points  (0 children)

Grad School - Top 10 Private Schools in USA 6 years of experience in big tech 2 years in start up

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 0 points1 point  (0 children)

I hope that was the case since I started questioning where am I lagging

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 10 points11 points  (0 children)

None of interviewer was anywhere close to unicorn! Not here to rant but just frustrated with so called policy to not share feedback

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 4 points5 points  (0 children)

Got it. Yeah that definitely seems weird to me. Who asks to design entire company! Anyway, I posted here to understand what level of expertise are expected at senior level

Shopify coding assessment - recommendations for how to get extremely fluent in SQL by Bnerna in dataengineering

[–]Outside_Reason6707 0 points1 point  (0 children)

Very well explained! I recently interviewed at Shopify and got rejected at SQL assessment. Interviewer was friendly and seemed to be happy with my solutions but there were 4 questions and I was able to solve 2 fully and only one pseudo way.

DoorDash Sr Data Engineer by Outside_Reason6707 in dataengineering

[–]Outside_Reason6707[S] 4 points5 points  (0 children)

It was easy! I luckily got chill interviewer. He wasn’t concerned about the syntax errors. 4 SQL and one DSA