Recently, BNY Mellon visited our campus and I secured the INTERN + FTE offer, here is my interview experience.
1st Round(Online Assessment) : There were 4 coding questions and the questions were on the medium-hard side. Two questions were implementation based, 1st one being on modulo arithmetic and 2nd one was on finding the length of cycle in graph and 3rd one was from Sweep line algorithm and the 4th question was from Tree.
On 28th August, around 30 students were shortlisted for interview which was scheduled on next day. Total 3 round of interview was taken.
2nd Round : My interview was scheduled at 4pm on 29th August. The interview lasted for around 70-75 minutes. The interviewer told to introduce myself. Then he started by asking me about SQL. Around 20-25 minutes he asked about varied concepts of Database. Some of the topics which were focused was : Primary key, unique key, super key, Foreign Key, joins (how does it works with query), Analytic functions, Procedures, triggers, cursor, RDMS features, advantage and disadvantage over NoSQL. And in end he gave a SQL query to find 5th highest salary of all departments and I solved it using window function. Then he moved to DSA, he gave me certain situation based problem and I was asked to code. The code was very simple, the main aim of interviewer was to check which Data structures I was using , 1st one was solved using map and 2nd one was from queue(Lift Designing Question). Then he moved to OOPS. He told me to explain everything I knew about OOPS. Then he asked me to code method overloading. Then at end, he asked some questions like which platform I use to solve problems and asked me to tell one of the recent question I solved and found it very interesting. Then he asked me that, if I had any questions for him.
After 30 minutes, I got the mail for 3rd round which was scheduled at around 6:45 PM . The duration of interview was 45 minutes. He started by asking me about my introduction. The he straightforward went into project and asked me to briefly explain about the projects and asked some questions from the project. Then he asked about some basic questions on joins, ACID properties, benefits of SQL over NoSQL. Then he asked about Polymorphism. Then he gave two questions to solve. 1st one was from strings.(To remove all the characters from string except lowercase alphabets and then sort the string). 2nd one was, We are given two files where array of numbers are given. Create a 3rd file and copy only those numbers in 3rd file which were present in both the files. Then he asked me, if I had any questions for him.
Next day, 10 students we shortlisted for HR round. My interview was scheduled at 6:30 PM. The duration of interview was 30 minutes. For me this round was also on technical side. He started by asked me to introduce myself. He told me to mention only my technical skills. Then he asked, how I would approach learning new technology(whether I would buy course for it or I will go with documentation), then some discussion on how ChatGPT has helped youth in this regard. Then he nicely explained benefits and disbenefits of these new evolving technologies. Then he asked some questions on Operating systems like wait, sleep, about some signals. He then asked whether a (.exe) file created on linux can be executed in windows, semaphores, lock, process, thread etc. Then he went to OOPS where he asked about Inheritance and asked me whether I knew about diamond ring problem , then he asked how would I resolve that problem. And at end he gave me a puzzle problem. (https://brainly.in/question/43645849)
After 3 – 4 days result were declared. And I was one among the 8 selects.
rakesh20nitdgp edited this page on Sept. 25, 2023, 8:22 a.m. Approved