Tip 1: Try to get a good grip on basics; never jump into advanced concepts unless you are clear on the essential subject.
Tip 2: Always include every central concept in your core curriculum ( for a CS student). Make sure you have an idea about it and where you can apply it.
Tip 3: Try to work on and know more about trending or booming technologies.
Tip 4: Have short-term goals when it comes to coding. Consider a topic for once ( like strings, pointers, dp, etc.) and try to
cover the maximum variety of problems possible in a reasonable time.
Tip 5: Try to search for tricky pseudo codes online and guess the outputs.
Tip 6: Give mock interviews beforehand and also gather information about the company you have applied to.
Tip 1 : Do include only known and worked on concepts in your resume .Do not bluff or exaggerate.
Tip 2 : Our resume needs to show that we are flexible and have not just worked on a single domain. So try to do and add
at least 2 projects to your resume that too of different domains.
Tip 3 : Resume needs to look professional do not include a lot of personal details.
Tip 4 : Career Objective is something that is unique and written on your own and not copied from any website or peers
resume.
Tip 5 : A single page or 1 and a half page of resume would do good. Include certifications of any forefront technologies if possible
The test window was open from 2:00 p.m. to 05:30 PM IST on 28th of August 2020.We were also given a chance to take a practice test to know about working of the platform .It was a Proctored Assessment .The test platform was HackerEarth and there were around 28 MCQs, 1 programming question, and 2 SQL queries. MCQs majorly focused on OS, DBMS, C++, OOPS concepts.
We cannot use the element at a given index twice.
Try to do this problem in O(N) time complexity.
Write a query to find names of the customers who have purchased less than or equal to one product. Order the output by customer name. Given customer table with customer id and customer name , product table with product id , corresponding customer id and product name.
Write a query to find average marks of each class using the given table. The output should be rounded off to 4 decimal places and sorted based on the calls.
A single table with student information is provided
It was basically a technical interview. It was conducted around 11:00 a.m. on 31st august 2020. There was only 1 person who was interviewing me though I expected a panel. It started off by the question regarding our college and infrastructure of it and what do I like the most about it etc. Later continued by few technical subjective questions and a code along with a basic query. Technical questions regarding data structures like linked list, Array List , HashMap were asked along with concepts like backtracking were also covered. More about technologies related to projects that I have done were asked which is machine learning. the ratings i earned in online judges were also asked about.
Query to retrieve the employee name with second maximum salary from given table (there are 3 tables Employee(ID,name), Salary(Esalary,post) , Works For(ID,Salary)).
In the given linked list, there is a cycle, hence we return true.
It is more of a Managerial round. This was not confined to any topic or a subject .It took place around 4:15 p.m. on 31st of August ,2020.
How did you feel when you got to know that you were qualified to next round?
Take me through your resume.
What is your project about?
Why did you wanted to do an ML project?
Why do u choose java over python?
Any conflicts you faced with your team mates during projects?
Tell me something about article writing. Which kind of articles do u prefer to write ?
Recent news on Technologies that shook you.
This is the final round the HR round. This is where there is no technical stuff discussed and everything is more about how are you as a person and the way you deal with situations and the way you react to certain circumstances . They try to question your creative abilities. Some of the questions I faced are
1) Questions mostly regarding personal details those not on your resume.
2) What do you do on a stressful day
3) A situation to prove your time management skills
4) What do you know about our company ?
5) Why did you choose our company?
Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What does ROLLBACK do in DBMS?
Software developer in java