Coinbase Software Engineer Interview Experience — Two OAs and a 90-Minute Database Design Coding Test

There were two OAs total.

One was a personality test and an aptitude test. The personality test had over a hundred questions, and some of them repeat — be careful not to contradict yourself between them. The aptitude test was very tight on time: figure relations, quantitative relations, vocabulary fill-in-the-blank, that kind of thing. It's hard to finish in time, so just guess when you have to.

The other one was coding. The questions were also ones you can find on the forum, not too hard. My set had four parts total, 90 minutes, each part worth 250 points. Design a database — you need to implement storing data and reading data. The second part adds a scan function, then adding an expiration time and backup. Each time you move to the next stage you can reuse the code from the previous stage — you basically don't need to modify much of the old code, just implement the method according to the instructions. Each part has some test cases; once you pass them all you move on to the next stage. If you only partially pass, you get partial credit.