Fetch Senior Analytics Engineer interview questions

Awful. I was given a take home assessment that would have honestly taken me like 30 hours lol (have to create a git repo, unpack horribly formatted JSON, explore data, create a data model, build basic SQL queries, make a presentation?, add documentation to GIT Repo, then write a slack message explaining your analysis to someone non technical? RIDICULOUS take home exam). The worst part is that I message the recruiter asking for clarifying questions about the role before I started this insane assignment (like what is the salary range, is job hybrid or remote, etc.) and had no contact. I don't think Fetch is serious about filling this role - I think internally some recruiters are just getting paid to just conduct interview and send take homes, and I feel like the people interviewing aren't serious about hiring someone either as per other Glassdoor reviews.

First off, I had to spend about 30-40 hours completing a homework assignment around building a project that solved the following questions: Review unstructured JSON data and diagram a new structured relational data model * Generate a query that answers a predetermined business question * Generate a query to capture data quality issues against the new structured relational data model * Write a short email or Slack message to the business stakeholder Nowhere in the interview did this work get reviewed or acknowledged. Odd, but whatever. Next, I talked with a couple different recruiters and the hiring managers. Once I passed their sniff test, I had an interview with some business analysts to write some psudocode based on whatever data problems they threw at me. I was then invited do an all-day interview that was broken up into a meet-and-greet, one-hour leetcode type question, one hour SQL test, one hour data architect review and question/answer. I spent a week brushing up on DSA questions. The question I was asked to solve was "build a LRU cache". Whelp, as a data analytics person, I have never done that, but gave it hell. I got 70% or so of it, but withouth Google, I couldn't complete it. Next was a series of SQL questions. I got to the very last question (everything above that question was a breeze), and was mostly done, running low on time and my interviewer said, "that's good enough". Finally, I was interviewed by their data architect who asked me to design a data warehousing model from prod -> data mart. With some deeper questions on storing data in s3, partitioning the data, and how to do advanced aggregations. The S3 stuff was something I have only read about, so I bombed all that. The last stage was to circle up with the hiring manager, who told me I failed all three segments and that they weren't going to move forward. I feel that the process was a colossal waste of time considering the breadth of questions. I feel like I was able to showcase my strengths, ask good questions, and do all the things you're supposed to do. Instead, this whole thing was a pass/fail exam style interview.