AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
PeopleStrong Interview Questions and Answers
29 Interview questions
Key HR processes in an organization include recruitment, onboarding, performance management, training and development, and employee relations.
Recruitment: Attracting, sourcing, and hiring new employees.
Onboarding: Introducing new employees to the organization and their roles.
Performance management: Setting goals, evaluating performance, and providing feedback.
Training and development: Providing opportunities for e...
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization is used to eliminate data redundancy by breaking up tables into smaller, related tables.
It helps in reducing data anomalies such as update anomalies, insert anomalies, and delete anomalies.
There are different levels of normalization - 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific ru...
A valid sudoku of 9*9 is a grid where each row, column, and 3x3 subgrid contains the numbers 1-9 without repetition.
Each row must contain the numbers 1-9 without repetition
Each column must contain the numbers 1-9 without repetition
Each 3x3 subgrid must contain the numbers 1-9 without repetition
To find the distance between two nodes in a binary tree, we can find the distance from the root to each node and then calculate the distance between the two nodes.
Calculate the distance from the root to each node using a recursive function
Find the lowest common ancestor of the two nodes
Calculate the distance from each node to the lowest common ancestor and add them together to get the total distance
Use Floyd's Tortoise and Hare algorithm to find a cycle in a linked list.
Initialize two pointers, slow and fast, at the head of the linked list.
Move slow pointer by one step and fast pointer by two steps until they meet.
If they meet, there is a cycle in the linked list.
Example: 1 -> 2 -> 3 -> 4 -> 2 (cycle at node 2)
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value to search for in the first column of the table.
table_array: The range of cells that contains the data.
col_index_num: The column number in the table from which to retrieve the value.
range_lookup: Optional. TRUE for app...
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
HLOOKUP stands for Horizontal Lookup.
It is used to search for a value in the top row of a table and return a value in the same column from a specified row.
Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: =HLOOKUP(123, A1:D4, 3, FALSE) will ...
Relocation can be comfortable with proper planning and support.
Proper planning and research can help make the relocation process smoother
Having a support system in place can ease the transition to a new location
Utilizing relocation services provided by the company can also make the process more comfortable
Find the maximum sum of a subarray within an array of integers.
Iterate through the array and keep track of the current sum and maximum sum.
If the current sum becomes negative, reset it to 0.
Return the maximum sum found.
Break a sentence into a list of strings of words
Use the split() method to break the sentence into an array of strings
Specify the delimiter to split the sentence by spaces
Handle punctuation marks and special characters appropriately
PeopleStrong Interview Experiences
53 interviews found
Nidhi Gulia
I appeared for an interview before Jul 2016.
Interview Questionnaire
6 Questions
- Q1. Use of primary key & foreign key
- Ans.
Primary keys uniquely identify records in a table, while foreign keys establish relationships between tables.
Primary keys ensure data integrity by enforcing uniqueness and preventing duplicate records.
Foreign keys create relationships between tables, allowing data to be linked and referenced across multiple tables.
Primary keys are typically used as foreign keys in related tables to establish relationships.
Foreign keys ...
- Q2. How to use inner joins
- Ans.
Inner joins are used to combine rows from two or more tables based on a related column between them.
Inner joins return only the matching rows from both tables.
The join condition is specified using the ON keyword followed by the column(s) to join on.
Inner joins can be used to retrieve data from multiple tables based on a common column.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
- Q3. Use of select command
- Ans.
The SELECT command is used to retrieve data from a database table.
SELECT is a fundamental SQL command used in database management systems.
It allows you to specify the columns and rows you want to retrieve from a table.
You can use various clauses like WHERE, ORDER BY, GROUP BY, etc. to filter and sort the data.
The result of a SELECT query is a result set or a cursor containing the selected data.
Example: SELECT * FROM em...
- Q4. How to create table
- Ans.
To create a table, use the CREATE TABLE statement in SQL.
Specify the table name after the CREATE TABLE keyword.
List the column names and their data types within parentheses.
Add any constraints or indexes as needed.
Example: CREATE TABLE employees (id INT, name VARCHAR(50), age INT);
- Q5. Self introduction
- Q6. Last company job roles
- Ans.
I worked as a Systems Analyst at XYZ Company, where I was responsible for troubleshooting and resolving application issues.
Troubleshooting and resolving application issues
Collaborating with developers to implement fixes
Providing technical support to end users
Interview Preparation Tips
Tips: Basics must be cleared.
Round: HR Interview
Tips: Candidate must be confident
Skills evaluated in this interview
Anonymous
(2 Questions)
- Q1. Project Discussions
- Q2. Java, Spring boot, Database and Angular
I appeared for an interview in Feb 2025, where I was asked the following questions.
- Q1. Inteview 1: Java + SpringBoot + DSA (Medium level questions) + Database Questions
- Q2. Interview 2: Java + Syste Design -> Worst experience ever, the interviewer copy pasted some questions, asked me to not explain anything and rejected for answering with the right answers, also left 40 mi...
I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Distance bw 2 nodes in binary tree
- Ans.
To find the distance between two nodes in a binary tree, we can find the distance from the root to each node and then calculate the distance between the two nodes.
Calculate the distance from the root to each node using a recursive function
Find the lowest common ancestor of the two nodes
Calculate the distance from each node to the lowest common ancestor and add them together to get the total distance
- Q2. Valid sudoku of 9*9
- Ans.
A valid sudoku of 9*9 is a grid where each row, column, and 3x3 subgrid contains the numbers 1-9 without repetition.
Each row must contain the numbers 1-9 without repetition
Each column must contain the numbers 1-9 without repetition
Each 3x3 subgrid must contain the numbers 1-9 without repetition
Skills evaluated in this interview
Ankita Sharma
(1 Question)
- Q1. Explain normalization in sql?
- Ans.
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization is used to eliminate data redundancy by breaking up tables into smaller, related tables.
It helps in reducing data anomalies such as update anomalies, insert anomalies, and delete anomalies.
There are different levels of normalization - 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules t...
Skills evaluated in this interview
Selected
I appeared for an interview in Feb 2025.
(2 Questions)
- Q1. Can you tell us about yourself?
- Q2. Can you describe your previous job?
- Ans.
In my previous role, I focused on enhancing employee engagement and optimizing workplace culture through various initiatives.
Conducted regular employee surveys to gather feedback and identify areas for improvement.
Implemented wellness programs that increased participation by 30%, promoting a healthier work-life balance.
Collaborated with HR to develop training sessions aimed at career development, resulting in a 20% inc...
A standard 30-minute aptitude test.
Sudhanshu Ranjan
Binary search
find minium in array.
I applied via Walk-in and was interviewed in Oct 2023. There were 3 interview rounds.
(3 Questions)
- Q1. Excel realated questions and answers
- Q2. Vlookup working formula
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value to search for in the first column of the table.
table_array: The range of cells that contains the data.
col_index_num: The column number in the table from which to retrieve the value.
range_lookup: Optional. TRUE for approxim...
- Q3. H lookup formula
- Ans.
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
HLOOKUP stands for Horizontal Lookup.
It is used to search for a value in the top row of a table and return a value in the same column from a specified row.
Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: =HLOOKUP(123, A1:D4, 3, FALSE) will searc...
Assignment 1 ,3 and 3
Payroll realated questions and answers
Interview Preparation Tips
- Excel
- Finance
- investment
Selected
Normal test with VARC Maths
(1 Question)
- Q1. About Principle consultancy
(1 Question)
- Q1. Tell me about yourself
ammu madhuri
Selected
I applied via Shine and was interviewed in Feb 2024. There were 2 interview rounds.
Genral knowledge questions based on Government
(5 Questions)
- Q1. Introduce yourself
- Q2. What choosed to select this field
- Q3. Education Backround
- Q4. Why role change is required
- Q5. Relocation is comfortable
- Ans.
Relocation can be comfortable with proper planning and support.
Proper planning and research can help make the relocation process smoother
Having a support system in place can ease the transition to a new location
Utilizing relocation services provided by the company can also make the process more comfortable
Kapil Nawhal
(2 Questions)
- Q1. DSA like stack,
- Q2. Framework questions
Top trending discussions
PeopleStrong Interview FAQs
The duration of PeopleStrong interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
PeopleStrong Interviews By Designations
- PeopleStrong Principal Consultant Interview Questions
- PeopleStrong Senior Software Developer Interview Questions
- PeopleStrong HR Recruiter Interview Questions
- PeopleStrong Senior Software Engineer Interview Questions
- PeopleStrong Payroll Specialist Interview Questions
- PeopleStrong HR Specialist Interview Questions
- PeopleStrong Recruitment Associate Interview Questions
- PeopleStrong Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 47 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
PeopleStrong Reviews and Ratings
based on 619 reviews
Rating in categories
11-21 Yrs
Not Disclosed
4-8 Yrs
Not Disclosed
12-25 Yrs
Not Disclosed
|
Senior Recruitment Associate
261
salaries
|  ₹3.5 L/yr - ₹7.7 L/yr |
|
Recruitment Associate
175
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
|
Recruitment Specialist
118
salaries
| ₹4.5 L/yr - ₹9.8 L/yr |
|
Payroll Specialist
97
salaries
| ₹2.3 L/yr - ₹7.2 L/yr |
|
Software Development Engineer II
81
salaries
| ₹13.3 L/yr - ₹24 L/yr |
Randstad
Team Lease
Innovsource Services
IMPACT Infotech
- Home >
- Interviews >
- PeopleStrong Interview Questions
