SQL questions in phone and on-site interviews; know groupby, aggregate functions, etc. I recommend studying using HackerRank and LeetCode; when your query works, check others' submissions because theirs may be more performant and cleaner. I didn't get the job because I didn't pass the SQL bar, but I think that if I did more HackerRank and LeetCode problems, I would've passed the bar.
Python (but could be any programming language that you're most comfortable with) questions specifically on numerical packages like Pandas
How do you handle working under pressure or with tight deadlines?
A lot of the questions aimed at ensuring candidate is a good fit for the company's value. Their technical assessments and presentation are not too difficult, but are decent challenge in SQL and data analytics/visualization.
How would measure the performance of a new feature launched in the product
Difference between where and having? Difference between Inner join and outer join?
Where do you see yourself in the company?
How do you think your experience matches with the roles and responsibility for the position you're applying for?
Introduce yourself? What is data?
talk about the subjects
Viewing 2161 - 2170 interview questions