I applied through a staffing agency. The process took 3 days. I interviewed at Alcon (Bengaluru) in Oct 2020
Interview
This organisation is highly unprofessional in terms of interview process. My interview was scheduled at 1:30 pm IST. Out of a sudden i got a call at 11:40 am IST. That person started without introducing himself and without gave me chance to introduce myself. He just started bla bla bla, few sql questions. After the interview he said , now you gonna have client interview.
Later I got a call from my recruitment consultant. I informed them, don't want to proceed with my application. I would love NOT to work with such unprofessional future colleagues.
Alcon please hire professional people ONLY to interview professional people.
Interview questions [1]
Question 1
SQL.
1. given a table t1(name, email)
a. give percentage of records have email addresses(email could be null or non-null)
b. give records start with 'a'.