Most of the questions were regarding my work experience so far. And a few logic questions like what is the angle between the hours hand and minutes hand when the time is 3:15; How do I identify which switch corresponds to which light bulb when the switches are in one room and the bulbs are in another and given that I can enter the room with bulbs only once.
4,23,68,101, (?)
The whole data analysis exercise was more involved and time consuming than I anticipated.
Why have you applied to N26?
Case Study: Choose any Google product. Now, 1) As a fraudster, why would you need to use the API of this product 2) As a member of the Google team, how will you ensure that these fraudsters don't take advantage of the product 3) As a fraudster how would you overcome the steps you took in part 2 mentioned above
Expect to get an easy SQL question but to be extremely fast in handling it. They will expect you to receive a few tables and go over all their descriptions (20~ terms), write the JOINs etc. as if you were previously familiar with all of their variables and tables in advance. So the key here is to be extremely fast because the rest is super easy and basic.
Sql Questions: 1. Write a query that returns the number of activities amd number of users by activity type and activity date 2. Write a query that returns for each user it’s forst and last activity timestamp and activity type 3. Write a query that returns for each date the number of users who were active (had an activity) and number of users who didn’t
Though I didn't not get the offer I would like point out the seamless interview process and one of good HR I have come across. 1 HR - The HR was very welcoming and asked questions based on shared resume. explained what is expected out of this job role and shared general interview process and timelines and guided for next round 2 Hiring Manager : Again a very good human being. I explained my past projects with STAR method and what I can contribute to this role with my current skillset and he also had some situational based questions, some product analysis questions 3. Hacker Rank : The interviewer was very helpful and explained me the process and timeline for each questions, but the interview Qs were prepared based on interviewers experience (Python, AI and ML) 80% of the questions was having python coding and (Though I had mentioned I do not have hands on experience in python coding in my previous rounds and its in my resume too) the job description also mentioned other skill set like Data Management, Data visualization and AWS data lakes and ETL which was not even part of the interview as mentioned in the preparation mail shared by HR coordinator. though there were 1-2 questions surrounding SQL but the interviewer was not interested in spending more time on those Qs I can understand lack experience might be the reason for it. I tried explaining my thought process wherever I couldn't do python coding, Advice to Talent acquisition team: 1. If you are looking for a particular skillset then add it as must have for the job role and dont add 10 supporting skillset to the JD. 2. If team wants versatile candidate on the team then please make sure interviewer possesses similar skillset or have some knowledge about it.
Why do you want to join as data analyst rather than opting for coding jobs?
The interview was more like an HR interview. Asked everything related to my life specially college time. No academics were asked.
Viewing 1 - 10 interview questions