They will ask a person who has no experience of software development in their career to take a technical interview. Surely watch out the linkedin profile of the interviewer before the interview. If the interviewer has never done the job (Software development in this case) which he is interviewing for, that is a red sign. Such a person will see software development as black and white in their minds, but not as tradeoff. The fact is software development is a tradeoff, there is nothing called a perfect solution for every scenario. Unfortunately since my interviewer had no software development experience so he was very picky about syntaxes. For instance in the feedback its mentioned that candidate mentioned about cascade delete but didn't knew the syntax. another point he mentioned was "Candidate proposed to use JSON field to store product attributes". Which during the interview I mentioned about how things can be stored in a noSQL mongoDB sort of database. But it seems he took it in context of SQL. The baseline is such interviewers will have a fixed solution in their mind if you are checking all those points then it's a yes otherwise not.

passed initial screening, was given a game home hackerrank interview assessment that was similar to a leetcode mediums. very specific set of problem I was not able to answer. I was then ghosted by the company without a formal rejection.