I applied through an employee referral. The process took 2 days. I interviewed at eClerx (Mumbai) in Mar 2023
Interview
HR round , aptitude test and technical Interview. They conducted aptitute test first and give shortlisting. Then they took technical interview. Interviewer was pretty chill. He asked some technical questions and some HR questions.
Interview questions [1]
Question 1
Tell me about yourself. Why eclerx? Questions related to data analytics software like python,Power BI,tablue etc.
In their JD they have written something and during interview their requirement was completely different which was not inline with the Job description. When i checked with HR who the JD is different from the interviewer requirement they donot have the proper answer.
Two rounds of interview. First round technical with SQL problems. Second round also technical but with BI tools and SQl. Each interview was for 30 mins and the results were out pretty soon.
Interview questions [1]
Question 1
write an SQl code to find second highest average salary
Interviewed for Business analyst, they asked few sql queries, and to explain projects, few questions on optimization techniques, sql optimization, etl process, python eda process, brief about domain knowledge etc