O processo levou mais de 2 meses. Fiz uma entrevista na empresa Gainsight.
Entrevista
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.
Candidatei-me por meio de uma agência de recrutamento. O processo levou 6 semanas. Fiz uma entrevista na empresa Gainsight.
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 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