One cons with their whole process was the time they take to schedule all the rounds. They took more than a month and multiple back & forths just to schedule 3 rounds. Round 0 was a HackerRank test with 4-5 SQL questions and 1 python question. Then, there's a recruiter screening round followed by Round 2, which consists of a General Coding round and a Data Coding round. For the General Coding round, we had to execute the python/java code and show the output. Both my panels for the General Coding and Data Coding rounds were from the US so the interviews were scheduled at night IST. The General Coding interviewer was helpful and hinting towards edge cases. For the Data Coding round, they rescheduled it once because the panel didn't show up the first time. Even after rescheduling, I was looking forward to the Data Coding round but the interviewer seemed inexperienced (even though he was experienced professionally with work experience at multiple orgs) and was confidently uttering a few incorrect things and didn't clearly specify his expectations. For this round, the main expectation that the interviewer never set for me was that he was evaluating all the SQL answers from the lens of "How would this SQL query behave at scale on Spark?" while I was answering it from the lens of "How would I solve this question analytically in SQL?". With respect to this, for one question, he said that we can use CTE, to which I replied that CTE's are only for readability but he replied that CTEs in Spark would force the pre-aggregation to be performed before (while this is factually correct, he never mentioned that he was evaluating & expecting from the pov of executing it in Spark, but expected me to answer that!). At one point, I had to make answers which he wanted to hear, regardless of whether my initial answer was correct or not. For one of the simple questions I knew I had correctly answered, he kept me wondering if I had correctly answered it. I'd say my luck was bad that I got this interviewer panel. I got rejected at this point as I had expected.