HCLTech Assistant Manager - Analytics interview questions

2 Rounds of interview: 1st Technical: (sql medium level questions) Joins, having, group by , window functions Do you know how to create a table from google sheet in GCP/Bigquery? What is the minimum time gap you can schedule a query to run in bigquery? Answer: 1 Hour What is the mail ldap you need to provide access to for your sheet so that table can be created? Answer: Slurpee How would you find root cause of an issue which is affecting deadline of your project? What is your day to day activities look like in your current role? Round 2: Techno functional round How do you normalize a big table? How do you use unnest in bigquery to resolve javascript type data type? Explain in detail one project you did in your current organisation which you handled alone from end to end. How did you manage tight deadlines in a fully occupied weak?