The Hr reached me out through the email. I first thought that it was some spam email so I double checked the Hr's details and then contacted her back. Soon enough there was a small 15-20 min call with her and we got to know each other during the call. She was very interested in knowing if I use SQL on a daily basis. Since i didnt use it daily i told her and she asked me to prepare for it for the interview. Next she emailed me a bunch of study material for both sql and python. I didnt make it to an onsite interview since I was slow. There were 30-30 minute sessions for python/sql and the interviewer was quite particular with the time.
I could solve 2 python and 2 sql questions in the given time. Though I struggled in the second sql question a little bit.
The overall experience was good as the interviewer helped me with my thought process throughout.
tips:
1.Please communicate your thoughts to the interviewer
2. once you build a rough algorithm , just start executing it without too much thought. you will get to know the errors in the compiler and u can change the syntax, or logic accordingly. This will save you a lot of time.
3.Try to complete more questions in less time (ofcourse they should show the correct output)
4. be confident in whatever you are doing. If you cant figure out a way to write a logic by yourself, just ask the interviewer quickly. They will definitely help