I applied through college or university. The process took 1+ week. I interviewed at Infogain (New Delhi) in Mar 2021
Interview
Aptitude test and coding test . After clearing aptitude test coding test will appar. Results will announce after some days.
And after announcing the result of aptitude and coding test the technical interview will happened
and if u clear the technical interview then HR interview will shedule.if u clear HR round u get an offer letter
Interview questions [2]
Question 1
The asked me about optional subject and questions from that
Total rounds-3
1st round-Online assessment
Questions-20 MCQ(sql,pandas,Logical ,Quants)
2nd round-Technical HR(face to face)
Questions-Sql theory questions first,then written in sql,python code and queries
sql-2nd Max salary,Duplicate mails from a table
python-Missing values from a list
Final HR-Formalty
Difficulty level-3 rounds were easy only,But that time i didn't revise properly and i didn't know easy concepts also.So i didn't get into that role at the same time some of my friends got this role,so i am happy.Overall the company ambitions was good.
Interview questions [1]
Question 1
Basic sql questions:
Difference -Primary and Foreign,Dbms and Rdbms
Single row funtions
Joins and subqueries and DQL commands
I applied through college or university. The process took 1 day. I interviewed at Infogain (Patiala) in Nov 2017
Interview
Interview starts with one common question that every interviewer may ask i.e Tell me something about yourself. Questions from Projects which I have written in my CV then questions on DBMS, Java, OS and after that he asked me to write a program to find prime numbers within a given range.
Interview questions [1]
Question 1
Difference between method overloading and overriding in java?