Status: 8 YOE | Masters Degree from Tier-2 College
Position: SDE2 at Product Firm
Location: Hyderabad, India

Online Assesment (2 hours)
https://bitsofjarvis.com/programming/arcesium-online-coding-question-hackerrank-nav-calculator
Code has bug in the mapHoldingToResponse() where we need to consider updating the value rather than overwriting the existing value. Below code snippet has the fix.

	for(Holding holding : data) {
		if(map.containsKey(holding.getDate())){
			if(map.get(holding.getDate()).containsKey(holding.getSecurity())){
				int updatedQuantity = holding.getQuantity() + map.get(holding.getDate()).get(holding.getSecurity()).getQuantity();
				holding.setQuantity(updatedQuantity);                        
			}
			map.get(holding.getDate()).put(holding.getSecurity(), holding);
		} else {
			Map<String, Holding> localMap = new HashMap<>();
			localMap.put(holding.getSecurity(), holding);
			map.put(holding.getDate(), localMap);
		}
	}

R1 Coding : (1 Hour)
No leetcode. It was a abstract scenario based question which needed knowlegde of Java multithreading. Suggested the approach having Thread Pool Executors, Callables & coded it.

R2 System Design : (1 Hour)
Again not your regular system design round. Question was around processing multiple events in order of their timestamps coming into the system via multiple source systems like MQ, S3 etc.

R3 DB Design + KOT : (1 Hour)
This was the worst of all the rounds. Interviewer asked to design schema for CricBuzz with predefinied queries, focus was on Performance + Normalization. Interviewer talks for about 5-10 mins to explain the question & then goes onto do his own work in the background. His camera was never ON. Comes back @ 50th minute mark just to tell how the queries won't have good performance with the design I proposed (I guess we had agreed that normalization would also be a criteria). Unfortunately this guy is a EM but zero empathy.

R4 Hiring Manager (1 Hour)
I was surprised that the recruiter scheduled an HM round for the next day even after I bombed (as per the panel) the DB round. I recieved an email invite for the same, only to be cancelled an hour later & receiving an automatic rejection email saying they were going ahead with some different candidate.

One of the interviewers mentioned that they have to spare one weekend(saturday) each month for hiring events which would be compensated. Probably explains why the panel aren't that engaged during the interviews & appear to have no empathy altogether.