Pergunta de entrevista da empresa S&P Global

1st Round: Java fundamentals: Singleton pattern, Immutability and ways to protect immutability, Internal working of Hashmap, Serialization, 2 sum problem, 4 SQL problem which included Joins(left and inner), subquery and sorting 2nd Round: In detail discussion based on my resume. I was asked about DB optimization and index and ended the discussion with LLD for a Cache. After the first 2 rounds, my candidature was on hold for 2 weeks since they were interviewing other candidates as well. 3rd Round: It was with the Executive Director and Associate Director, the interview mostly revolved around the expectations from me and my expectations from the role. The ED clearly explained the onboarding process and expectations from me in the first 6 months and later.