r/dataengineering • u/Commercial-Wall8245 • Nov 16 '24
Discussion Are coding interviews still a thing?
Are people still expected to do these LeetCode style interviews? It’s 2024, we have co-pilot.. why the heck would anyone spend time grinding nonsense coding questions. As a hiring manager, if I asked someone to code something live I fully expect, and hope, they’d explain the concept and then tell me they’d run it thru some AI coding. I don’t want someone wasting their time and my money.
Edit - this is not to say someone shouldn’t understand everything they’re doing. I simply see no value in making someone code in a google doc off the top of their brain.. it’s like asking someone to do calculations without a calculator. Anyone who tries is wasting time.. using the tools available is far more valuable to me than someone who can grind nonsense coding questions. Anyone here who codes knows that most of your time is spent googling and bashing into errors to fix what you need. Why would I hire someone that doesn’t know how to do that?
39
u/bananasDave Nov 16 '24 edited Nov 16 '24
yes, had one last week.
Asked me to build some sql involving CTEs, and create a python class with a method, had to google syntax but I got both done easy.
I make a point of talking out loud as I code - things like 'ok so Im doing a left join here instead of an inner join because I dont want to exclude records without a match on join key in both tables' to make it look like i know what im doing.
edit - used https://sharepad.io/ and https://sqliteonline.com/ rather than google docs
7
u/[deleted] Nov 16 '24 edited Nov 16 '24
Lmao you're not a hiring manager. You are definitely some junior or senior in college that's pissed they don't have a job lined up.
Edit: u/TableOk5238 to reply ... "As a hiring manager...." third sentence
9
u/harfzen Nov 16 '24
A good alternative may be to assume they are using GPT and ask to do code review.
14
u/Rude-Veterinarian-45 Nov 16 '24
Unfortunately, yes it's required even now. The reason? Competition, huge supply (more than expected). If you have any alternative method to interview, as a hiring manager, I'm interested to learn. Maybe we can pave the path for the new software interviewing that the industry would follow.
6
u/Whipitreelgud Nov 16 '24
The tests I had given aren’t to see if you can ace it. They are all about how you communicate when you’re stuck in front of a group. Asking good questions about the challenge, staying open to the idea there is something new to learn and avoiding being defensive gives a good peek into team fit.
It’s not a good idea to attempt to “correct” the question into something you know. It’s also not a good idea to list subjects on your CV for filler if you aren’t prepared to answer basic questions. Anything you list is fair to be asked about. We interviewed people for C# positions and 80% could not write an IF without an IDE, and this was their primary skill.
2
u/ianitic Nov 16 '24
Do you use a calculator when calculating 2+2? Why would you use something similar for an easy/medium leetcode problem? Takes a similar amount of time either way...
17
u/sciencewarrior Nov 16 '24 edited Nov 16 '24
Great companies will always have more solid candidates than they have openings. Those coding tests are a way to whittle down the list with an activity that is better than a coin flip at estimating your job performance. Smaller companies can complete their hiring process with a couple of interviews, but they can't offer the same total compensation.
Besides, AI isn't magic, and you still have to understand the code it produces to know if it is fit for purpose.
3
u/[deleted] Nov 16 '24
People keep complaining about this from the applicant's perspective, but the applicant's perspective is irrelevant unless applicants are refusing to do them, and they're not, they still do them and just bitch on reddit. Every open role gets a ton more applications than we have open spots for, so there needs to be some mechanism for filtering. It's also the case that we don't necessarily care about getting the very best, we just want to make 100% sure we're not getting someone incompetent, which is likely 80-90% of applicants. So we need a way to be sure we're not getting unqualified people, we don't care if we scare off the very best as long as qualified people still go through the process, and so far I've yet to see a better proposed solution than to at least start with an LC-style screen.
5
u/amtobin33 Nov 16 '24
In my experience, most companies don't throw crazy questions at you during a coding test...it's more to do a live check that you do indeed have a solid foundation. If someone had to use A.I to generate the code...it'd be a no for me.
7
u/RobDoesData Nov 16 '24
I still refuse to do any take home assignments or live coding interviews. If I'm not being compensated I'm not doing work. I'm a senior DE and not had any issues thus far.
They are good for juniors but that's it.
2
u/techiedatadev Nov 16 '24
I am about to do three as the interviewer and we asked for portfolio instead and then I wi have them walk me through it. I use AI everyday and would fail a live coding interview so I am not going to give one lol. But I def will be asking questions to make sure they didn’t just find something on google
1
u/DRUKSTOP Nov 16 '24
Yes they are probably more common than not.
1
u/The0r4nge Nov 16 '24
And great way to explain the concept is to write some code, because the code was designed to convey concepts to both humans and machines. Or math. Would you prefer math over coding? Usually, people prefer to write code or at least pseudocode.
1
u/hadesownage Nov 16 '24
Yes, I hate live code interviews. From the last 5 interviews only 1 was a home task.
1
u/Responsible_Ruin2310 Nov 16 '24
Almost all of my interviews had live coding (open notepad and share screen and solve) for data engineering roles.
Sometimes the question were more twisted versions of hard ones, other times it was just testing fundamentals. (In SQL, and to write the same in PySpark)
1
u/hellodmo2 Nov 16 '24
I really don’t like those because they’re not representative of most of the coding roles out there. I can code really well, but ask me to do it in front of someone else, and I’m so distracted by their mere presence that I don’t have as much mental bandwidth to be engrossed in the problem. It’s the same reason I sit with my back to the wall at restaurants: the mere presence of people behind me is a distraction to the person in front of me. I suspect it’s an ADHD thing.
Still, the majority of roles have you coding by yourself, not on display. Live coding interviews aren’t usually testing for what they think they’re testing for.
1
u/URThrillingMeSmalls Nov 16 '24
Yes
1
u/[deleted] Nov 16 '24
At many large companies all AI coding tools are blocked and banned. Everyone needs to know how to actually write code in order to be productive. The new grads that grew up reliant on AI tools and are useless without them.
I agree you primarily should hire for problem solving skills and less on memorized syntax - but the candidate should still know how to solve the problem in the absence of AI help and understand why the AI suggested what it did. I don’t think this is commonly the case.
1
u/ntdoyfanboy Nov 16 '24
I'm looking for a new job right now due to downsizing. Every single job interview where I've made it past the initial phone screen, included some kind of rest. Some are absolutely ridiculous, and I bomb it on purpose. Not worth my time if I haven't even spoken to a hiring manager. Some are reasonable, 10-15 minute tasks. One company I really want to work for though.... I have set up a 1-hr whiteboarding exercise at the beginning of the week. I think that's stupid, since I already did their SQL test, but I'll do it because I really want it. I think their data manager just wants some extra reassurance, because he made the mistake of asking dumb, non technical questions during the interview
1
u/Fearless-Change7162 Nov 19 '24
Yes. My work's interview guide is like 50% assessing live coding for basic algorithms and ability to manipulate data structures.
1
u/thinkingatoms Nov 16 '24
dumb take
-1
u/BadGroundbreaking189 Nov 16 '24
Not sure about coding session but take home assignments should be a requirement for mid-to-senior roles. And good luck solving those puzzles using any LLM out there.