Can you walk me through your past experience and highlight key projects you’ve worked on? How do you usually handle conflicts or disagreements at work? In your current/previous role, how have you leveraged AI or data science to create impact? Why are you interested in this role, and what motivates you to join our company? What are your main reasons for looking to transition from your current job?
SQL
-Tell me about a time you had to solve for a problem but didn't have enough information - Calculate 3 month moving average using pandas - 3 tables and 3 SQL questions to solve for - joins, window function , aggregation, etc.
Previous projects and sql. Interviewer was less experienced person who brought incorrect sql tables. Customer table had payment id as primary key instead of customer id lolz.”
What frustrates you about work?
What experience has prepared you well to pursue a role in data analysis?
Describe the difference in join types in a SQL environment.
What programming language do you use most frequently?
Mostly behavioral, why I was interested in the role, and some specific questions about my background
They gave one requirement and asked me how I would write SQL query. The requirement had 2 tables. Asked about the difference between rank and row_number function. One more question was to explain a python code and improve the code for edge condition.
Viewing 501 - 510 interview questions