The hackerrank was a SWQ, algorithm, and code review test. The OA had a live simple whiteboard problem to solve. The SQL interview wasn't too bad as someone who doesn't use SQL much, but it was all windows function based. The investigative interview tasked me with how I would go about using data to track fraud in different situations such as mortgage bonds and such. What I would recommend investing in given 2 options, ect.