M.G.POLYBLENDS Interview Questions and Answers

Q1. Salary Expectation
Add your answer
Q2. Work Experience
Add your answer
Q3. Relocation Plans
Add your answer

Codility Test General C# and SQL

Q1. (live coding) Create a class Employees with fields FirstName LastName, DoB, and Gender Return avg age of employees, return avg age by genders
Ans. 
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
• Create a class Employees with fields FirstName, LastName, DoB, and Gender

• Calculate the average age of all employees

• Calculate the average age by genders
Answered by AI
Add your answer
Q2. What design pattern you know
Ans. 
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...read more
Answered by AI
Add your answer
Q3. SOLID principles
Add your answer
Q4. How to optimize SQL Queries
Ans. 
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using EXISTS or IN clauses instead

• Optimize query structure by using appropriate joins and subqueries
Answered by AI
Add your answer
Q5. Which type of Indexes you know
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered index: Physically reorders the data in the table based on the index key.

• Non-clustered index: Contains a sorted list of references to the table data rows.

• Unique index: Ensures that no two rows have the same values in the indexed columns.

• Composite index: Index that is created on multiple columns.

• Filtered index: Index that...read more
Answered by AI
Add your answer
Q6. Have you ever read SQL Execution Plan?
Ans. 
Yes, I have read SQL Execution Plans to optimize query performance.
• I have analyzed SQL Execution Plans to identify bottlenecks in queries.

• I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.

• I have made query optimization recommendations based on SQL Execution Plans.

• I have experience with tools like SQL Server Management Studio to view and analyze Execu
Answered by AI
Add your answer
Q7. .NET Framework DI 3th party tools
Add your answer
Q8. Are you familiar with MSUnit, xUnit, nUnit
Add your answer
Q9. Unit Testing libraries (e.g Bogus, Moq..)
Add your answer

Q1. What questions do you have?
Add your answer
Q2. How was your interview's?
Add your answer
Q3. Why you want to change your job?
Add your answer

It was a MCQ test on CS Fundamentals. We have to answer 50 questions in 40 minutes. Accuracy is must. Company have its own cutoff and it's usually high. So try to gain maximum marks as possible. The results were announced in 1.5 hrs. The selected candidates will be appearing for the coding challenge.

There are 5 questions. 1 easy , 3 medium, 1 hard. You should solve atleast 4 questions to get shortlisted for the interview. Results are announced in 2-3 hours. Take a look at these questions. One of the questions from the coding challenge will be asked in the interview.

Q1. Email validation question from coding challenge
Add your answer
Q2. Binary Search on rotated arrays
Add your answer
Q3. About projects (reason behind using the mentioned database)
Add your answer
Q4. Use of package.json file
Add your answer
Q5. What are scripts in package.json file
Add your answer

Q1. I have around 9 rounds interview in span of 2 months
Add your answer

Q1. Everyday one round interview
Add your answer

Q1. Same as above .it is too much
Add your answer

Q1. Same as above .it is too much
Add your answer

Q1. Same only .it is too much
Add your answer

4 member team interview

Q1. One on one interview
Add your answer

Q1. Reference . through referral I sent my resume
Add your answer

Q1. Salary discussion
Add your answer

Q1. It is too much
Add your answer

Q1. Graph theory questions related
Add your answer
Q2. Programming,data structure and algo
Add your answer

Q1. Intro about your self
Add your answer
Q2. Mostly focused on CSE fundamentals
Add your answer

Q1. SQL question ( window functions) dense_rank
Add your answer
Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
Add your answer
Q3. Some question on spark optimisations
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Why did you living your current organization?
Add your answer
Q3. What is your expected CTC?
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
• Research industry standards for similar positions

• Consider cost of living in the area

• Factor in benefits and bonuses offered by the company

• Be prepared to negotiate based on your value to the organization
Answered by AI
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a results-driven executive with over 10 years of experience in leading teams and driving business growth.
• Experienced executive with a proven track record of success

• Skilled in team leadership and business development

• Strong focus on achieving results and driving growth
Answered by AI
Add your answer
Q2. Why did you living your current organization?
Add your answer
Q3. How did you manage the night shift and traveling?
Ans. 
I managed the night shift and traveling by prioritizing rest, staying organized, and utilizing technology.
• Prioritized rest by ensuring adequate sleep during the day

• Stayed organized by planning ahead and packing essentials in advance

• Utilized technology for efficient communication and navigation while traveling
Answered by AI
Add your answer
Q4. What do you know about the EXL?
Ans. 
EXL is a leading operations management and analytics company that helps businesses improve performance.
• EXL offers services in areas such as finance and accounting, healthcare, insurance, and more

• They use advanced analytics and technology to drive business transformation

• EXL has a global presence with offices in multiple countries
Answered by AI
Add your answer
Q5. What is Insurance?
Ans. 
Insurance is a financial product that provides protection against potential risks and losses.
• Insurance involves an agreement between an individual or entity and an insurance company.

• The individual or entity pays a premium in exchange for coverage against specific risks, such as property damage, illness, or liability.

• Examples of insurance include health insurance, car insurance, life insurance, and property insurance.
Answered by AI
Add your answer
Q6. What do you know about the premium?
Ans. 
Premium refers to the amount of money an individual or business pays for an insurance policy.
• Premium is the cost of purchasing an insurance policy

• It is typically paid on a regular basis, such as monthly or annually

• The premium amount is determined by factors such as the type of insurance, coverage amount, and the individual's risk profile
Answered by AI
Add your answer
Q7. What is your current CTC and expectation?
Ans. 
My current CTC is $100,000 and I am looking for a 15% increase in my next role.
• Current CTC: $100,000

• Expectation: 15% increase

• Looking for opportunities in the range of $115,000 - $120,000
Answered by AI
Add your answer

Aptitude test to check grammar and English fluency. It has different types of questions like passage reading and give the answers of questions from the passage, email writing, essay, grammar sections with fill in the blanks and picture based scenario in which you have to write the steps.

Q1. Speed minimum 30.
Add your answer
Q2. Accuracy minimum 90 percent.
Add your answer

Q1. Discussion about the salary.
Add your answer
Q2. Fixing the package.
Add your answer