Sterling Healthcare IT Officer Interview Questions and Answers

There will be aptitude screening round.

There will be the different case studies , from the pharmaceutical sector.

Two coding questions, one is easy and the other is difficult. Who solved 2nd question was shortlisted for an interview.

Q1. Introduce yourself—questions from OS, DBMS, DSA, Project, and one coding problem.
Add your answer

Fairly easy 12 minutes - 50 questions test covering aptitude and verbal ability

1 hour test covering Aptitude and Logical reasoning and Data interpretation. Half hour asynchronous interview covering mostly situation based questions and guesstimate

An attrition data set was given and the deliverable was to draw as much insights as possible. Analysis using excel was sufficient.

Q1. The interview dealt mostly with situation based questions around previous work.
Add your answer

Q1. Very similar to the previous round and some standard HR questions
Add your answer

Q1. What is difference between inner join and full join
Ans. 
Inner join returns only the matching rows between two tables, while full join returns all rows from both tables.
• Inner join only includes rows that have a match in both tables

• Full join includes all rows from both tables, filling in NULL values for non-matching rows

• Inner join is more commonly used than full join in practice

• Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Example: Full ...read more
Answered by AI
Add your answer

Q1. General HR round
Add your answer

They asked the case study - like they gave the data and asked to present it in the deck

Simple aptitude test

Detailed Case Study with data analysis project work

Q1. Mostly typical interview questions
Add your answer
Q2. Strengths and Weaknesses
Add your answer

Q1. Technical question about c#. and SQL
Add your answer