Experian Interview Experience
Summary
My interview at Experian for an Associate Software Developer role was incredibly challenging. I struggled significantly with a DSA permutation problem and couldn't properly answer a conceptual SQL question, which left me feeling deeply disappointed.
Full Experience
It was truly one of my worst interview days. The interviewer presented an 'all permutations' DSA question that I had literally solved just four days prior, but during the interview, my mind went completely blank, and I couldn't even formulate the logic. To make matters worse, my tendency to overtalk and miscommunicate led me to stumble even on basic OOPS topics. Another particularly tough moment was when the interviewer asked a question that was identical to one I had faced in a previous interview at LTI Mindtree: 'Stored procedure vs. Function in SQL'. Although I had learned it thoroughly at that time, I had completely forgotten the details and couldn't provide a proper answer. I am writing this feeling a profound sense of depression, especially considering I was a bright student in college, but my mind just didn't cooperate that day.
Interview Questions (1)
Explain the key differences between a stored procedure and a function in SQL. Discuss their characteristics, such as return values, ability to perform DML operations, and how they are called or executed.