I applied through a staffing agency. The process took 6 weeks. I interviewed at Gainsight
Average interview
Application
The process took 2+ months. I interviewed at Gainsight
Interview
very unprofessional hiring process...
applied via linkedin,got a call from hr after 2 mnths,appeared for an online sql coding exam at hackerrank,a skype interview the following week, no further response from hr despite several mails.
Received a call from some consulting company and I have taken their online written exam at HackerRank.
6 questions in 2 hours - medium difficulty
1 question on ETL scenario and 5 on Advanced SQL.
After the exam I have received an email for F2F interview at their Hyderabad office. And then they went ghost, they ignored my emails and calls.
They won't even take the call from consultants that first contacted me.
In conclusion, the company has an unclear understanding of it's own HR requirements. To top it, they don't have the courtesy to respond.
It's a mutual waste of time.
Interview questions [1]
Question 1
1. Scenario for pivot in SQL
2. Grouping and aggregation
3. Correlated sub queries
4. ETL data movement from file to table , possible bottlenecks and solutions to overcome them