The interviewer was less experienced than me. Zepto should give interviewers who are skilled and have more experience than the candidate.
They asked four easy SQL questions, where they pasted the questions from LeetCode and ran the solutions I provided on LeetCode.
They asked me to design a streaming data pipeline, which I guess was part of their use case. They weren't ready to hear anything apart from what they might have seen in their project.
SQL-like: left anti join, join, window function
The following metrics were computed from 1 interview experience for the Zepto Data Engineer III role in India.
Zepto's interview process for their Data Engineer III roles in India is extremely selective, failing the vast majority of engineers.
Candidates reported having very negative feelings for Zepto's Data Engineer III interview process in India.