I’m a 2021 graduate, presently working as an Analyst in an MNC. I utilized for the Knowledge Engineer-1 position at Innovaccer on June – 22, the whole course of took round 3-4 weeks.
Course of: On-line Take a look at, Technical Interview, HR Interview
Spherical 1(On-line Take a look at): The web take a look at was carried out on the Hackerrank portal and comprised 6 questions in complete. 5 of them are SQL queries and one subjective query primarily based on Git. SQL queries ranged from straightforward to onerous, the place 2 of them had been easy-medium, 1 of reasonable issue, and the remaining 2 might be categorized as onerous. with 6 questions in complete. 5 SQL and 1 Subjective
- Return Title in uppercase satisfying the given situation
- Return knowledge of scholars who scored greater than the typical marks
- From the given desk, return the overall rely of various severity of Covid among the many three age teams, the place age teams from the given knowledge had been alleged to be created by me utilizing SQL functionalities.
- From the given knowledge of three tables location, corporations, and staff, discover out the situation with most corporations and return the title and firm of staff who work in that location
- A query the place the highest 3 data in every class had been to be fetched with another circumstances utilized (I used Window Features right here). This one had a trick to sorting the place I used one other Window operate to extract an extra column to type on to get the specified end result.
- Subjective query primarily based on numerous instructions in Git with a proof.
Spherical 2(Technical Interview): The interview was carried out on google meets and was scheduled for 1 hour. The interview began with the notorious “Inform me one thing about your self” query, adopted by a radical dialogue of my present position and the instruments and applied sciences used. Shifting on the interviewer requested me under talked about questions:
1. A desk of 4 columns incorporates duplicate rows. extract the duplicate rows?
Resolution: I defined it utilizing 4 methods:
- Utilizing GROUP BY
- Utilizing SELF JOIN
- Utilizing DISTINCT key phrases
- Utilizing Home windows Operate (ROW_NUMBER on this case)
2. Two tables A and B have one column “Id” (duplicates allowed), what can be the results of the inside be part of of those two?
- What can be the end result if desk A incorporates Null values as nicely?
- obtain the identical end result as in inside be part of utilizing left be part of?
- Use proper be part of however the end result set should not embody the matching rows?
Be aware: For getting an concept of the above-mentioned query one can seek advice from https://youtu.be/xR87ctOgpAE
3. delete duplicates from a SQL desk?
Resolution: https://www.mysqltutorial.org/mysql-delete-duplicate-rows/
4. Given a desk with StudentId, Marks, and SubjectName, discover the main points of a scholar with the topic through which they scored lowest every scholar?
Resolution: Used Home windows Operate (RANK).
Comply with-up query: What would you do if marks are equal in two topics? return just one row in that case with a topic that comes first lexicographically?
Resolution: Used one other Window operate ROW_NUMBER and fetched solely the queries the place row quantity and rank is 1.
5. Questions associated to the mission and fundamentals of Python knowledge constructions and libraries like Pandas and NumPy.
6. COALESCE Operate? Clarification and Use?
Spherical 3(HR Spherical): This spherical revolved round basic dialogue on my present job position, work tradition at Innovaccer, why am I on the lookout for a swap, Why Innovaccer, what I find out about Innovaccer, and many others.
Verdict: Chosen
Suggestions: Be trustworthy and assured whereas answering the questions, belief me, you’ve got it in you.
I wish to thank geeks for geeks to assist me with the preparation of core topics ideas and puzzles. It’s certainly a one-stop answer for Software program Subject College students.
