InfiSpark Assistant Program Manager Interview Questions and Answers

Q1. Tell me about a situation when you had a disagreement with your manager or peers? How did you manage the situation?
Add your answer
Q2. Tell me about a time when you missed a deadline for a project.
Add your answer
Q3. Why you want to leave your last role?
Add your answer
Q4. How would you rate your SQL proficiency?
Ans. 
I rate my SQL proficiency as advanced.
• I have extensive experience writing complex SQL queries for data analysis and reporting.

• I am proficient in optimizing queries for performance and efficiency.

• I have successfully designed and implemented database schemas for various projects.

• I am comfortable working with large datasets and joining multiple tables to extract relevant information.
Answered by AI
Add your answer

Q1. How would you rate your SQL?
Ans. 
I would rate my SQL skills as advanced.
• Proficient in writing complex SQL queries

• Experienced in optimizing database performance

• Familiar with stored procedures and triggers
Answered by AI
Add your answer
Q2. How do would reduce returns for a product? Speak aloud your thought process?
Ans. 
To reduce returns for a product, I would focus on improving product quality, providing clear instructions, and offering excellent customer support.
• Improve product quality to ensure it meets customer expectations

• Provide clear instructions on how to use the product to reduce user errors

• Offer excellent customer support to address any issues or concerns promptly
Answered by AI
Add your answer

Communication skills involve reading, listening, and speaking.

Q1. The first section was of sql . the first one was based on FROM and the second was based on JOINS.
Add your answer
Q2. The second section was based on DSA both question were DSA ARRAYS and STRING easy
Add your answer
Q3. The last section was devlopment section in which HTML ,CSS,JS code will be given and you have to correct it according to the required result given in the question
Add your answer

Q1. Tell me about your self ,it was the intro
Add your answer
Q2. After that i directed the interview towards dsa and oops (as far i heard from my friends they were asking DSA ,OOPS,DMBS,JAVA,APPTITUDE)
Add your answer

Coding test will be pretty hard. 2 questions will be giv

Coding test will be pretty hard. Have to choose any one of 2 questions given and solve it in 45 mins.
Atleast 70-80% test case needs to be cleared to pass

Q1. Drill down on the tech stack mentioned in CV
Add your answer
Q2. Basic concepts of Java
Add your answer
Q3. Advanced java like stream, sealed classes, webflux etc
Add your answer
Q4. Concepts on cloud, docker, kubernetes etc
Add your answer

1st round is Cognitive which consists of English, pseudocodes, Arthametic and reasoning.

2nd is coding consists of 2nd questions.

Q1. Introduce yourself? Tell me about your projects. Basics in python.
Add your answer
Q2. Why do you choose engineering
Ans. 
I chose engineering because I have always been fascinated by problem-solving and creating innovative solutions.
• Passion for problem-solving and creating innovative solutions

• Interest in technology and how things work

• Opportunities for creativity and continuous learning

• Desire to make a positive impact on society through technological advancements
Answered by AI
Add your answer

Verbal, reasoning, aptitude

Factorial, reverse string

Q1. Self introduction
Add your answer
Q2. Projects u have done
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines.
• Used HTML, CSS, and JavaScript for front-end development

• Implemented backend functionality using Node.js and MongoDB

• Incorporated user authentication and authorization features
Answered by AI
Add your answer
Q3. Questions on Oops concept
Add your answer
Q4. Program in python
Ans. 
Program in python
• Use Python's syntax to write code

• Utilize libraries and functions to achieve desired functionality

• Test the program to ensure it works correctly
Answered by AI
Add your answer
Q5. SQL question and DBMS
Add your answer

Q1. What is the best application of technology
Add your answer
Q2. Share a event how did u manage trurning around it .
Ans. 
I successfully turned around a failing project by implementing a new communication strategy and reorganizing the team.
• Identified the root causes of the issues

• Developed a new communication plan to keep stakeholders informed

• Reassigned tasks to team members based on their strengths

• Monitored progress closely and made adjustments as needed
Answered by AI
Add your answer

Q1. Introduce yourself
Add your answer
Q2. Best project and your contribution.
Add your answer

Q1. Difference between let and const in javascript
Add your answer
Q2. Map() uses
Add your answer
Q3. Concat 2 arrays
Add your answer