Paytm Interview Expertise
- Expertise- 1 12 months
- Function- Information Engineer
- Complete 4 rounds- 2 Technical, 1 Managerial, 1 HR Spherical.
1st Technical Spherical:
- Introduction, Skilled Background.
- How would you charge your self on SQL?
- Fundamental Questions round SQL- Be a part of, Group by, order by, Rank, DDL, DML, and many others. Easy ideas.
Dataset based mostly Query:
Query 1: There are 2 tables A & B – 1st desk has an x column, with null and a few values, and one other desk B with y column having nulls & values…
Now be a part of each the tables on x-y columns and depend the no. Of outputs based mostly on every form of be a part of – left, proper, inside, full spherical…..
Query 2: For this cricket scoreboard proven in your display screen, contemplate it as a desk or database after which put together queries for the specified consequence (no matter form of information/ desk/ output I’m asking)
– 3-4 questions have been requested
Some Python questions- Fundamental stage
- To search out anagrams from the string checklist.
- The array is given to seek out pair whose sum is the same as given values x.
Fundamentals of Downside-solving (since talked about in resume)
Verdict – Handed.
2nd Technical Spherical
- Intro. , Resume-based questions on tasks and former job, instruments mentioned- what & how I precisely labored on them (implementation).
- Fundamentals of Large information and the way it’s totally different from conventional methodology like RDBMS.
- Apache, Spark, RDD, drivers, graphs, persistence, and allied questions of Apache and Spark.
- The way to optimize spark whereas engaged on its software… How will you implement what you mentioned in an actual venture?
Subsequent a Dataset was given and was requested: Utilizing spark code discover the reply for these 2 instances.
Verdict- Handed
third Spherical – Managerial
- Largely Situational & behavioral questions have been requested on this spherical after the technical data evaluation it’s extra of a persona check to see if I’m an appropriate candidate or not. (Aside from tech.)
- Was requested concerning the tasks I labored on – in-depth discussions- challenges, Studying, achievements, function, instruments, day-to-day accountability, and many others. Fronts have been lined.
- Was there any scenario of Battle with the group or any colleague at any given level…
- How did you resolve and confront such a scenario,
- In these jobs we cope with deadlines, so how did you handle your time? Was there any scenario the place you missed deadlines – what did you do then?
- An out-of-the-box query (given it was a managerial spherical)
- Give your method to designing an internet ticketing system- information circulation, structure, and many others. …
Verdict – Handed
4th Spherical- HR
Coming to this spherical I used to be informed – We’ve obtained Optimistic evaluations from our managers and we need to rent you. So this spherical goes to be a proper job dialogue spherical fairly than an interview.
I used to be requested about my hobbies, strengths, weak spot, wage dialogue, job location, job function, and division. And all that stuff.
Lastly Chosen.
