Interview Questions...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Interview Questions - Please suggest some

51 Posts
32 Users
0 Reactions
88 Views
Posts: 13369
Full Member
Topic starter
 

I have to help interview someone for a Senior Data Architect role.

There will be someone with him doing most of the interview and I will be on the phone expected to ask some pertinent and probing questions.

Any suggestions for questions?

If anyone on here thinks they are going to be in the interview - use the words [b]Baby Robin[/b] at some point in the interview and I will make sure you get the job.


 
Posted : 07/04/2014 1:23 pm
 Drac
Posts: 50352
 

"What are you wearing?"


 
Posted : 07/04/2014 1:27 pm
 scud
Posts: 4108
Free Member
 

Can you remember the following list:

Black, no sugar.
2 teas, one with sugar
3 white coffeers, two with sugar.

Or the one i always hate "tell me the best thing about you and your biggest fault" so you have to scramble to try and turn the negaive to a positive.


 
Posted : 07/04/2014 1:30 pm
Posts: 12
Free Member
 

My two favourite slightly odd questions:

What makes you want to jump out of bed in the morning?
What keeps you awake at night?

And obviously: are you any good with broken ankles?


 
Posted : 07/04/2014 1:36 pm
Posts: 12072
Full Member
 

Technical or general interest questions?

* What differences are there between Oracle and MS databases? (Or whatever DB the candidate's mentioned on his cv). Which do you prefer?
* Define "big data".
* How does data architecture change with scale?
* Tell me about the biggest misuse or misinterpretation of data that you've seen recently in the press.

More:
* Do you think that NoSQL is being over-hyped at the moment? Or the interest justified?
* When would you chose NoSQL over a relational database?

* Tell me about the last time you had to make a significant change to a production database.


 
Posted : 07/04/2014 1:39 pm
Posts: 12072
Full Member
 

And obviously: are you any good with broken ankles?

* Tell me about ladders, and the secure use thereof.


 
Posted : 07/04/2014 1:43 pm
Posts: 13594
Free Member
 

So, you've got to design a database system for all the NHS's data and the system architect has suggested 64 bit Excel as the framework. Talk me through the next steps......


 
Posted : 07/04/2014 1:43 pm
Posts: 13369
Full Member
Topic starter
 

wow - I wasn't expecting useful answers. Thanks Molgrim I will be using some of those


 
Posted : 07/04/2014 1:43 pm
Posts: 92
Full Member
 

If you're a techie in their area, come armed with some of the challenges you faced last week! I interview software engineers and that approach can work really well.

If you're not techie in the DB domain, mogrim's questions are good ones, but make sure the interviewee understands he has to explain his answer in terms you can understand.


 
Posted : 07/04/2014 1:49 pm
Posts: 50252
Free Member
 

What would you do with a unicorn?


 
Posted : 07/04/2014 1:54 pm
Posts: 12072
Full Member
 

If you're not techie in the DB domain, mogrim's questions are good ones, but make sure the interviewee understands he has to explain his answer in terms you can understand.

Good point, be wary of asking for technical differences between Oracle and SQL Server if you don't know what a tablespace is, for example... Although a fairly senior role like an architect should be able to explain this in terms that a pointy-haired manager can understand, of course.

Personally when interviewing I like nice, open questions - it gives the candidate a bit of space to show his or her knowledge, you can then ask for more details on particular areas of interest.


 
Posted : 07/04/2014 1:55 pm
Posts: 22922
Full Member
 

Ask the candidate to nominate which members of the they would Shag, Marry or Kill. They will have 30 seconds to make their nominations and if offered the post they'll form the basis of a binding contract.


 
Posted : 07/04/2014 1:56 pm
Posts: 0
Free Member
 

What do you most fear about this job?

What do you think I am thinking about you after your last answer?

What's the best thing you have learnt about yourself in the last year?

And a sweeper for the end....What's the one question you wished I'd asked you today, and why do you wish I'd asked it?


 
Posted : 07/04/2014 1:59 pm
Posts: 12072
Full Member
 

What would you do with a unicorn?

A tough question to answer, a horny problem indeed.


 
Posted : 07/04/2014 1:59 pm
Posts: 13369
Full Member
Topic starter
 

[i]Personally when interviewing I like nice, open questions - it gives the candidate a bit of space to show his or her knowledge, you can then ask for more details on particular areas of interest[/i]

Me too.

I am reasonably techie so can ask questions and understand the answers. Just looking for something different to my standard ones.

I normally ask a techie question to get the techie answer and then ask them to answer it again as if I was a non-tech customer just to see if he can switch between vocabularies.


 
Posted : 07/04/2014 2:00 pm
Posts: 8819
Full Member
 

What filesystem would you use for storing large amounts of publicly available pornography and why?

I don't think that there's a right answer, but it should be fun hearing the thought processes.


 
Posted : 07/04/2014 2:07 pm
Posts: 77347
Free Member
 

Or the one i always hate "tell me the best thing about you and your biggest fault" so you have to scramble to try and turn the negaive to a positive.

Or, go prepared into an interview. The only reason you'd have to 'scramble' for an answer to this question is if you'd never had an interview before and didn't have an Internet connection.


 
Posted : 07/04/2014 2:14 pm
Posts: 0
Free Member
 

1.Have you got a sister?
2.Is she fit?


 
Posted : 07/04/2014 2:35 pm
Posts: 0
Free Member
 

How many chickens are alive at any one time in India?

(It's a through-process logic question - they talk you through their method of arriving at a proximate number)

Candidate A ) Er... quite a few I guess, maybe a few million?

Candidate B ) Chicken is a popular source of meat in developing countries; the population of India is X; average family size of 5; etc etc.

Now which candidate would you be interested in?


 
Posted : 07/04/2014 2:45 pm
Posts: 0
Free Member
 

A friend was recently asked at a job (lecturer) what book he'd recommend every undergraduate read.

mogrim - Member

* What differences are there between Oracle and MS databases? (Or whatever DB the candidate's mentioned on his cv). Which do you prefer?
* Define "big data".
* How does data architecture change with scale?
* Tell me about the biggest misuse or misinterpretation of data that you've seen recently in the press.

I'd answer the last question with reference to people's obsession with trying to define big data™


 
Posted : 07/04/2014 2:53 pm
Posts: 12
Free Member
 

How many chickens are alive at any one time in India?

I once had 30 minutes to establish whether it was better to run or walk cattle through a meat processing plant.

Solved it in just under 20 mins. Would have been quicker, but us lawyers aren't known for our mental arithmetic.

How many chickens are alive at any one time in India?

How many footballs can you fit in a London taxi?

(These are famously the types of questions techy people are asked in interview for jobs at Google.)


 
Posted : 07/04/2014 2:55 pm
Posts: 0
Free Member
 

[url= http://www.wikihow.com/Spot-a-Pathological-Liar ]How to spot a pathological liar[/url]


 
Posted : 07/04/2014 2:59 pm
Posts: 91000
Free Member
 

I should apply to Google then cos that sort of thing is right up my street!


 
Posted : 07/04/2014 2:59 pm
 IHN
Posts: 19694
Full Member
 

[i]How many footballs can you fit in a London taxi?

[/i]

"I've no idea, I've never tried. Or did you mean 'what is the maximum number of footballs that could be fitted into a London taxi'?"

if they're after techies, they're after pedants 😉


 
Posted : 07/04/2014 3:03 pm
Posts: 117
Full Member
 

If a movie was being made of your life and you could
choose the actor/actress to play you, who would you
choose and why?


 
Posted : 07/04/2014 3:12 pm
Posts: 8819
Full Member
 

Ok then, how about: Why are manhole covers round?

I got asked one about telling time with two lengths of rope that burned with different, random burn rates. I didn't get the job and gave up on that one a while ago.


 
Posted : 07/04/2014 3:17 pm
Posts: 19434
Free Member
 

To see if you want him to work with you, you may need to find out his attitude.

Q: "Do you do as you are told?" If yes, why? If no, why?

If s/he answers yes and justifies his/her answer then s/he might not an independent thinker.

If s/he answers no and justifies his/her answer then s/he might be a trouble maker.

(If s/he sticks to your question of yes this or no that but forgot the in-between answer then s/he might not be the person that can search for solution outside of the norm) If s/he gives you the in-between answer then s/he is might be indecisive.

Whatever ways you win. You now have to decide what type of person you want to work alongside you.

🙂


 
Posted : 07/04/2014 3:20 pm
Posts: 13594
Free Member
 

Q: "Do you do as you are told?" If yes, why? If no, why?

I always say yes (when I'm told to do something) and then just do what I feel like regardless.


 
Posted : 07/04/2014 3:23 pm
Posts: 0
Free Member
 

With all this talk about 'football:taxi ratios', 'manhole cover engineering' and 'rope burn rates', are you not in danger of simply employing someone on the basis that they can talk bollocks in a coherent manner?


 
Posted : 07/04/2014 3:30 pm
Posts: 10761
Full Member
 

employing someone on the basis that they can talk bollocks in a coherent manner

Is he hiring for a role in management consultancy?


 
Posted : 07/04/2014 3:34 pm
Posts: 341
Free Member
 

How did you feel when you last got moderated, and how did you overcome the feeling of anger and helplessness when you where banned for a period of time.


 
Posted : 07/04/2014 3:38 pm
Posts: 19434
Free Member
 

footflaps - Member

Q: "Do you do as you are told?" If yes, why? If no, why?

I always say yes (when I'm told to do something) and then just do what I feel like regardless.

But then I usually probe further to find out the reason(s) sometimes by being the devil's advocate to see if the person can reveal his true nature. I might even thrown in a few scenarios to see how the person deal with that problems.

You can read the person by simply looking at their facial expression under pressure. I like putting them under pressure.

:mrgreen:


 
Posted : 07/04/2014 3:46 pm
 DT78
Posts: 10064
Free Member
 

I presume you will already have a techie in the room to ask those questions...

If so I would be focusing on trying to find out what type of person they are, whether they would work well with you and your existing team, whether they would work well with your stakeholders.

Ask them how they would explain something fairly complex, like big data, to a Developer. Then how would they explain the same term to a Product Manager. How would their approach change, and why?

edit - you said that up there already!


 
Posted : 07/04/2014 3:49 pm
Posts: 3985
Full Member
 

Who would win in a fight, a badger or a baboon? And why?


 
Posted : 07/04/2014 3:51 pm
Posts: 19434
Free Member
 

BillOddie - Member

Who would win in a fight, a badger or a baboon? And why?

It will be a draw. The badger is powerful but dumb whereas the baboon is clever but not as strong.

There my answer.

:mrgreen:


 
Posted : 07/04/2014 3:55 pm
Posts: 13369
Full Member
Topic starter
 

Well he seems nice enough and admitted when he didn't know something. Didn't mention the Baby Robin even when given the perfect opportunity.

Do we hire him?


 
Posted : 07/04/2014 3:59 pm
Posts: 10761
Full Member
 

NO hire me! I'm nice enough too and will admit I know nothing any time you ask me something I don't know, which might be a lot of the time if it's databasey stuff, but I do know about baby robins and unicorns.


 
Posted : 07/04/2014 4:01 pm
Posts: 13369
Full Member
Topic starter
 

Interesting one of my questions was "Are you a pragmatist or a purist" so you would have been in with a real chance!


 
Posted : 07/04/2014 4:06 pm
Posts: 10761
Full Member
 

😀


 
Posted : 07/04/2014 4:08 pm
Posts: 77347
Free Member
 

Interesting one of my questions was "Are you a pragmatist or a purist"

I think if I were the interviewee I'd have asked you if you'd got that from the Bumper Book of Awkward Interview Questions.


 
Posted : 07/04/2014 4:14 pm
Posts: 0
Free Member
 

Do you like marmite?

(Obviously they don't get the job if they don't like marmite.)


 
Posted : 07/04/2014 4:15 pm
Posts: 9136
Full Member
 

It will be a draw. The badger is powerful but dumb whereas the baboon is clever but not as strong.

No way would it be a draw! Badgers are nails, but so are baboons, and they're bigger and fast-moving with a much bigger (and still sharply-fanged) gob.

Baboon all day, all night and all next day, no problem.


 
Posted : 07/04/2014 4:26 pm
Posts: 13369
Full Member
Topic starter
 

English common badger or Honey Badger?


 
Posted : 07/04/2014 4:35 pm
Posts: 8819
Full Member
 

Did you not ask the "29er, 650b, or 26"?" question?


 
Posted : 07/04/2014 4:35 pm
Posts: 5686
Full Member
 

How did he answer the Pragmatist question then? I'd have had to think about that as it's not like there is a right answer, is there?


 
Posted : 07/04/2014 4:47 pm
Posts: 13369
Full Member
Topic starter
 

Good point - When I asked him about (database) sizing he never mentioned that 650(M)B brings your data to life.


 
Posted : 07/04/2014 4:47 pm
Posts: 0
Free Member
 

What would you do with a unicorn?

What wouldn't I do with a unicorn? Filthy buggers.

Best wishes WCA. Hope you're well...


 
Posted : 07/04/2014 7:48 pm
Posts: 13741
Full Member
 

[img] http://www.ethicaljobs.com.au/blog/would-you-rather-fight-a-horse-sized-duck-or-100-duck-sized-horses/image_mini [/img]

[url= http://www.glassdoor.com/blog/25-tough-interview-questions-uk-edition/ ]Would you rather fight a horse-sized duck or 100 duck sized horses?[/url]


 
Posted : 07/04/2014 9:15 pm
Posts: 13369
Full Member
Topic starter
 

[i]How did he answer the Pragmatist question then? I'd have had to think about that as it's not like there is a right answer, is there? [/i]

Not that well, he sort of dithered and then said a bit of both.

In my opinion the correct answer is along the lines of "Which ever approach is the optimum for the given situation as by nature I am a pragmatist"


 
Posted : 07/04/2014 9:24 pm
Posts: 396
Free Member
 

I once had 30 minutes to establish whether it was better to run or walk cattle through a meat processing plant.

Lawyer you say? - surely the point of the question was to determine how many hours you intended to bill for answering a 30minute question?


 
Posted : 07/04/2014 11:56 pm
Posts: 17
Free Member
 

adds a few more to the potential interview question list.

You also have to remember that the interview is a 2 way process (well maybe in better times) I'd avoid the questions that make it look like you just googled for stupid interview questions. Fastest way to put people off working there, one guy I worked with did that and circulated his "Awesome" questions for the rest of us to look.

I'd think something from the Expert video that was on here last week on how do you deal with explaining technical information to non technical people who are also customers without offending them or throwing them out of windows.


 
Posted : 08/04/2014 12:06 am
Posts: 77347
Free Member
 

I'd avoid the questions that make it look like you just googled for stupid interview questions.

"You have 20 minutes to find out whether you want to spend the next several years working with me, you can ask me anything you like and that's the best you could come up with?"


 
Posted : 08/04/2014 8:06 am

6 DAYS LEFT
We are currently at 95% of our target!