i
Sopra Steria
Filter interviews by
I applied via Referral and was interviewed in Jun 2024.
Python SQL related questions
Python SQL related coding test
There are 4 coding questions in first round
There will be machin test on best on MERN stack
posted on 5 Aug 2022
posted on 23 Mar 2022
I was interviewed in Aug 2021.
Round duration - 100 minutes
Round difficulty - Hard
The test had 3 parts:
1. Aptitude - 20 questions to be done in 25 minutes. (Medium level)
2. Technical MCQs - 25 questions to be done in 35 minutes. (Medium-Hard level) (HTML, JS, CSS, SQL)
3. Coding - 2 out of 3 questions to be done in 40 minutes. 20 minutes were allotted for each question. No switching between the codes was allowed. (1-easy, 2-medium in total)
Round duration - 45 minutes
Round difficulty - Medium
It was the first face-to-face technical round. The medium was ModernHire. There was only 1 member in the interview panel. This round tested me on C fundaments, Operating System basics, and problem-solving skills.
Questions asked:
What are the TRUNCATE, DELETE and DROP statements?
What are void elements in HTML?
Define multipart form data?
1. How does the C compiler works?
2. What are deadlocks and why does it happen?
3. How to resolve deadlock?
4. What is a kernel?
5. How to dynamically allocate memory in C?
6. What is makefile?
7. What is multi-threading and why is it useful?
8. What is the need for synchronization in OS?
9. How do you run a program of 10 GB using 2 GB memory?
10. What are semaphores and mutex?
11. How is HashMap implemented?
12. Difference between linker and loader.
13. Importance of header files.
14. What is Dynamic binding?
15. What type of database should you use where transactions are involved?
16. Brief discussion on the Internship experience.
Round duration - 50 minutes
Round difficulty - Medium
This was a managerial cum technical round. I was asked to introduce myself (both technical details and hobbies). Then I was asked about my internship experiences and what I learnt from them. After that, he asked me questions about the projects mentioned in my resume. He tested my in-depth knowledge of the technologies that I used. He also asked me about the alternative solutions and the drawbacks of my solution.
After that, he asked me to speak about Operating Systems for 5 minutes without giving a pause. Then he asked me to speak about the OSI model and the TCP/IP model for the next 5-10 minutes again without giving a pause. He appreciated my perfomance and gave me a coding question.
What is User-defined function? What are its various types in SQL. What is an Alias in SQL?
Then he asked me whether I had any questions.
Round duration - 15 minutes
Round difficulty - Easy
Typical HR questions were asked in this round.
Introduce yourself.
Mention something that is not in your resume.
Why are you fit for this role?
Why HPE?
Plans for higher studies.
Tip 1 : Revise data structures and operating systems very well.
Tip 2 : Have a good resume with self-made projects and internship experiences as they add value to the candidature.
Tip 3 : Be confident and know the basics well.
Tip 1 : Have some good projects and know the tech stack well enough.
Tip 2 : Never include anything which you are not confident about.
I applied via Naukri.com and was interviewed in May 2020.
Module Lead
1.7k
salaries
| ₹6.4 L/yr - ₹20.5 L/yr |
Senior Software Engineer
1.7k
salaries
| ₹5.4 L/yr - ₹18.5 L/yr |
Technical Lead
1.1k
salaries
| ₹9.3 L/yr - ₹26.5 L/yr |
Software Engineer
998
salaries
| ₹3 L/yr - ₹10.9 L/yr |
Process Associate
501
salaries
| ₹1.8 L/yr - ₹5 L/yr |
Capgemini
Accenture
TCS
Wipro