The assignment was 3 large datasets and about 6 questions to answer. There was no real guidance, just get the answers however you could. I used SQL and Excel. It required a pretty high level of SQL knowledge. Then make 2 slide decks to present, one with your results and one with your methodologies. Like I said, it required many many hours of my life to complete.
Difficult to answer was the question whether I can come up with a very standard process and timeline for analyzing and fixing data errors in an unknown application.
Why do you want to change and rate yourself in SQL
expected salary
Do you know Spark? Have you used Big Data tools?
I would recommend reading the interview pack carefully and preparing for all possible questions.
1. Tell me about yourself? 2. How would you rate yourself in SQL? 3. Can you provide an example of a time you automated a reporting process? 4. Do you have any experience improving a process? 5. What is your thought process behind handling large data sets, what do you usually do first? 6. Why do you want to work here?
Q. SQL Fundamental questions. Q. STAR or PAR based behavioral questions Q. Tableau / Analytics fundamental questions.
Tell me about a time you were in a disagreement with your manager and how you’ve handled the situation
"Hmmm...what would be a good SQL question to ask you....hmmmm..." [eventually asked the difference between WHERE and HAVING]
Viewing 1631 - 1640 interview questions