- Knowledge Engineer Position
- 2+ yr expertise
Utilized for this place by means of referral and was shortlisted primarily based on my resume 3 months again.
The choice process includes of two rounds: 1 Technical Spherical & 1 HR/ Managerial Spherical.
- It began with Intro and hobbies. Then, went on to Resume, abilities, expertise, function & duty (principally what work was completed within the final 2 yrs on the firm), software program and applied sciences identified, and applied, what working now, and focusing on for the long run to be taught.
- Subsequent, inform me in regards to the present tendencies within the information discipline, what’s happening available in the market?
- Which instruments are developing? Which instruments have taken a again seat now and why? And another questions/cross-questions on this area.
Some SQL Questions
- What number of information can be there after becoming a member of 2 tables – proper join- 2 tables with information set got.
- Additionally, if I need to have a so & so end result then what ought to be the question/ be part of kind? Every other option to attain the identical end result?
- Variations between rank, dense rank, row quantity definition clever, and for a knowledge set given additionally inform the end result.
- For the given information body, describe DB schema, filter staff whose wage is lower than 50k, add a brand new column for x% bonus, and than discover the brand new wage after including the bonus… And the way to reserve it as a parquet file.
- Within the given information exchange $%@₹& character with empty house “.
- What number of factors will your title and surname have primarily based on the given level system information set?
Subsequent some conceptual questions associated to provide chain & administration and planning have been requested – for the reason that earlier group was working on this area.
Verdict – Not Chosen.
Notice: This interview was given by my roommate (who’s 1 yr senior to me), so I wished to share one such expertise as effectively which discusses on expertise the place the decision is: Failed.