Paytm Interview Expertise

• Expertise- 1 Yr
• Position- Knowledge Engineer
• Complete 4 rounds- 2 Technical, 1 Managerial, 1 HR Spherical.

1st Technical Spherical:

• Introduction, Skilled Background.
• How would you fee 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 a part of each the tables on x-y columns and rely the no. Of outputs primarily based on every type of be a part of – left, proper, interior, full spherical…..

Query 2: For this cricket scoreboard proven in your display screen, think about it as a desk or database after which put together queries for the specified end result (no matter type of information/ desk/ output I’m asking)

– 3-4 questions have been requested

Some Python questions- Primary degree

• To search out anagrams from the string record.
• The array is given to search 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 Huge 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 right way to optimize spark whereas engaged on its utility… How will you implement what you mentioned in an actual challenge?

Subsequent a Dataset was given and was requested: Utilizing spark code discover the reply for these 2 instances.

Verdict- Handed

third Spherical – Managerial

• Principally Situational & behavioral questions have been requested on this spherical after the technical data evaluation it’s extra of a persona take a look at to see if I’m an acceptable candidate or not. (Aside from tech.)
• Was requested concerning the tasks I labored on – in-depth discussions- challenges, Studying, achievements, position, instruments, day-to-day accountability, and many others. Fronts have been lined.
• Was there any state of affairs of Battle with the staff or any colleague at any given level…
• How did you resolve and confront such a state of affairs,
• In these jobs we cope with deadlines, so how did you handle your time? Was there any state of affairs 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 a web based ticketing system- information move, structure, and many others. …

Verdict – Handed

4th Spherical- HR

Coming to this spherical I used to be informed – Now we have obtained Constructive opinions from our managers and we wish to rent you. So this spherical goes to be a proper job dialogue spherical moderately 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.