Note: Don't waste your time on assignments !! The process involved solving a take home assignment which takes 5 day to complete. The problem requires solving complex bigquery problem with constraints. The problem took 3-4 days to solve completely and submitted through code file. Upon submitting the project, the team/interviewer didn't even reverted back with any feedback or received the project submission message. You give a long project to complete and didn't bother to take a minute to respond back. Felt like a scam to me. I gave the most optimized solution (not available anywhere on net) Opinion : Felt the team wasted and did not value my time.