Goldman Sachs Interview Experience for Analyst

Eligible Branches: Open to All.

Online Test (135 mins): Platform: Hackerrank. The test consisted of 5 sections:

• 2 Coding Questions in 30 min. Both were easy-level questions and simple brute-force solutions passed all test cases.
• 1 Leetcode medium question. (45 min) https://leetcode.com/problems/snakes-and-ladders/
• Aptitude Questions (20 min)
• CS MCQs (25 min)
• 2 descriptive questions (15 min) Test was proctored

Verdict: To the next round

Round 1 (40 min): Platform: Codepair

• The round started with “Tell me something about yourself”.
• Coding Question: https://www.geeksforgeeks.org/burn-the-binary-tree-starting-from-the- target-node/

Verdict: To the next round

Round 2 (70 min): Platform: Codepair

• Questions on SQL union, intersect. Write a query to find the union of two tables with distinct entries only. Also, add a column to this newly created table that indicates from which original table the entry has come. ( Like 1 indicating 1st table and 2 indicating 2nd table).
• Leetcode hard coding question. https://leetcode.com/problems/median-of-two-sorted-arrays/
• Coding Question: Given a disk of size 10GB containing integers. If you have 1GB of RAM then how would sort the numbers in the disk?

Verdict: To the next round

Round 3 (40 min): Platform: Zoom

• Introduce yourself
• Explain one of your projects.
• Which Database did you use in a project? (I used SQLite)
• Why did you choose SQLite?
• What are the problems you will face if you try to scale up your project with SQLite as a Database?
• What are ACID properties in the database? Explain each with an example.
• He gave me a Schedule and asked if was it consistent (it wasn’t) and then asked how would you ensure Isolation in that case?
• Asked a little bit about concurrency control protocols.
• How would you ensure the durability of the database?
• What have distributed databases?
• What is horizontal and vertical scaling?
• And at the end “Do you have some questions? “

Verdict: Selected