AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Bristol-Myers Squibb Software Engineer2 Interview Questions and Answers
Bristol-Myers Squibb Software Engineer2 Interview Experiences
2 interviews found
Selected
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
Questions on pyspark, SQL, AWS and Python
Pyspark, SQL, python and AWS
Selected
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Find distinct without distinct keyword in SQL
- Ans.
Use GROUP BY to find distinct values in SQL without using the DISTINCT keyword.
Use GROUP BY clause with all columns in the SELECT statement
This will group the rows with the same values together, effectively giving distinct values
- Q2. Concat 3 columns and handle when null: select concat(a, b, c) from table
- Ans.
Concatenate 3 columns and handle null values in SQL query
Use CONCAT_WS function to concatenate columns and handle null values
Provide a separator as the first argument in CONCAT_WS function
Use IFNULL function to replace null values with a specified value
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I was interviewed in Nov 2016.
Interview Questionnaire
7 Questions
- Q1. Tell us about yourself. Why Marketing and Strategy according to you?
- Ans.
I am passionate about understanding consumer behavior and creating impactful marketing strategies to drive business growth.
I have always been fascinated by the psychology behind consumer decision-making and how it influences marketing strategies.
I enjoy analyzing market trends and competition to identify opportunities for growth and differentiation.
I believe that a strong marketing and strategy foundation is essential ...
- Q2. Give us an overview of the pharma market in India.
- Q3. How are the Healthcare and Pharmaceuticals markets different?
- Q4. Do research and present the current OA scenario in India.
- Ans.
Open Access (OA) scenario in India
India has seen a significant growth in OA initiatives in recent years
Several government-funded research institutions have adopted OA policies
Indian Council of Agricultural Research (ICAR) mandates OA for agricultural research
OA repositories like Indian Academy of Sciences, National Digital Library, etc. promote OA content
Some Indian journals have transitioned to OA models, such as the ...
- Q5. What population in India has health insurance and on which cases are they willing to use?
- Q6. Estimate the total number of Knee replacement surgeries taking place in India?
- Q7. Strengths and weaknesses.
- Ans.
My strengths include strong communication skills and attention to detail. My weaknesses include a tendency to overthink and difficulty saying no.
Strengths: strong communication skills
Strengths: attention to detail
Weaknesses: tendency to overthink
Weaknesses: difficulty saying no
Interview Preparation Tips
Experience: The country head and director of strategy both are BITS Pilani grads, so it was easier getting to the interview.
Tips: Clarity regarding the business functionality is essentional. Why 'XYZ' firm? Admitting what you don't know and the willingness to learn, staying grounded is imperative.
College Name: BITS Pilani
I was interviewed before May 2016.
Interview Questionnaire
8 Questions
- Q1. Tell us about yourself.
- Ans.
I am a recent graduate with a degree in Computer Science and a passion for coding and problem-solving.
Recent graduate with a degree in Computer Science
Passionate about coding and problem-solving
Experience with programming languages like Java, Python, and C++
Completed internships at tech companies such as Google and Microsoft
- Q2. What are your strengths and weaknesses?
- Ans.
My strengths include strong communication skills and attention to detail. My weaknesses include being overly critical of my own work and sometimes struggling with time management.
Strengths: strong communication skills
Strengths: attention to detail
Weaknesses: overly critical of my own work
Weaknesses: sometimes struggle with time management
- Q3. Why marketing and strategy?
- Ans.
Marketing and strategy are essential for business success as they help in understanding customer needs, creating competitive advantage, and driving growth.
Marketing helps in identifying customer needs and preferences.
Strategy helps in creating a roadmap for achieving business goals.
Marketing and strategy work together to create a competitive advantage.
They help in targeting the right audience and positioning products/s...
- Q4. What is the current scenario of the pharma market in India?
- Q5. How different are Pharma and Healthcare as business functions?
- Q6. How many Indians have health insurance? What percent of them use health insurance for conservative treatment solutions?
- Ans.
The number of Indians with health insurance and the percentage using it for conservative treatment solutions is not available.
Data on the number of Indians with health insurance is not available.
Data on the percentage of Indians using health insurance for conservative treatment solutions is not available.
No specific examples or statistics can be provided without the available data.
- Q7. Estimate the number of knee replacement surgeries in India.
- Q8. Challenges that a typical pharmaceutical company face from sales and marketing POV in India wrt abroad.
Interview Preparation Tips
Duration: 1 hour
Total Questions: 15
Round: Technical + HR Interview
Experience: The country head and director of strategy are BITS Pilani grads, which helped to get the interview.
Tips: Have clarity regarding the business functionality applying for. Understand how the business function you are applying for is unique given the industry you are going to work in comared to others. Admitting weaknesses and the zeal to learn back ,staying grounded is imperative
College Name: BITS Pilani
I applied via Other and was interviewed before Oct 2017. There were 2 interview rounds.
Interview Preparation Tips
Experience: Internal vacancy
General Tips: It was a technical and test in writing then after shortlisting interview with HR and Department head for personal and general topics and knowledge of the company if any and to test stress level
Then Medical test
Posting in the respective plant where vacancy was there as allotted by the departmental head
Skills: Language, Communication, Presentation Skills
Duration: 1-4 weeks
Intern Interview Questions & Answers
GlaxoSmithKline Pharmaceuticals
Anonymous
posted on 25 Aug 2017
I was interviewed in Jul 2017.
Interview Preparation Tips
Experience: It was a learning experience, mostly behavioral questions along with questions about everything on my resume.
College Name: The University of Alabama
Interview Questionnaire
2 Questions
- Q1. Basics on my tool, puzzle
- Q2. Functional round
Interview Preparation Tips
Experience: Aptitude, market research
Round: Test
Experience: Technical written test
I applied via Naukri.com and was interviewed in Mar 2020. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Tell me about yourself
- Q2. Why you wanted to switch
- Q3. Technical questions related to resume
Interview Preparation Tips
Go through your resume..
I applied via Naukri.com and was interviewed before Jan 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. 1. Most questions were related to resume and previous work experience 2. Why should we hire you 3. What methodology did you follow for process transformation 4. What tools and thechniques you have worked?
Interview Preparation Tips
If you dont know any answer, just tell them politely. No need to lie or beat around the bush
I applied via Recruitment Consultant and was interviewed in Feb 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Technical questions regarding Sas and aptitude questions and previous company project details
Interview Preparation Tips
Bristol-Myers Squibb Interview FAQs
Tell us how to improve this page.
Bristol-Myers Squibb Interviews By Designations
- Bristol-Myers Squibb Software Engineer2 Interview Questions
- Bristol-Myers Squibb Sourcing Manager Interview Questions
- Bristol-Myers Squibb Reporter Interview Questions
- Bristol-Myers Squibb Mobile Application Developer Interview Questions
- Bristol-Myers Squibb Senior Payroll Analyst Interview Questions
- Bristol-Myers Squibb Analyst II Interview Questions
- Bristol-Myers Squibb Full Stack Developer Interview Questions
- Bristol-Myers Squibb Data Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Softwaretest Engineer Interview Questions
- Software Engineer Trainee Interview Questions
- Software Developer Intern Interview Questions
- Software Development Engineer Interview Questions
- Junior Software Developer Interview Questions
- Show more
Bristol-Myers Squibb Software Engineer2 Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Bristol-Myers Squibb Software Engineer2 Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Research Associate
34
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Associate Scientist
32
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Manager
30
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
25
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate Scientist
23
salaries
| ₹0 L/yr - ₹0 L/yr |
Pfizer
Merck
Novartis
GlaxoSmithKline Pharmaceuticals
- Home >
- Interviews >
- Bristol-Myers Squibb Interview Questions >
- Bristol-Myers Squibb Software Engineer2 Interview Questions
