NexTurn Talent Acquisition Specialist Interview Questions and Answers for Experienced

Q1. Ranking code in sql
Ans. 
Ranking code in SQL
• Use the RANK() function to assign a rank to each row based on a specified column

• Use the ORDER BY clause to determine the order of ranking

• Handle ties in ranking using the DENSE_RANK() function

• Use the ROW_NUMBER() function to assign a unique number to each row
Answered by AI
Add your answer
Q2. Read a file using python
Ans. 
To read a file using Python, use the open() function and specify the file path and mode.
• Use the open() function to open the file

• Specify the file path and mode (e.g., 'r' for reading)

• Read the contents of the file using the read() method

• Close the file using the close() method
Answered by AI
Add your answer
Q3. Reverse a array string using python
Ans. 
Reverses an array of strings using Python.
• Use the reverse() method to reverse the array in-place.

• Alternatively, use slicing with a step of -1 to create a new reversed array.

• Remember to convert the array to a list before reversing if necessary.
Answered by AI
Add your answer

3 SQL and 2 Python questions were asked, SQL was moderate, Python was tough

Basic questions python spark, sql

Q1. Salary discussion
Add your answer

It was easy to attend only general topics can be asked

Q1. Coding choise question
Add your answer

Q1. It was technical interview questions about python and sql
Add your answer

Q1. It was a basic screening round as it was a virtual walk-in drive so was asked basic details about my work experience
Add your answer

Q1. What do you worked on AWS
Add your answer
Q2. SQL aggregate and window question
Add your answer
Q3. Coding In python
Add your answer

Q1. AWS S3 Questions
Add your answer
Q2. AWS lambda Questions
Add your answer
Q3. AWS Redshift Questions
Add your answer

Q1. Why left previous company
Ans. 
Seeking new challenges and growth opportunities
• Desire for new challenges and growth

• Looking for a more innovative environment

• Seeking better work-life balance
Answered by AI
Add your answer
Q2. Salary Discussion
Add your answer

It was a coding round with sql ,python questions , few aptitude questions

Q1. They asked few questions sql and python and few questions - depending on the role
Add your answer
Q2. BASIC SQL WHAT YOU HAD WRITTEN IN THE CODE
Add your answer

Q1. They asked me few questions related to sql
Add your answer
Q2. BASIC PYTHON QUESTIONS LIKE WHAT YOU HAVE WRITTEN IN THE CODE
Add your answer

Q1. About yourself , your hobby etc
Add your answer

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Ans. 
ACID properties ensure data integrity in DBMS: Atomicity, Consistency, Isolation, Durability.
• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that multiple transactions can be executed concurrently without affecting each other.

• Durability ensures that once...read more
Answered by AI
Add your answer

Q1. HR question and family background
Add your answer