One phone interview and one onsite interview. The whole process takes two weeks. The phone interview takes 25 minutes, basically just going through the resume and some basic questions. During the onsite, I had six interviewers one-on-one, each taking 30 minutes. The routine is first personal questions based on the resume, then some tech questions.

This position basically requires Python and SQL.

The interview questions are fairly simple, but include all the topics.

Remove duplicated characters within a string.

Select only duplicated rows from a specific table.

Difference between self join, left join, right join, and outer join.