Purchasing Power Internship Experience For Internship (On-Campus)

Assessment:

There were Aptitude and coding QNs and I was selected in the assessment round but I didn’t attend the presenting ppt(pre-placement talk)

Technical and HR :

In the first round, they asked for puzzles with little technical, and 2nd round was all about the role that you selected I chose Data Analyst since I’m good in Python they asked some questions related to data and SQL queries based on joins (given 3 tables….) I did it. im selected HR but because I didn’t attend the PPT, I’m attending GD for another company they stressed here in HR I think so I lost there.

Interview Questions:

OOPs SQL if data analyst Front end backend:- react and if Full stack he gave 3 tables with student IDs, another table with programming languages, and students who enrolled in programming languages a student can enroll in more than 1 subject…. he asked me to write a query -> print all programming languages which are not enrolled by any student.

OOPs SQL if data analyst Front end backend:- react and if Full stack he gave 3 tables with student IDs, another table with programming languages, and students who enrolled in programming languages a student can enroll in more than 1 subject…. he asked me to write a query -> print all programming languages which are not enrolled by any student