I just finished first round which is aptitude and it was good. But I got an email for another round which has same aptitude test under supervision. Its for 30mins.
I applied online. The process took 1 week. I interviewed at Mitratech (Hyderābād) in Mar 2021
Interview
I applied on LinkedIn, Initially I went through aptitude and personality test which was a easy test. This test includes matching diagrams, percentages problems, find next series, statement based questions. After this, again we have to go through same test but in zoom call with HR. After this I went through technical assessment based on SQL string operations, joins, group by and order by clauses. I have submitted the test. It was an easy test on SQL. After two days I got mail from them mentioning this ( At this time, our team has received many qualified applicants and unfortunately we have decided to move forward with other candidates who more closely fit our needs.). So I called to HR , she was very polite to answer. She told that I have cleared the assessment but technical panel guys rejected me based on relevant experience which others guys having. without interviewing me, how can you know that I am suitable or not. If I have rejected in technical interview then I would be feel happy. It took more than a week for this process. I confidently cleared the technical assignment and I am waiting for technical interview. But after receiving the mail, they had to move with other candidates I feel disappointed.
Interview questions [1]
Question 1
SQL denormalization, right function in SQL server, constraints in SQL, types of indexes
Coding challenge :
Count no of employees first name contains 'e' and last name having more than 5 letters
select count(*) from employees where first name like '%e%' and length(last name)>5;
Second challenge:
Based on inner join, group by, order by clauses
