Tip 1 : Practice DS & Algo questions from Leetcode, Geeksforgeeks and hackerearth
Tip 2 : Practice SQL questions from hackerrank
Tip 3 : Have at least one awesome project to discuss about during the interview
Tip 1: Mention all relevant skills, projects and past experiences
Tip 2: Resume must be tailored according to the role you applied to
There were 3 questions on DS & Algo of medium difficulty.



Given an array of meeting time intervals consisting of start and end times [[s1,e1],[s2,e2],...] find the minimum number of conference rooms required.
I decided to use min heap for this. I sorted the array based on start time. For each meeting I checked whether any old meeting in the heap was over before the current meeting start time. If yes then I pop that old meeting and push this need meeting into the min heap other wise I incremented the total counter and pushed the meeting to the heap. Finally I returned the total counter.
Interviewer asked me to introduce myself. Then he asked about the projects that I have done. Finally he gave me some simple DS problems and system design questions.



Given two numbers where each digit is stored as a node in a linked list, add the two numbers and return the result
Step 1: Traverse the two linked lists from left to right
Step 2: perform addition, store result in a new node and keep track of carry over
Step 3: Return the result
Given a website being hosted on a single server, what are the challenges one could face in terms of performance issues when network traffic increases?
How to improve the overall performance of the system?
Tip 1: Think of how traffic will be flowing to the server and how it will affect the performance
Tip 2: For performance improvement, think of both vertical and horizontal scaling
Tip 3: Think about how to improve system throughput
Interview was conducted at BNY Mellon’s Pune office. Complete travel and accommodations was arranged by BNY from flight to hotels.
Couple of puzzles was asked.
Q1. What is the angle between hour and minute hand of a clock when it is 3:15.
Q2. 2 eggs, 100 floors. We want to find out the floor beyond which if an egg is thrown from it will break.
Q3. In a T20 match what is the maximum no. of runs a batsman can score
Tip 1: A lot of the puzzles can be solved using the techniques that are taught in algorithms like the egg problems is a simple binary search
Tip 2: It is generally advisable to solve a few aptitude questions so that you can quickly thing on your feet
Tip 3: It is ok to take some time and give the correct answer instead of hastily giving the wrong answer
Two tables were given. Based on the information provided in the tables I was asked to perform some operations and extract some insights from the data. After that I was asked about SQL related topics like rank functions, window functions etc.
Tip 1 : Should have firm grasp on SQL
Tip 2 : Practice SQL questions
Tip 3 : Rank and window functions are asked pretty much in every interview on DBMS

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
How do you remove whitespace from the start of a string?