I applied through an employee referral. The process took 3 months. I interviewed at Spectrum in Jun 2022
Interview
Two round technical interview(RDBMS) and two round of non- technical interview. Common questions on joins, few inbuilt functions, Stored procedures and UNIX/LINUX shell scripting. In second round of Technical round we had few behavioral questions as well.
Interview questions [1]
Question 1
Left outer join with where clause differentiations Qualify statements Lead- Lag logic (like using inbound proceeding etc.) UNIX/LINUX - basic commands Scenario based questions