Filter interviews by
Primary keys uniquely identify records in a database, while unique keys ensure no duplicate values in a column.
A primary key is a unique identifier for a record in a table, e.g., 'CustomerID' in a 'Customers' table.
A table can have only one primary key, but it can consist of multiple columns (composite key).
A unique key also enforces uniqueness but allows for one NULL value, e.g., 'Email' in a 'Users' table.
Primar...
Index+match is a combination of Excel functions used to lookup a value in a table based on row and column criteria.
Index function returns the value of a cell in a table based on the row and column number provided
Match function returns the position of a value in a range
Index+match is commonly used instead of Vlookup for more flexibility and accuracy
Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will return the v...
Use OFFSET and FETCH clauses in SQL to paginate responses.
Use OFFSET to skip a specified number of rows before returning the remaining rows.
Use FETCH to limit the number of rows returned after the OFFSET clause.
Example: SELECT * FROM table_name ORDER BY column_name OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
Various HR tools have been used in the past for different purposes.
One common HR tool used is an applicant tracking system (ATS) to manage the recruitment process.
Another tool is a performance management system to track and evaluate employee performance.
HRIS (Human Resource Information System) is used for managing employee data and HR processes.
Time and attendance tracking software is used to monitor employee atte...
AWS and Azure are cloud computing platforms used for hosting, managing and deploying applications and services.
AWS provides a wide range of services including compute, storage, database, analytics, machine learning, and more.
Azure offers similar services as AWS but also has a strong focus on integration with Microsoft technologies.
Both platforms offer scalability, flexibility, and cost-effectiveness for businesses...
Azure and AWS are cloud computing platforms with similar services, but differ in pricing, scalability, and integration.
Azure is more tightly integrated with Microsoft products, while AWS has a wider range of third-party integrations.
AWS has a larger market share and more mature services, while Azure is catching up quickly.
Azure offers more flexible pricing options, while AWS has a more complex pricing structure.
Az...
Yes, I am familiar with laptops, including their hardware, software, and troubleshooting techniques.
I have experience with various operating systems like Windows, macOS, and Linux.
I can perform hardware upgrades, such as adding RAM or replacing hard drives.
I am skilled in troubleshooting common issues, like connectivity problems or software errors.
I have used laptops for programming, graphic design, and general of...
Cluster and non-cluster in Power Apps refer to data organization and performance optimization in database management.
Clustered Index: In a clustered index, the data rows are stored in the same order as the index, improving retrieval speed. Example: A table sorted by 'ID'.
Non-Clustered Index: A non-clustered index creates a separate structure from the data rows, allowing for faster searches without altering data st...
I appeared for an interview in Jan 2025.
I have a strong understanding of HR operations and payroll responsibilities, including compliance, data management, and employee relations.
Knowledge of payroll processing, including calculating wages, taxes, and deductions
Understanding of HR policies and procedures, including compliance with labor laws
Experience with employee onboarding, offboarding, and benefits administration
Proficiency in HRIS systems and data manag...
I am seeking new challenges and opportunities for growth in my career.
Seeking new challenges to expand my skill set
Opportunities for career advancement
Desire for a more fulfilling role
Seeking a better work-life balance
I appeared for an interview in Dec 2024, where I was asked the following questions.
I possess strong leadership skills and a passion for sales, while I aim to improve my time management. PersolKelly aligns with my career goals.
Strength: Proven track record in exceeding sales targets by 20% in my previous role.
Strength: Excellent communication skills, enabling me to build strong relationships with clients.
Weakness: I sometimes struggle with time management, but I am actively using tools like Trello to ...
Experienced in L&D with a focus on client engagement and tailored training solutions for diverse industries.
Successfully closed deals with Fortune 500 companies by customizing training programs to meet their specific needs.
Utilized data-driven strategies to identify skill gaps within organizations, leading to targeted training solutions.
Implemented a consultative sales approach, building strong relationships with k...
I appeared for an interview in Dec 2024.
I appeared for an interview in Feb 2025, where I was asked the following questions.
Cluster and non-cluster in Power Apps refer to data organization and performance optimization in database management.
Clustered Index: In a clustered index, the data rows are stored in the same order as the index, improving retrieval speed. Example: A table sorted by 'ID'.
Non-Clustered Index: A non-clustered index creates a separate structure from the data rows, allowing for faster searches without altering data storage...
Primary keys uniquely identify records in a database, while unique keys ensure no duplicate values in a column.
A primary key is a unique identifier for a record in a table, e.g., 'CustomerID' in a 'Customers' table.
A table can have only one primary key, but it can consist of multiple columns (composite key).
A unique key also enforces uniqueness but allows for one NULL value, e.g., 'Email' in a 'Users' table.
Primary key...
I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.
About our experience
posted on 19 Dec 2023
I applied via Monster and was interviewed in Jun 2023. There were 3 interview rounds.
Various HR tools have been used in the past for different purposes.
One common HR tool used is an applicant tracking system (ATS) to manage the recruitment process.
Another tool is a performance management system to track and evaluate employee performance.
HRIS (Human Resource Information System) is used for managing employee data and HR processes.
Time and attendance tracking software is used to monitor employee attendanc...
I appeared for an interview before Apr 2024, where I was asked the following questions.
As a Regional Manager, I oversee operations, manage teams, and drive strategic initiatives to achieve business goals.
Conduct daily check-ins with team leaders to assess progress and address challenges.
Analyze sales data to identify trends and adjust strategies accordingly.
Facilitate training sessions to enhance team skills and product knowledge.
Develop and implement regional marketing campaigns to boost brand visibilit...
I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 3 interview rounds.
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
VLOOKUP stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
Index+match is a combination of Excel functions used to lookup a value in a table based on row and column criteria.
Index function returns the value of a cell in a table based on the row and column number provided
Match function returns the position of a value in a range
Index+match is commonly used instead of Vlookup for more flexibility and accuracy
Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will return the value ...
Use OFFSET and FETCH clauses in SQL to paginate responses.
Use OFFSET to skip a specified number of rows before returning the remaining rows.
Use FETCH to limit the number of rows returned after the OFFSET clause.
Example: SELECT * FROM table_name ORDER BY column_name OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
I appeared for an interview before Feb 2024.
Top trending discussions
The duration of PERSOLKELLY interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 23 interview experiences
Difficulty level
Duration
based on 195 reviews
Rating in categories
5-8 Yrs
₹ 15-45 LPA
5-7 Yrs
Not Disclosed
2-3 Yrs
₹ 10-18 LPA
Consultant
43
salaries
| ₹3.5 L/yr - ₹6.1 L/yr |
Senior Consultant
35
salaries
| ₹4 L/yr - ₹9.4 L/yr |
HR Consultant
14
salaries
| ₹4 L/yr - ₹5.2 L/yr |
Lead Consultant
12
salaries
| ₹7.5 L/yr - ₹13 L/yr |
Analyst
9
salaries
| ₹7 L/yr - ₹13.4 L/yr |
Reliance Communications
Henry Harvin Education
GAO Tek
Tata Teleservices