Whole process was pretty smooth. Was contacted by HR(Anna) and she helped in scheduling onsite interview at Boston office. She was really proactive with the communication and updates about the status. I got an offer and accepted in a week.
Ho presentato la mia candidatura tramite un'agenzia di reclutamento personale. La procedura ha richiesto 5 giorni. Ho sostenuto un colloquio presso OpenGov nel mese di set 2025
Colloquio
Two Rounds
HR screening
round 1 - Done with onshore guy from US Techincal round on zoom call
round 2 - Pune office Face to Face Techincal round with senior sofware enginner to know more
Domande di colloquio [1]
Domanda 1
Two Rounds
round 1 - done with onshore guy from US
Question around architecture design of data ingestion,transformation and final layer
Few related to cdc change data capture
Few related to database service aws RDS, aws redshift
round 2 - Pune office Face to Face
Mostly sql based
find cumulative sum by region by date ?
top 2 customer per month ?
partition vs bucketing ?
predicate pushdown ?
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso OpenGov (Redwood City, CA) nel mese di gen 2017
Colloquio
Initially I had phone screen in December and then online coding challenge mid January and on-site end of the month. Everything went will till I got there on-site. I usually don't write reviews about any company but I felt like writing this. Except for one person who interviewed me on-site all were very rude and bumpy. Specially there was one guy who asked a System design problem. He was very very rude. He should understand that Facebook is not designed in 15 minutes. I'm very glad that I did not land in this company. They just call for on-site but you can go for interview experience if you are a newbie. I should have just trusted the reviews.
Domande di colloquio [1]
Domanda 1
design Facebook activity log, argmax question taking in two parameters one being argument and other a function. This problem was very confusing and even the interviewer had to look at the solution to answer this problem