There were total 4 rounds, and I cleared all rounds and the HR from Pune location said they have some issue in system and they will release offer letter soon and took 2 months and after that I received mail that I am no longer in consideration.Overall the process took 4 months.The worst Hr team at Pune location.
I applied online. I interviewed at BNY (Cleveland, OH) in Jun 2017
Interview
Phone interview. Directly jumped into asking questions, had no interest to know about my current or past project and exp. Asked to tell ACCURATE lengthy sql queries over phone. I believe in writing sql queries on editor rather than tell them over phone without errors. Not a professional way to interview for a sr role. Last dint even bother to ask if i had any questions. Waste of time.
Interview questions [2]
Question 1
Tell exact query to add all positive and negative numbers from a column in single sql statement.