Re:What not to do during an interview
by EdwardDiego on Monday June 30, 2014 @01:12AM
(#7963777)
> Don’t suck at something you say you’re an expert at
This one. If you say you are expert/advanced at X, we will check for some level of competence. It's amazing how many candidates with CVs claiming 'advanced SQL skills' don't know about the existence of the HAVING clause. An exaggerated CV is a very easy filter.
Re:What not to do during an interview
by andrewstuart on Monday June 30, 2014 @07:58AM
(#7964590)
I agree that people shouldn't exaggerate their skills but you need to be cautious about how you go about proving that they do not. It's easy to prove that someone is clueless by quizzing them about specific technical details or syntax. You will of course find something they do not know, but are you really trying to prove your own cleverness by catching them out? "You say you're an expert eh? We'll let me prove you're wrong and I'm smarter cause I'll ask arcane technical facts till I find something that shows you're not an expert!"
Re:What not to do during an interview
by EdwardDiego on Monday June 30, 2014 @11:25PM
(#7969037)
> I agree that people shouldn't exaggerate their skills but you need to be cautious about how you go about proving that they do not. It's easy to prove that someone is clueless by quizzing them about specific technical details or syntax.
I agree, which is why I gave GROUP BY HAVING as an example filter for 'advanced' SQL skills (especially as my team manages data warehousing and analytics).
It's not a minor implementation detail, it's the major tool for filtering on aggregated values - something like 'find customers who have purchased two more products in one month' can either be done as a query of an aggregated sub-query, or as one query using HAVING to filter for customers with a COUNT(*) > 2.
Again, this is only for people claiming advanced skills, and it's not that an 'advanced' feature. I don't expect every developer to know about SQL:2003's window functions, but HAVING has been around since at least 1992.
I agree with not asking silly technicalities, as a Java developer, knowing why new Integer(100) == new Integer(100) but new Integer(1000) != new Integer(1000) is an interesting piece of trivia, but using it in an interview is a waste of everyone's time.
Re:What not to do during an interview
by EdwardDiego on Tuesday July 01, 2014 @06:45AM
(#7969967)
That isn't a question on syntax, sorry. We'll have to very much disagree if you think this is just syntax. It's a core part of SQL that anyone with advanced SQL skills should at least be aware of.
Syntax would be caring if they put the ORDER BY in front of the GROUP BY.
Re:What not to do during an interview
by ap22213 on Monday June 30, 2014 @08:45AM
(#7964736)
Seriously - I remember once stating that I was skilled in Java (would never use the word 'expert', though).
The technical interviewers must have taken it as a challenge to them, as they spent 30 minutes quizzing me on all of the different executables that made up the JDK and all of the different arguments to them.
Re:What not to do during an interview
by andrewstuart on Monday June 30, 2014 @09:11AM
(#7964835)
I'm a recruiter and do technical interviews for a living. I almost never ask specific questions of syntax. You will incorrectly assess someone as not being knowledgable if your questions are about specific syntax and therefore possibly lose a great developer.
Re:What not to do during an interview
by drewying on Monday June 30, 2014 @02:28AM
(#7963959)
It's not a matter of it's a culture fit or not, it's a matter of showing that you care about the job.
We wear whatever the hell we want to at the office, but if I conduct an interview and the interviewee comes wearing jeans and a T-Shirt with holes, I problem will end the interview short and thank him for his time. If he doesn't care about this job enough to even make an attempt at dressing up then why waste our time.
Same with swearing. If you can't show to us that you care about this job enough to use professional language for an hour then I probably won't consider you past the first round. It's not whether we care about swearing, it's about proving to us you really want this job.
Re:What not to do during an interview
by mahmud on Sunday June 29, 2014 @11:53PM
(#7963618)
I agree. I was once interviewed by a company who asked me to look at a snippet of code and tell them what’s wrong with it. It was supposed to to be testing for a handle leak; open db connection without a corresponding close. But right smack dab in the middle was a SQL injection bug. As soon as they handed me the paper I let out a whispered “FUCK”. Everyone laughed, and the rest of the interview went well, up to the compensation package ;-)
Re:What not to do during an interview
by dllthomas on Monday June 30, 2014 @11:39PM
(#7969077)
"no one in her right mind will penalize you for not being immediately available"
Not deliberately, but depending on how bad they need to fill the hole, they may find someone good enough that they don't bother holding out to see if you're better...
This one. If you say you are expert/advanced at X, we will check for some level of competence. It's amazing how many candidates with CVs claiming 'advanced SQL skills' don't know about the existence of the HAVING clause. An exaggerated CV is a very easy filter.
I agree, which is why I gave GROUP BY HAVING as an example filter for 'advanced' SQL skills (especially as my team manages data warehousing and analytics).
It's not a minor implementation detail, it's the major tool for filtering on aggregated values - something like 'find customers who have purchased two more products in one month' can either be done as a query of an aggregated sub-query, or as one query using HAVING to filter for customers with a COUNT(*) > 2.
Again, this is only for people claiming advanced skills, and it's not that an 'advanced' feature. I don't expect every developer to know about SQL:2003's window functions, but HAVING has been around since at least 1992.
I agree with not asking silly technicalities, as a Java developer, knowing why new Integer(100) == new Integer(100) but new Integer(1000) != new Integer(1000) is an interesting piece of trivia, but using it in an interview is a waste of everyone's time.
Syntax would be caring if they put the ORDER BY in front of the GROUP BY.
The technical interviewers must have taken it as a challenge to them, as they spent 30 minutes quizzing me on all of the different executables that made up the JDK and all of the different arguments to them.
If it doesn't work out because I swear in the interview, it wasn't going to be a good culture fit in the first place. This goes both ways.
We wear whatever the hell we want to at the office, but if I conduct an interview and the interviewee comes wearing jeans and a T-Shirt with holes, I problem will end the interview short and thank him for his time. If he doesn't care about this job enough to even make an attempt at dressing up then why waste our time.
Same with swearing. If you can't show to us that you care about this job enough to use professional language for an hour then I probably won't consider you past the first round. It's not whether we care about swearing, it's about proving to us you really want this job.
If my employer won't swear in the interview out of principle, we are a bad culture fit.
Good tips.
Not deliberately, but depending on how bad they need to fill the hole, they may find someone good enough that they don't bother holding out to see if you're better...
Interviews are hard for some people.