I applied through a recruiter. I interviewed at Tredence
Interview
Be prepared to face a disrespectful HR typical of an Indian startup seeking H1B slaves for USA positions. I had 3 rounds: a senseless puzzles round easy to crack by looking up answers (search Google interview puzzles; p.s.- Google stopped doing these year ago realizing the inefficacy of puzzles) online and pretending to solve on the phone; Round 2 is technical, simple SQL queries and some coding/statistics questions; Round 3 is business round with questions such as what a CEO's dashboard should contain; how would you launch a product, etc.; Round 4 is with a C-level executive that I was promised but never had because the HR couldn't match my current salary; hence just vanished out of communication.
Interview questions [1]
Question 1
From a single column of cities; what SQL query would you run to make a column of city permutations? e.g. A,B,C,D input--> A-B, A-C, A-D, B-A, B-C, B-D, etc. as output.