I applied through the company’s careers portal and received a response within a couple of weeks. The process consisted of 3 rounds: an initial screening, a technical interview, and a final managerial round.

1st Round was online Assessment having 30 BigQuery Questions to be solved in 40 Mins, I was able to solve 26 question due to time constraints, overall question levels were Easy-Medium Difficulty. In 2nd Round the Interviewer couldn’t able to explain the question well and couldn’t tell what he is expecting from me, when I asked him what do you typically look in a candidate he replied “logic”, he also mentioned the doesn’t care about coding he looks for logic only, and asked about FARM_FINGERPRINT in BQ to create Surrogate Key Hash, It seems Hypocracy to tell that he doesn’t care about coding and asking a question on niche hash function. The Interview Revolved around Data Modelling Concepts and Scenarios. Like Strategy to Implement Surrogate Key, Star vs Snowflake, Fact vs Dimension and Implementing Views, Slowly Changing Dimensions II. 3rd Round revolved around my project and day to day in work and current architecture of the data platform I work on. Asked Question around query optimization and disaster recovery on production environment and Data Lake and Lake house design in my team. 4th Round they called me to re appear for online assesment, because during first round my face was not visible properly, This time i was able to solve 30 question with 30 seconds remaining.