I had a phone interview, followed by an online test, followed by a round of in-person interviews. The questions were fair and there weren't any tricks. Folks seemed genuinely interested in me and my experience. The test was mostly related to excel and sql formulas.

Had a call with the recruiter first. Was asked as many questions as could be fit into 30 minutes. I felt I answered the questions well, and overall had a productive interview. I then was asked to complete an online test. It had 4 sections and one section's questions built upon previous questions. Needless to say if I got one wrong, I got them all wrong. It was a very tricky exam, and I assume I failed, as I was not asked to move on to the next round of interviews. One of the prerequisites for the job is a CS degree, and the effort I put into getting that wasn't taken into account, or my on the job-experience, project work and communication skills. It is very demoralizing. I assume the same unrealistic expectations are faced when working for the company.