The interview had 3 rounds: an online test (MCQ), a technical interview, and an HR interview.

The online test had around 30 questions, none of which were related to my job profile. I chose random options and was sure I wouldn't make it to the next round, but somehow I did.

The technical interview was not really that good. I was asked very basic questions about Redshift and SQL. It lasted for not more than 15 minutes. In the end, the interviewer also mentioned that the job roles and responsibilities are not that complex. It almost felt like they just wanted a resource, no matter the level of intellect.

In the HR round, I was asked about my expected CTC, notice period, and all that basic stuff. When I told her about my expected CTC, she seemed okay with it and didn't even ask me if I was ready to negotiate.

Next, I was asked to submit all kinds of official documents over the span of one week. After a lot of back and forth regarding the documents and payslips, 2 weeks later I was offered LESS than my current CTC. If they had no plans of offering my expected CTC, at least I should have been informed about it beforehand so that I could negotiate a little. But offering less than what I am already getting after taking all the documents from me and making me fill a super long form was pathetic in my opinion. When I asked for the reason, the HR said that's all they could pay and couldn't increase. What was the point of the interview and wasting my 3 weeks then?

Let me tell you, it takes a lot of effort to fill their application form. It was truly the worst interview experience for me.

Difference between rank and dense_rank