CNK & Associates Team Manager Interview Questions and Answers

It was an aptitude test with basic SQL and Python based questions

It was an SQL round with questions from Hackerrank (Medium Complexity)

It was a Whiteboarding Interview with Partner on Pyspark and Pandas

Q1. Ways to fill a null value in SQL
Ans. 
Use COALESCE function, UPDATE statement, or CASE statement to fill null values in SQL.
• Use COALESCE function to replace null values with a specified default value

• Use UPDATE statement to update null values with a specific value

• Use CASE statement to conditionally fill null values based on certain criteria
Answered by AI
Add your answer
Q2. Window functions
Add your answer

Q1. Personal details as well as job experience
Add your answer

Q1. Job experience as well as situation based questions
Add your answer

Q1. They will ask you about your experience and knowledge.
Add your answer
Q2. They will ask you the reason for job change.
Add your answer
Q3. They can give you a task such as to share a process MAP covering different stakeholders.
Add your answer

Case study on startup funding and compliance requirement under applicable law

Q1. Validation of interpersonal soft skills
Add your answer
Q2. Demonstrate on how did you solve a real life complex problem by simple solutions
Add your answer

Q1. Mostly related to accounting standards such as IFRS 15, 9 and 16.
Add your answer
Q2. Explain the five step model of IFRS 15?
Ans. 
The five step model of IFRS 15 is a framework for recognizing revenue from contracts with customers.
• Step 1: Identify the contract with the customer

• Step 2: Identify the performance obligations in the contract

• Step 3: Determine the transaction price

• Step 4: Allocate the transaction price to the performance obligations

• Step 5: Recognize revenue when (or as) the entity satisfies a performance obligation
Answered by AI
Add your answer

Q1. Basic technical questions
Add your answer

Q1. Purely technical
Add your answer

Q1. With Executive Director
Add your answer

Q1. Ai use case in fp&a
Ans. 
AI in FP&A can be used for predictive analytics, forecasting, and scenario planning.
• AI can analyze historical financial data to predict future trends and outcomes.

• AI algorithms can be used to forecast sales, expenses, and cash flow with greater accuracy.

• AI can help in scenario planning by simulating different financial scenarios and their potential impact.

• AI can automate repetitive tasks like data entry, freeing up tim
Answered by AI
Add your answer

Q1. L1-5 FP&a process
Add your answer

Quantative analysis questions were asked