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.
I applied through a staffing agency. The process took 5 days. I interviewed at OpenGov in Sep 2025
Interview
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
Interview questions [1]
Question 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 ?
I applied through a recruiter. The process took 4 weeks. I interviewed at OpenGov (Redwood City, CA) in Jan 2017
Interview
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.
Interview questions [1]
Question 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