A musician put it in time for an audition because that will be the piece he will be performing. But doing leetcode when the job definition is: You will be working on this e-commerce site is not the most motivating things. While algorithms and data structure knowledge are important, most of the time is spent writing code gluing data sources to interfaces. I'm perfectly fine doing an interview on the technologies I'm expected to master, but knowing by heart how to sort strings doesn't help anyone, IMO.
Minor bikeshedding, but orchestra auditions are more about measuring musicianship at various time constraints: sight reading - O(minutes) of prep, audition excerpts - O(days) of prep, and personal repertoire - O(months to years of prep).
By and large, professional musicians are paid for a standard level of performance competence and a strong level of versatility. The small handful of remainders are the famous ones renown for exceptional levels of performance.
Plenty of professionals are paid to play the musical equivalent of e-commerce site.
It feels more like auditions for tech involved being assigned a random instrument, even though you've been playing flute for ten years and they are hiring because they need a flautist.
Pushing the metaphor further is surely silly, but I'd compare s/w dev to jazz improv or the ability to deftly adopt the musical expressive style of a new ensemble, and s/w design to musical composition or arranging. Switching instruments is more like switching programming languages or stacks. Presumably appropriate auditions should assess these complex skills and not rudimentary fare like scales or key transposition, AKA leetcode.
> most of the time is spent writing code gluing data sources to interfaces
Pretty much anyone can do that. We’re looking for someone who can do the other 20% of the job that’s novel and difficult. Ideally someone who recognizes that rereading glue code is a waste of human effort, and automates it away instead.