Thursday, February 9, 2023
HomeSoftware DevelopmentGSK Interview Expereince for Knowledge Analyst

GSK Interview Expereince for Knowledge Analyst

Howdy All,

GSK, one of many greatest pharma corporations visited our campus, this was an on-campus drive interview for the 4th 12 months B.Tech CSE / IS college students. They have been on the lookout for the Knowledge Analytics Position

Interview Course of:

  • Shortlisting based mostly on the standards 
  • On-line Evaluation: This consists of MCQs in addition to  SQL questions, I don’t keep in mind the platform the place the check was organized
    • Technical Spherical
    • Managerial HR Spherical

I acquired shortlisted for the additional course of, I believe someplace round 100-120 college students have been shortlisted for this OA. I cleared the check, because it was on SQL it was considerably difficult to write down the queries, largely the queries have been like utilizing sub-queries and utilizing partitions,  however if in case you have some hands-on observe with SQL you possibly can clear it, Someplace round 10-15 college students cleared it

I acquired chosen for the technical spherical, it was on-line TR,  right here comes probably the most shocking half

The interviewer requested me to introduce myself.

Then he requested me whether or not I’m snug with SQL,

He requested me about any tasks I did in Teachers, I mentioned him my tasks, and he requested me to point out the  Knowledge analytics venture which I did was Gross sales perception of the XYZ firm, as I did it on PowerBI he requested me questions like how did you are taking Database, how did you join it with powerBI , Options of PowerBI . I answered him no matter he requested and likewise mentioned that I used to be having coursework on information analytics within the 4year so I don’t know a lot in regards to the instruments. He was like yeah no matter you probably did was good.

He then requested me some SQL queries and requested me write on NOTEPAD and I wrote it.

He then requested me have you learnt partitions in SQL and I mentioned sure and mentioned him that in OA there have been questions based mostly on partitions and he mentioned okay.

Then he requested me in regards to the system design query to design the car parking zone in a buying complicated, I mentioned some lame solutions, and I mentioned him instantly that I don’t the idea of System Design he mentioned okay. 

Then he requested me a couple of questions:

I requested a couple of questions which he answered and likewise gave me some necessary ideas and recommendations and likewise mentioned to me that no matter you research, deep dive into that.

After this, I believed I wouldn’t be capable to make this spherical. 

Additionally, shock few of my associates have been additionally chosen for the Technical spherical, their interviews went very nicely than mine. For considered one of my associates, the interviewer requested in regards to the OOPs idea and likewise requested me to code it in any language and likewise a couple of SQL questions. And for different the interviewer requested in regards to the blockchain, he simply requested him to elucidate no matter you recognize about blockchain 

Finally, solely 5 of them have been chosen for the Managerial HR spherical, surprisingly I used to be considered one of them and my pal didn’t make it.

I acquired chosen for the Managerial HR spherical, and I used to be glad that I made it, but it surely hurts when you’re rejected within the HR spherical with out getting any suggestions 

So, this was an HR spherical and it was having 2 panelists, HR requested me to introduce myself, and I did it

Then she requested me about my Internship expertise which I had talked about within the resume, I defined it

Then she requested me a couple of personality-related questions and I answered them, then she requested me about working /shifts/relocation/coaching interval, I answered every thing positively and the spherical went nicely 

The following morning I acquired the mail that solely two college students have been chosen.




Please enter your comment!
Please enter your name here

Most Popular

Recent Comments