They have a standard process set to take the employee assessment, which involves one detailed technical round, one managerial round, followed by HR negotiation discussion based on salary and location, etc.

What I understood is they have salary brackets defined for each and every level. They offer a very huge amount in variable pay, which makes your offer on paper very high. However, the actual payout or the per-month salary will not have a major difference (around 30%) when you compare it with your current CTC. Still, it depends upon the individual how to read the CTC part.

Moderate level interview questions on SQL, DWH concepts, and BI concepts.

1. Question like: If given a whole E2E project, what checks would you implement for the ETL and BI test pipeline?
2. Scenarios where data is in millions: How will you assure the correctness of the data?
3. Simple SQL questions: 2nd highest salary, etc.
4. How will you implement automation for BI projects?
5. DWH concepts: Data model, schemas, SCDs, etc.