First round: A short technical screen with a recruiter. The recruiter is not a technology expert; they have 20 questions with 20 answers in front of them. These are usually simple questions like, "What do you call a function that calls itself?" (Recursive function).

The 20 questions from this round are split: 10 programming and 10 SQL. Very easy if you know the basics!

The next round is a technical interview with an experienced Data Engineer on Coderpad. Here, speed is of the essence. They'll ask you to choose which questions you want to start with first (Programming or SQL) and immediately begin.

Try to be quick, take into account all test cases, and get all test cases to pass! (Easier said than done, I know, but that's what they're looking for!)

I got 3 programming questions and 3 SQL questions in the 1 hour. I was able to solve all 3 programming questions and also all 3 SQL questions. However, I got stuck for about 10 minutes on one of the slightly tricky SQL questions involving a sub-query join. This was probably why I was rejected. :(

Also, the prep material they give is very basic and not really helpful for the kinds of questions they ask. I'd say look through the prep material once because it's really simple stuff, but practice programming and SQL on a service like LeetCode or HackerRank.

You have a 2-D array of friends like [[A,B],[A,C],[B,D],[B,C],[R,M], [S],[P], [A]].

Write a function that creates a dictionary of how many friends each person has. People can have 0 to many friends. However, there won't be repeat relationships like [A,B] and [B,A], nor will there be more than 2 people in a relationship.

Validate an IP address. Multiple test cases are given.

Check out other questions people have posted before me! They're pretty accurate too!