PwC Interview Expertise for Knowledge Engineer (2 YOE)

PwC

• 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.

Technical 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

1. What number of information can be there after becoming a member of 2 tables – proper join- 2 tables with information set got.
2. 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?
3. Variations between rank, dense rank, row quantity definition clever, and for a knowledge set given additionally inform the end result.
4. 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.
5. Within the given information exchange $%@₹& character with empty house “.
6. 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.