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, (?)
Why have you applied to N26?
What you do in your free time? Do you visited the company website?
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.
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.
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
1. Given a choice of 10 potential experiments, how do you determine which ones to do? 2. Say we tried experiment X and failed to generate the returns we’re looking for, how do you diagnose the issue? 3. Given what you know about Canva, what would do if our current growth channels plateaus? Why? 4. Look at and explore www.canva.com. What are 5 things you’d do to grow active users? Include your math. 5. Let's say the CEO asks you if searches are up on the weekends year over year? You check the data and they are. What else do you look at before you communicate your findings? 6. Let's say you see data that looks at email sends by user state for a specific email: Dormant (not in last 30 days) 5% Core (DAU) 45% Casual (WAU) 30% Marginal (MAU) 15% Resurrected (wasn't in last 30 days, then came back as WAU) 5% 7. Let's say you walk in one morning and see a report that says signups from a particular channel drops 20% day over day? What do you do to identify the cause? 8. A colleague suggests we should send more emails to drive growth. How do you determine if we should do it? 9. Let's say Canva is considering is considering an additional business model that allows new users to use unlimited amount of design elements for a single subscription price. How do you determine its potential impact? 10. Let's say Canva asks you to figure out which locale the International team should establish a local presence in. How would you go about answering this question and why? 11: Let’s say a colleague suggests we should double our customer service because it’s important. How would you verify such claims? 12. What do you think is the most thought provoking article about data that you have read? 13. What is one thing you think is right that most people don’t agree with you about? (this is not a nice-to-have question)
8. A colleague suggests we should send more emails to drive growth. How do you determine if we should do it?
Viewing 1 - 10 interview questions