PwC Interview Expertise for Information Engineer (2 YOE)

PwC

• Information Engineer Position
• 2+ yr expertise

Utilized for this place by way of referral and was shortlisted based mostly on my resume 3 months again.

The choice process contains 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, position & duty (principally what work was achieved within the final 2 yrs on the firm), software program and applied sciences identified, and carried out, what working now, and concentrating on for the longer term to study.
• Subsequent, inform me in regards to the present developments within the knowledge discipline, what’s happening out there?
• Which instruments are arising? 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 knowledge set got.
2. Additionally, if I wish to have a so & so consequence then what needs to be the question/ be part of kind? Another technique to attain the identical consequence?
3. Variations between rank, dense rank, row quantity definition sensible, and for an information set given additionally inform the consequence.
4. For the given knowledge 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 knowledge substitute $%@₹& character with empty area “.
6. What number of factors will your title and surname have based mostly on the given level system knowledge set?

Subsequent some conceptual questions associated to provide chain & administration and planning had been requested – because the 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 needed to share one such expertise as nicely which discusses on expertise the place the decision is: Failed.