Goldman Sachs Interview Experience for Data Engineering Senior Analyst

Round 1(Coderpad Round – 1hr): Questions asked:

1. https://www.geeksforgeeks.org/find-subarray-with-given-sum-in-array-of-integers/
2. https://www.geeksforgeeks.org/check-if-a-given-binary-tree-is-sumtree/

Round 2 (Zoom Round – 1hr): Questions around data engineering principles, big data fundamentals, Spark, HDFS, YARN, 

1. Why PySpark exists, JVMs, Difference between Java and Scala, RDDs and DFs, etc.
2. Coding question: Write the logic for “git diff” command

Round 3 (Zoom Round – 1hr): 

• Questions around data modelling, SQL, databases, normal forms and normalisation, ER diagrams, kinds of keys, etc.
• Coding question: https://www.geeksforgeeks.org/minimum-number-platforms-required-railwaybus-station/

Round 4 (Hiring Manager Round – 1.5hrs): 

• Questions around various distributed file systems and file formats, Parquet vs Avro, etc.
• Design CoderPad; classes, functions, environments, etc.
• Coding question: https://www.geeksforgeeks.org/median-of-stream-of-integers-running-integers/

Round 5 (45minutes): HR round, led by head of Marcus Bangalore

• Why are you quitting your existing company, why GS, what’s different about GS, what do you bring to GS
• After 30 minutes of discussion, I was extended the offer!

Tips:

1. Clarify the problem statement thoroughly
2. Don’t try for the best solution straight away; it’s totally fine to start with a naive/greedy approach to any problem as long as you’re aware of it and can work your way towards an optimal solution
3. Depending on the JD, fundamentals are stressed upon combined with some common Computer Science concepts (knowing time and space complexity is key)