Sopra Steria Interview Experience | On-Campus (2019-20)
Sopra Steria visited our college, Inderprastha Engineering College on 13 September 2019 for conducting Recruitment Drive for “Engineer Trainee Role”.
Eligibility Criteria: 70% in X & XII and 60% in B.Tech.
Round 1 (Technical Online Test):
The first round comprised of 30 MCQ questions including 15 questions from DBMS and 15 questions from Data structures (linked list mostly), OOPs, C/C++ output based questions etc. This round was of 50 minutes and there was no negative marking. After submitting this round if cleared, then the message will be shown on the screen like “Congratulations and so on”. This means that you are eligible to give next round.
Most of the students were not selected because of lack of knowledge in DBMS.
Suggestion: Practice DBMS from Indiabix as it will give confidence to solve problems.
Round 2 (Aptitude Online Test):
Aptitude round comprised of 11 flow chart based fill in the bank questions, with no options provided. This round was of 75 minutes with no negative marking. Questions were very time consuming, hence I will suggest you to practice them in advance from https://q4interview.com/ques_ans.php?c=150&page=1
Out of 242 students only 25 were able to make it to Round 3. Round 3 was GD, but it was eliminated from the process because of less students.
Round 4 (HR Interview)
This was non eliminating round, in this HR asked questions like-
HR- What do you do in your free time?
HR- Suppose you are given a project and a team is assigned under you, so how will you plan and reach your goal?
HR- Are you comfortable in relocating?
HR- Are you comfortable with night shifts?
HR- Do you have any plans for higher studies?
Tip: Always say Yes!
Round 4 (Technical Interview)
Interviewer asked questions from Resume and some basic questions from OOP concept and DBMS-
Explain about the projects you have worked on.
What is function overloading?
Write a program to find the number vowels in a given word.
What is the need of normalization?
What is Cartesian product?
If there are two tables of 3 and 6 rows each then how many rows will be there after their Cartesian Product.
Difference between Cartesian Product and Join.
Explain left and right join.
What is used to find unique rows in a table?
Why is Foreign key used?
This round took about 30 minutes.