I applied through university. The process took 1 day. I interviewed at Oracle (Redwood Shores, CA)
Interview
Part of the college campus hiring program.
Recruiter got resume through campus career event, contacted me. No phone screening, so it's all about good resume, in particular good school & GPA.
I got a one day onsite interview at HQ, where I talked with 4, 5 teams. Since each teams has seperate hiring decision, if you got pick by recruiters for onsite interviews, very high chance that you will have at least one offer from at least one team out of the 5 teams you talked with.
Actually interview really depended on which team. Some team is just casual talks, while some teams actually ask technical questions, but quite easy and more about personality & skill fit. No general algorithm questions.
Be friendly & talkative. Prepare to talk about your past project & relevant experience, it's the main bonus points.
Interview questions [1]
Question 1
Got asked specific SQL knowledge questions for database team. For college hire, not about deep knowledge of db system, just experience on SQL use is good.
Mostly coding question focused, and some talking about personal experience and terms. Some technical design, you could have chosen any language to complete the coding questions. Questions were simple technical concepts that person came up with at the moment.
Interview questions [1]
Question 1
Something like searching in logs using maps and filter/find data
decent amount of DSA and System design were asked, and behavioral questions. so prepare leetcode level questions and good amount knowledge in sql, java and also mostly oracle sql. overall it was good
First online assessment. Then 2 interview rounds + 1 hr round. This was during campus placement. In interviews they mainly asked about dsa, os concepts, logical questions and some system design questions also.