it was a join on a moving average windowed function. Be sure to brush up on that, and on your python.
Sr Data Analyst Interview Questions
2,956 sr data analyst interview questions shared by candidates
Pretty standard questions, not too difficult. The SQL assessment consisted of 3-4 tasks of various difficulty (nothing fancy though)
Do you know about the different SQL Joins? How would you communicate to nontechnical stakeholders?
Tell me about past experience with forecasting
What is your availability the next 2 weeks
Many questions about culture fit and situations about how you would engage with challenging problems. It was important to know your strengths and weaknesses and show a willingness to grow.
Write the SQL queries for questions
cases are common product sense and math calculation regarding credit card, ads, atm banking, etc. bq are common questions like tell a time when you disagree with leader/teammate, tell a time when you are innovative to solve a problem, etc
tell me about a time when you handle a challenge
Basic SQL, data analysis, dashboarding, etc
Viewing 2321 - 2330 interview questions