AmbitionBox
Search
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
SEMS Welfare Foundation Interview Questions and Answers
Updated
27 Oct 2024
SEMS Welfare Foundation Interview Experiences
Popular Designations
4 interviews found
Anonymous
Interview experience
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one
(2 Questions)
- Q1. Tell me something about ?
- Q2. Types of research ?
- Ans.
Types of research include exploratory, descriptive, causal, and applied research.
Exploratory research aims to explore new ideas and insights.
Descriptive research focuses on describing characteristics of a population or phenomenon.
Causal research investigates cause-and-effect relationships.
Applied research is conducted to solve specific problems or answer practical questions.
Add your answer
Answered by
AI
Add your answer
Market Research Interview Questions asked at other Companies
Q1. Suppose a blank(without name and details)detergent packet is given to a customer. What type of questions will you ask from a customer to get insight about your product?
View answer
(1)
MANASA ROKKAM
Interview experience
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one
(2 Questions)
- Q1. Self introduction
- Q2. Business analytics vs Business Intelligence
- Ans.
Business analytics focuses on analyzing past data to make informed decisions, while business intelligence focuses on gathering, analyzing, and presenting data to support decision-making.
Business analytics involves using statistical analysis and predictive modeling to understand past performance and make future predictions.
Business intelligence involves collecting, analyzing, and presenting data to help organizations ma...
Add your answer
Answered by
AI
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Stay confident and answer
Marketing Intern Interview Questions asked at other Companies
Q1. Most of our website traffic comes from India while our target geography is the USA. How will you bring US traffic?
View answer
(1)
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected
I applied via campus placement at Lovely Professional University (LPU) and was interviewed in Sep 2023. There was 1 interview round.
Round 1 - HR
(2 Questions)
- Q1. Give your introduction ?
- Q2. Tell emabout your certifications ?
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Cv justification and good communication skills
Marketing Intern Interview Questions asked at other Companies
Q1. Most of our website traffic comes from India while our target geography is the USA. How will you bring US traffic?
View answer
(1)
I applied via campus placement at Lovely Professional University (LPU) and was interviewed in Feb 2022. There were 2 interview rounds.
Round 1 - Resume Shortlist
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR
(3 Questions)
- Q1. Why you have chosen this company?
- Q2. Tell me something about yourself?
- Q3. Why should I hire you ?
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Topics to prepare for SEMS Welfare Foundation Research Intern interview:
- Basic Interview questions
Research Intern Interview Questions asked at other Companies
Q1. Minimum no of steps needed to find the value of a nth order polynomial by making calls to a function that can compute the value of a 1st order polynomial( ax+b ). What is the answer if we can do parallel processing which allows us to call t...
read more
View answer
(1)
SEMS Welfare Foundation interview questions for popular designations
Jobs at SEMS Welfare Foundation
Top trending discussions
View All
Interview Tips & Stories
6d
zestyrose
·
works at
Infosys
Tips for getting interview call in naukri
I have 3 yoe in sap basis am currently preparing for interview. And also started to apply for jobs in naukri and indeed almost 30-45 application applied but not got even single interview call. Any tips pls😪. Lost hopes. Thanks in advance ❤
Got a question about SEMS Welfare Foundation?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I was interviewed in Jan 2025.
Round 1 - Technical
(14 Questions)
- Q1. What is the code to read a CSV file into a DataFrame using PySpark?
- Q2. What is your approach to refactoring code?
- Q3. How do you optimize pyspark code, how is peer review done,
- Q4. What is the SQL query to join employee departments along with the count of employees in each department?
- Q5. What is lazy evaluation in PySpark, and can you provide examples to illustrate this concept?
- Q6. How do you write SQL queries using PySpark code?
- Q7. What are the methods used to load data into a database?
- Q8. What is the redshift spectrum?
- Q9. What are the different types of indexing used in databases?
- Q10. Could you describe your experience with sharing your screen to write PySpark code during scenarios in a Teams call, especially when you were using a mobile device?
- Q11. What types of documentation are typically created during a project, and how is this documentation prepared?
- Q12. How do you ensure that your code is written optimally, and how do you evaluate, debug, and test it for various scenarios?
- Q13. What kind of documentation is written for pyspark code
- Q14. What are the best practices that you follow?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - 1. The role would have client round and the candidate will have to write code and solve issues immediately in client interview call, this is what interviewer said
2. As a data platform architect, the role requires extreme level understanding of pyspark and sql not just overview as in other data architect role.
3. Docu
2. As a data platform architect, the role requires extreme level understanding of pyspark and sql not just overview as in other data architect role.
3. Docu
Interview experience
Excellent
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
Selected
I was interviewed in Jan 2025.
Round 1 - One-on-one
(2 Questions)
- Q1. Sale price on on day
- Q2. Start working
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Fofocus heavily on networking, tailoring your resume with relevant keywords, actively following up with potential employers, showcasing your sales skills in interviews through storytelling, and monitoring companies you're interested in to stay updated on opportunities.
Key points to remember:
Prioritize networking:
Utilize your network to connect with people in the industry, attend industry events, and leverage platforms like LinkedIn to build relationships with potential hiring managers.
Tailor your resume:
Include relevant sales keywords throughout your resume to catch the attention of recruiters and ensure your experience aligns with the job description.
Practice your sales pitch:
Prepare compelling stories from your past experiences to demonstrate your ability to close deals, overcome objections, and build rapport during interviews.
Follow up consistently:
After submitting applications, send personalized follow-up emails to maintain engagement with potential employers.
Research companies:
Actively monitor companies you're interested in by following their social media and news to stay informed about potential openings.
Highlight transferable skills:
Even if you lack direct sales experience, emphasize skills like communication, persuasion, relationship building, and problem-solving that translate well to a sales role.
Ask insightful questions:
During interviews, demonstrate your knowledge of the company and role by asking thoughtful questions that show your genuine interest.
Be enthusiastic and confident:
Convey a positive attitude and express your passion for sales to make a strong impression on potential employers.
Key points to remember:
Prioritize networking:
Utilize your network to connect with people in the industry, attend industry events, and leverage platforms like LinkedIn to build relationships with potential hiring managers.
Tailor your resume:
Include relevant sales keywords throughout your resume to catch the attention of recruiters and ensure your experience aligns with the job description.
Practice your sales pitch:
Prepare compelling stories from your past experiences to demonstrate your ability to close deals, overcome objections, and build rapport during interviews.
Follow up consistently:
After submitting applications, send personalized follow-up emails to maintain engagement with potential employers.
Research companies:
Actively monitor companies you're interested in by following their social media and news to stay informed about potential openings.
Highlight transferable skills:
Even if you lack direct sales experience, emphasize skills like communication, persuasion, relationship building, and problem-solving that translate well to a sales role.
Ask insightful questions:
During interviews, demonstrate your knowledge of the company and role by asking thoughtful questions that show your genuine interest.
Be enthusiastic and confident:
Convey a positive attitude and express your passion for sales to make a strong impression on potential employers.
Anusha Kunapuri
Interview experience
Average
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected
Round 1 - One-on-one
(3 Questions)
- Q1. Basics like introduction background
- Q2. Introduce yourself
- Q3. What is your background
Add your answer
Add your answer
Add your answer
Round 2 - One-on-one
(1 Question)
- Q1. Interview are very simple and average person can clear huge hiring
Add your answer
Round 3 - Technical
(1 Question)
- Q1. 1. Screening 2. Introduction interview basic questions 3. Voice assessment 4. Written assignment 5. Confery test 6. Operation test 7. If qualified final manager round List looks scary to crack but v...
Add your answer
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I was interviewed in Jan 2025.
Round 1 - Technical
(8 Questions)
- Q1. Self intro and project architecture
- Q2. What are the data sources used?
- Q3. Bigquery architecture
- Q4. Partition vs clustering
- Q5. Bq commands on create table and load csv file
- Q6. Bq commands on show the schema of the table
- Q7. Explain about leaf nodes and columnar storage.
- Q8. How many slots are there in bigquery?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview experience
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Jan 2025.
Round 1 - Coding Test
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
Round 2 - Technical
(6 Questions)
- Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
- Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
- Ans.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
- Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
- Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
- Ans.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
- Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
- Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Add your answer
Answered by
AI
Add your answer
Add your answer
Answered by
AI
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I always suggest staying away from these companies commonly referred to as WITCH (Wipro, Infosys, TCS, Cognizant, HCL). You will rarely encounter good interviewers there unless there is an extreme necessity. Interview was judging me on the basis of syntex by seeing in his phone. How can everyone write each and everything on copy. For the low level design first time in my 6 years carrier someone asked to design without using kafka or any other library like spring boot to achieve that add in reminder list problem 😂. At first it was my bad after holding a offer of almost 27 lakh I somehow agreed for giving interview. Second thing I also know that after Even clearing they cannot afford 30LPA which I asked. I just went there because from last 6.5 year I have never attended any walking or face to face interview so was curious for it. Currently also working with somewhat premium product development company only. My experience was very bad. May be it can get vary person to person.
Interview experience
Excellent
Difficulty level
-
Process Duration
-
Result
Selected
Round 1 - Technical
(5 Questions)
- Q1. What is DHCP and how many type of DHCP and please explain how to work DHCP DORA Process ?
- Q2. What is OU and how to configure and Please Explain ADC ?
- Q3. What is APIPA and how to work and what is APIPA Range.
- Q4. Please explain OSPF and BGP ?
- Q5. What is OSI layer and please explain all Layer ?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
SEMS Welfare Foundation Interview FAQs
How many rounds are there in SEMS Welfare Foundation interview?
SEMS Welfare Foundation interview process usually has 1-2 rounds. The most common rounds in the SEMS Welfare Foundation interview process are HR, One-on-one Round and Resume Shortlist.
How to prepare for SEMS Welfare Foundation interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at SEMS Welfare Foundation. The most common topics and skills that interviewers at SEMS Welfare Foundation expect are Hospital Administration, International, MS Office, PDF and Time Management.
Tell us how to improve this page.
Interview Questions for Popular Designations
SEMS Welfare Foundation Interview Process
based on 3 interviews
Interview experience
View more
Interview Questions from Similar Companies
SEMS Welfare Foundation Reviews and Ratings
based on 7 reviews
Rating in categories
|
Human Resource
4
salaries
|  ₹2.5 L/yr - ₹10 L/yr |
|
Project Manager
3
salaries
| ₹3.5 L/yr - ₹4.5 L/yr |
Explore more salaries
Compare SEMS Welfare Foundation with
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Popular Calculators
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- SEMS Welfare Foundation Interview Questions
Share an Interview