Paytm Interview Expertise
- Expertise- 1 Yr
- 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?
- Primary Questions round SQL- Be part of, Group by, order by, Rank, DDL, DML, and many others. Easy ideas.
Dataset primarily based 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 part of each the tables on x-y columns and depend the no. Of outputs primarily based on every form of be part of – left, proper, inside, full spherical…..
Query 2: For this cricket scoreboard proven in your display screen, take into account it as a desk or database after which put together queries for the specified outcome (no matter form of knowledge/ desk/ output I’m asking)
– 3-4 questions had been requested
Some Python questions- Primary degree
- To seek out anagrams from the string record.
- The array is given to seek out pair whose sum is the same as given values x.
Fundamentals of Drawback-solving (since talked about in resume)
Verdict – Handed.
2nd Technical Spherical
- Intro. , Resume-based questions on initiatives and former job, instruments mentioned- what & how I precisely labored on them (implementation).
- Fundamentals of Large knowledge 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.
- Easy methods to optimize spark whereas engaged on its software… How will you implement what you stated in an actual undertaking?
Subsequent a Dataset was given and was requested: Utilizing spark code discover the reply for these 2 circumstances.
Verdict- Handed
third Spherical – Managerial
- Principally Situational & behavioral questions had been requested on this spherical after the technical information evaluation it’s extra of a persona take a look at to see if I’m an appropriate candidate or not. (Other than tech.)
- Was requested concerning the initiatives I labored on – in-depth discussions- challenges, Studying, achievements, position, instruments, day-to-day duty, and many others. Fronts had 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 take care of 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 strategy to designing a web-based ticketing system- knowledge move, structure, and many others. …
Verdict – Handed
4th Spherical- HR
Coming to this spherical I used to be informed – We now have obtained Constructive opinions 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 point, wage dialogue, job location, job position, and division. And all that stuff.
Lastly Chosen.
