applied internally to a role thatd be a nice pay pump. its a data role with a strong emphasis on python and sql skills. i studied my ass off on data concepts anticipating questions like “how would you start solving xyz problem” or “how would you find business insights on zyx” and the first question is “whats the difference between a dict and a list in python?” or hell, even a leetcode-like question. i like to think im decent at USING python and sql, but not having used them in a current role in ~2 years, these google-search-esque questions threw me off guard. i fumbled making up answers for a few but some i straight up had to say i have no fkn clue. so todays been a bit of a demeaning experience! has anyone else ever had an interview where they asked questions like that?

  • some_guy@lemmy.sdf.org
    link
    fedilink
    arrow-up
    1
    ·
    30 minutes ago

    Don’t worry too much about it. I landed an interview at DreamJob™ before I was ready. The phone screening went great and I came for two in-persons, two people in each. I bombed all the way to hell and back. I could tell one of the people in the first meeting was thinking to himself that his time was being wasted. It was a nightmare. Needless to say, I didn’t get it.

    A year later, I came back for a different position in the same department at DreamJob™. The first in-persons went well (three of them, each one-on-one). In fact, the third person was about 35m late, so the second guy had to fill time and started throwing logic problems at me to give us something to talk about. I hadn’t had to do any real math in a handful of years, so that was stressful, but I made it through. When third guy showed up, he seemed to like me and we had a nice fit-for-culture kind of chat.

    The next round was a day of interviews, eight rounds. Most were pairs, but also two one-on-ones. The guy whose time I’d wasted the year before was one of those. I was terrified. He didn’t remember me (why would he, I was just an inconvenience the first time). He seemed to like me, stoping to ask if I understood how a technology worked when I was having a hard time answering a question. So he explained it to me and said, “ok, so now that you know that, how would you approach the question from before?”

    There were two more one-on-ones on separate days with the head of the department and then finally his boss. I got the job. My entire career and everything since is built on that first major success in the industry.

    Lesson to take from the story is that no matter how much shame you may feel at this moment, you can try again and have a totally different outcome down the road. Just keep working on your skills and building yourself into a more suitable candidate and, when the time comes, try again. Bad interviews happen. They hurt for a while, but they aren’t the end of the world. Invest in yourself and you’ll get there.

    (I usually wait five minutes when I type anything this long and then proof it, but I’m in a rush so you get my first draft, lightly edited.)

  • MajorHavoc@programming.dev
    link
    fedilink
    arrow-up
    5
    ·
    edit-2
    5 hours ago

    Don’t be too hard on yourself. A great interview explores the limits of your experience with the interviewer. That ideally includes some questions you simply cannot answer.

    I have, very rarely, interviewed someone who had every answer I was looking for. In that case, she went on to build the entire team. But usually I don’t need someone with all the answers, but just someone with enough experience to do the job while growing into it.

    So sometimes missing some questions still lands you the job, and just informs my training plan for after I hire you. It’s hard to tell right after the interview which way it went.

    And sadly, I don’t know for sure, until I’ve interviewed every candidate, so I rarely can give meaningful feedback right after the interview.

    Also, if you were honest and communicated clearly, you likely grew your professional network, whether you get the job or not.

    All that to say - you might not have bombed, after all.

      • some_guy@lemmy.sdf.org
        link
        fedilink
        arrow-up
        1
        ·
        21 minutes ago

        Aha, something I didn’t mention it my sibling post about interviewing for DreamJob™: once I was on the team and on the other end of the interviews, the theme from my manager was always to see how the candidate thinks and solves problems. He always stressed that they don’t know our tools and processes. It was less about getting the right answer and more about demonstrating that they’d have the ability to do the job once we onboarded them.

        There was a guy who I congratulated on his first day joining our department who was surprised. He told me he thought I disliked him in the interview (I actually wrote him a solid post-interview review, he was great). That was back when I thought it was a good strategy to be stone-faced in interviews and before I got enough wisdom to just be casual and approachable. Maybe you interviewed with a dickhead like the old me who didn’t know any better yet!

  • specialseaweed@sh.itjust.works
    link
    fedilink
    arrow-up
    18
    ·
    edit-2
    8 hours ago

    Sorry to hear your interview bombed. That sucks, buddy. It happens to all of us at some point.

    At a career fair at college a long long time ago, I was recruited by the local government for what was described as a networking job “plus some other stuff” related to networking. I hated coding but loved networking work so I agreed to apply. There were some basic screening questions that were low level, easy stuff. I got an interview.

    The interview was conducted by two electricians and a project manager. None of them knew what the fuck they were talking about. I’ll never forget one of the questions was whether a device can be on multiple networks. I said sure, just dual home it. They told me I was wrong, a device cannot be on two networks. I was dumbfounded. They were dead wrong. It was clear really fast that these were electricians pretending to be IT guys, not IT guys working in an electrical field.

    For the coding portion of the interview, they put me in front of a software I’d never heard of before and told me to code some shit then left the room. It was all in ladder logic. I had no idea what the fuck that was. I jumped into the programs FAQ and realized you could write in JavaScript, so that’s what I did. The autocomplete really helped. I did that and walked out with a program that worked well enough. They told me they didn’t know what I had done but it was wrong. None of them could read or write real code. I had seen in the documentation that you could output the code in ladder, so with them standing there I converted it and then showed them the ladder logic. They looked at me like I was a fucking alien.

    They thanked me for my time. I knew I wasn’t getting the job and was thanking my lucky stars because the people running the place didn’t have a fully functioning brain between the three of them.

    Anyway, my internship gig at another place fell thru soon after due to money troubles. I had put all my eggs in that basket and was well and truly fucked. A couple months later I got a call from the city offering me the job. I asked later why they hired me and they said I was the only one that could output any code at all during the interview process. They thought I was an idiot. I thought they were too, but I took the job cause I had to.

    Maybe the worst job I ever had. I was right. They were idiots.

    And that’s how I became a PLC programmer.

  • jubilationtcornpone@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    8
    ·
    8 hours ago

    Oh yeah. One time I interviewed at this accounting firm and mentioned that I was fairly familiar with SQL, which was a true statement. The VP on the call proceeds to start grilling me about really in depth performance tuning stuff and then acts all flustered when I don’t have the answers. I said “fairly familiar” not “10 years as a database admin”.

    Then they went radio silence for a year, after which they called and asked if I was still looking for a job. Even if I were, I wouldn’t have gone to work for them.

    Technical questions can give you a feel for how familiar a candidate is with a given tech stack. But then there are some people who just get off on making others feel inferior.

  • Nollij
    link
    fedilink
    English
    arrow-up
    7
    ·
    8 hours ago

    Interviewing is a skill in itself, and one that you can practice. I would encourage you to apply for all sorts of positions you don’t actually want just for the experience.

    Sometimes, these questions aren’t meant to get an accurate answer. They’re meant to see how you approach an issue, especially under pressure. I’ve seen people print out multiple pages of indecipherable code and ask a candidate “what does this code do?”. Of course, if you can answer it correctly you’re hired, but no one realistically can. But they can watch how you break down code you’ve never seen, in an unfamiliar environment, to piece it together.

    Sometimes the questions are meant to call a bluff, or reveal a know-it-all. In a good interview, you’ll flat out say “I have no idea” a couple of times. But you’ll follow it up with details on how you would handle it. For instance, I’ve never heard of a dict in Python until now, so I googled it. It seems they’re the same as key-value pairs that are common in other languages.

    They will never find a perfect candidate. The question in their minds is whether you’re close enough and can be trained.

    • odelik@lemmy.today
      link
      fedilink
      arrow-up
      4
      ·
      edit-2
      6 hours ago

      The way Python is implemented, almost all objects in the language are dicts and can be accessed with the __dict__ dunder. Which has some useful applications when transforming data.

      But in the case, the interviewer was likely looking for knowledge that one is structured and maintained by indicies vs defined keys. And that searching through a dictionary is O[1] vs list that is O[N] but are inverted for deletion. So if you are doing a lot of inserts and seaeching, use a dict, but if you have something that has tons of deletions, use a list. However, there’s tricks to improve the deletion speed downside that can be used with a slight memory tradeoff.

  • Blaze@lemmy.zip
    link
    fedilink
    arrow-up
    5
    ·
    8 hours ago

    Sorry to hear. That happens from time to time. The feeling sucks. You’ll do better next time

  • FrickAndMortar@lemmy.world
    link
    fedilink
    arrow-up
    4
    ·
    8 hours ago

    Sounds to me like the failure wasn’t yours, but the interviewer’s; you came prepared for questions relevant to the role, and they went all out-of-pocket on you.

    Like if you show up for a tech job and they start going “paint me a word picture… tell me about your personal philosophy…”

    Like you said, if they just googled some BS to ask you, or followed the corp-approved “starting questions”, that’s their fault.

    Maybe you could reach out to them (or HR?)and go “hey, I was surprised by some of the interview questions, but I really do think I’m a strong match - can we get together and come to an understanding on the relevance of those questions?”

    • Rimu@piefed.social
      link
      fedilink
      English
      arrow-up
      8
      ·
      edit-2
      6 hours ago

      Naaah, difference between list and dict is fundamental. If you don’t know that then you’ve never coded Python at a professional level. It’s an ok interview question although it would only weed out the most nooby juniors so not really that good depending on what they’re hiring for.

  • nesc@lemmy.cafe
    link
    fedilink
    English
    arrow-up
    2
    ·
    7 hours ago

    Sorry to hear that. At low level there is a need to know your baseline, so dumb questions like that are needed, if someone can’t answer basic questions and some gotcha/well-known questions there is little sense to continue. To be honest, in my experience new internal positions/promotions are filled before interview.