NaviSite Payroll Consultant Interview Questions and Answers

Q1. What profile have you worked with?
Add your answer

Q1. What is the review cycle in your company
Add your answer

Q1. Not remember but related to SQL and ML
Add your answer
Q2. Related to SQL and ml
Add your answer

Q1. SQL queries scenario based
Add your answer
Q2. Just gave schema and asked 5 questions.
Add your answer

Logical Reasoning, Comprehension

General discussion on current affairs

Q1. C++ coding questions
Add your answer

Q1. Write a query to obtain the third transaction of every user
Ans. 
Query to retrieve the third transaction of every user
• Use a subquery to rank the transactions for each user

• Filter the results to only include the third transaction for each user
Answered by AI
Add your answer
Q2. Write a query that outputs the name of the credit card and how many cards are issued in it's launch month
Ans. 
Query to output the name of credit card and number of cards issued in launch month
• Use GROUP BY to group by launch month

• Count the number of cards issued in each launch month

• Select the name of the credit card and the count of cards issued
Answered by AI
Add your answer

Prepare well on basics of SQL, Python and Machine learning

Q1. Prior experiences, Future growth, case studies
Add your answer

Q1. Python SQL spark AWS and big data
Add your answer
Q2. Python SQL pyspark aws
Add your answer

Q1. PowerApps and PowerBI related questions
Add your answer

Q1. High level scenerio based analytical questions
Add your answer