HI i have recently gone through an interview in samllon india company which is a goolges 3rd party company providing data analytics to google chrome, youtube and other verticles of the google data centers
there are 2 task i have been given
1:- transformmation of excel data from one form to another from with the help of SQL
it has included the data cleaning, deletion of duplicates, information gathering and trasnfromation.
2:- I have given some mock sales data in google sheet file with complex data including 20+ columns, which i need to create a dashboard on google data sudio (looker).
basically i need to visualise those data in readable formates and make it to look like easy to understand on file.
and after these task completion i have go thorugh 3 round of interview
1 is technical round where is SQL knowledge has tested.
2 manager round where the verticle manager has asked me questions about competencies of working in this role
3rd was HR round.
thats it.