Sometime in November, I was cold-emailed by a recruiter on Handshake to apply for OCI. I completed a 1-hour technical screening, which was followed by a "Superday Interview" two weeks later. This interview involved three back-to-back interviews with both behavioral and technical questions.

After this, I had to ask for a response, in which my recruiter told me that they did not like the results, but wanted to give me a second chance since I had not been given a chance to do one of their prep sessions. I completed a prep session, plus an hour-long one-on-one prep, in which they emphasized that the behavioral interviews are values-heavy. They rescheduled for another Superday in January, until they informed me (a day beforehand) that they had just filled all of their spots for OCI.

However, the recruiter was polite enough to suggest other teams to me. I applied to Corporate Architecture. A week later, I only did a one-hour technical interview with two managers (belonging to different teams) before I was congratulated that they were working on an offer.

Finally, another week later, while they were still working on the offer, I decided to accept an offer elsewhere.

Describe a project that you worked on and sketch out its design.

How to speed up writing an in-memory table to a file?