I had to write SQL and python code based on the questions provided.
Sr Data Analyst Interview Questions
2,902 sr data analyst interview questions shared by candidates
What are some common challenges one comes across when parsing data and how would they be handled?
what is the distance between bangkok and london?
a test for numerical reasoning stf
The interview was rescheduled 2 times just before the scheduled time. The interviewer asked 2 SQL questions. The 1st question, I solved by self-join but I explained to him, that we could solve it by lag and lead, and then he asked to me write code for lag and lead. I have written the same. Then for 2nd question, He asked me, if there were 2 tables, one table had detailed data ( very heavy ) and 2nd table had only some details. He said we can't run a query on Table 1 because it's too heavy. I have answered for both tables. He said give me more way, I said, I am not aware of it, could you please let me know. Then he suggested we join both tables and give aggregate conditions during the join and where clause. I was not sure, as per my experience we can't give aggregate conditions during the join and where clause, so I have written dry run code to validate the answer. select *from table_1 as t1left join table_2 as t2on t1.c1 > max(t2.c2) select *from table_1 as t1left join table_2 as t2on t1.c1 = t2.c2where t1.c1 > max(c2) At last, I said, as per my information these are against SQL fundamentals, I might have less experience but i am confident on my answer. Then the Interview was completed, HR was also in call during the interview. I forgot to ask 1 question, when you are saying we can't run a query on table_1 then why are we joining both table? Thanks.
Build a BI dashboard to help a film producer choose a director for a new movie.
They asked About SQL querry
Absolute max 10 out of 10 difficulty, because I had to interview myself i.e. ask all the questions. The Maxar people were completely unengaged (probably reading emails the whole time), when I saw that they had no questions for me and that we were just having awkward silences, I enabled my abusers like I always do and kept the conversation going with questions about their problems and all their current procedures. Completely brutal level of difficulty, I had to keep thinking ahead to see how I could keep the conversation going. Obviously I did not get an offer, this was a situation where they already had somebody but had to go through the motions of talking to a few other people.
How would you improve app ratings in app store? What is a p-value? What happens when you change the significance threshold for p-value? Interviewing here was an absolute nightmare. My interviewers had no idea what stage of the interview process I was in and also got frustrated at me during a problem solving exercise because I asked a clarifying question. Would not recommend going through this process at all. Worst interview experience in my entire career.
Technical question - What’s your experience of using excel and what are some functions you use to manage large data sets
Viewing 2811 - 2820 interview questions