Punama Innovation Interview Questions and Answers

Q1. End to end architecture of current project
Add your answer
Q2. Basic spark code to read & write files
Add your answer
Q3. How to upsert data in table in spark
Add your answer
Q4. How do you handle sudden increase in data volume
Add your answer
Q5. Discussion on delta tables & ACID transactions
Add your answer
Q6. Explain autoloader and use case in Databricks
Add your answer
Q7. SQL question using window functions Lead, row number
Add your answer
Q8. Python question using hashmap & String
Add your answer

Q1. Current project understanding end to end
Add your answer
Q2. Data pipeline design for a ride sharing company, ask bunch of follow up questions on the conclude a particular design.
Add your answer
Q3. Explain how you follow SDLC(Agile, waterfall) ?
Add your answer
Q4. Why are you looking for a change now
Add your answer

Q1. Basic introductions
Add your answer
Q2. What kind of work are you looking for? what do you know about the company
Add your answer
Q3. Willing to relocate?
Add your answer
Q4. Personal hobbies and aspirations
Add your answer

Q1. Find a number in array which is greater than left and right element
Ans. 
Iterate through array and check if element is greater than its adjacent elements
• Iterate through array and check if current element is greater than element at index-1 and index+1

• Return the first element found that satisfies the condition

• Handle edge cases where element is at the beginning or end of array
Answered by AI
View 2 more answers
Q2. Find the number in the string and return the sum of numbers
Ans. 
Find and sum numbers in a string
• Iterate through each character in the string

• Check if the character is a digit

• If digit, convert to integer and add to sum
Answered by AI
View 1 more answer

Q1. What is your experience in sales?
Add your answer
Q2. What was your target, and how frequently did you achieve it?
Add your answer
Q3. What are your expectations for working here at the company?
Add your answer

The assignment round consisted of two parts: the first part involved researching their company, writing a pitch, and identifying the appropriate personas, while the second part required me to pitch a product from my previous company and record the presentation.

Q1. How was your interview so far?
Add your answer
Q2. What are your salary expectations?
Add your answer

Mintu Babu lives in a smaller house than her brother and in a larger house than her parents. Her children reside with her, and she has no other relatives. If Mintu Babu's relative U lives in a larger house than her relative S, then all the following may be true except: \n\n1) S is U's father \n\n2) S is U's mother \n\n3) U is younger than S \n\n4) S is younger than U

Q1. 1. merge two linked list
Add your answer
Q2. 2. reverse a linked list.
Add your answer

It included mcqs and multiple coding questions.

Q1. Yours technical skillls related questions
Add your answer
Q2. Managerial questions
Add your answer

Q1. About yourself ?
Add your answer
Q2. Just asked questions on previous role
Add your answer
Q3. How many types of IOT devices are there
Ans. 
There are three main types of IoT devices: consumer, commercial, and industrial.
• Consumer IoT devices: Smart home devices like thermostats, lights, and security cameras.

• Commercial IoT devices: Smart meters, asset tracking systems, and connected vending machines.

• Industrial IoT devices: Sensors and actuators used in manufacturing, agriculture, and healthcare.
Answered by AI
Add your answer

Q1. Generate a Dataframe
Add your answer

Analytical and Problem-Solving Skills:

I was asked to analyze hypothetical business scenarios and propose solutions, demonstrating my ability to identify key issues, prioritize tasks, and recommend strategic actions.


Data Interpretation and Reporting:

Questions focused on my experience with data interpretation, report generation, and using analytical tools like SQL or Excel to derive insights from complex datasets.


Stakeholder Management and Communication:

There were discussions about my previous experiences in stakeholder management and how I effectively communicated with diverse teams to gather requirements and deliver solutions.


Process Improvement and Innovation:

Interviewers were interested in my approach to process improvement and innovation within a business context, including examples of projects where I had successfully implemented changes to optimize workflows or enhance efficiency.