1. Describe an analytical project when I used SQL to get data and solve a business problem. What metrics did I look into? How many datasets did I work on? How many records did they have? 2. Live code: 2 SQL coding questions that required knowledge in join tables and subqueries
- Team, Role and Responsibilities walkthrough (5 min) - Tell me about yourself (5 min) - I talked about my specializations, success story, strengths and what I am looking for in the next role. - 5-6 easy/medium level SQL questions on Live Code (based on Aggregate functions, JOINs, Windows Functions - Rank, Dense Rank (15-20 min) - Questions were based on two tables that had team, product and revenue data - I was able to write queries for all of them - 3-4 Behavioral Questions with follow up questions on improvements and impact (15-20 min) - It's very important to follow STAR methodology while answering the question. I kept missing on pointing out the result/impact from the situation/task and used 'we' instead of 'I' when talking about the tasks I have worked on which is very important for the company as they want to see if you took ownership (is a leader) or not. - Questions from candidate (5 min) - Asked them about the team, what does day to day look like.
Pretty standard questions regarding previous roles with a few excel questions.
One of the thing the interviewer ask me is how well I know excel?
What actions could you take if it appeared a sales target would not be met?
What do I see as a weakness and how have I worked on this?
Describe a time where you analyzed a data set
What do you see as the main challenges facing Salesforce over the next five years?
They first asked me the classical behavioural questions like "when were you under pressure? what did you do?" and stuff like that. The last true test I did was a business case (the panel interview). I had to answer a question by analyzing some data they sent me, and preparing. ppt based on the structure they gave me
Standard questions, no curveballs.
Viewing 901 - 910 interview questions