Conformis Interview Questions and Answers

Q1. Personal details
Add your answer
Q2. Experience privious
Add your answer

Q1. Personal details
Add your answer
Q2. Experience details
Add your answer
Q3. How u aproach handling team
Ans. 
I approach handling my team with clear communication, setting goals, providing support, and fostering a positive work environment.
• Establish clear expectations and goals for the team

• Provide regular feedback and support to team members

• Encourage open communication and collaboration within the team

• Recognize and reward team members for their achievements

• Address any conflicts or issues promptly and professionally
Answered by AI
Add your answer

Q1. Introduce your self
Add your answer
Q2. What is sale ? how you manage store
Add your answer

If one customer is angry from your product and service how will you handle

Q1. How Indexing works in DB
Ans. 
Indexing in DB is a technique to improve the speed of data retrieval by creating a data structure that allows for quick lookup of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

• Types of indexes include B-tree, hash, and bitmap indexes.

• Indexes can be unique or non-unique, clustered or non-clustered.

• Example: Creating an index on the 'email' column ...read more
Answered by AI
Add your answer
Q2. Spring Boot depenencies
Add your answer

Q1. System Design of Bookmyshow
Ans. 
Bookmyshow is a popular online ticketing platform for movies, events, and other entertainment.
• Bookmyshow allows users to browse and book tickets for movies, events, plays, sports, etc.

• The system should have features like seat selection, payment gateway integration, booking history, and notifications.

• Scalability is important to handle high traffic during popular movie releases or events.

• Integration with cinema partners ...read more
Answered by AI
Add your answer
Q2. Some SQL queries to write
Add your answer

Round 1 : Received Assessment with dataset and questions, within xlsx file format. question were on countifs, sumifs, conditional formatting, reports and dashboard, pivot chart.

Round 2: This round was on meet again dataset was provided and within 30 min i have to complete given task. and submit.

Q1. Round 3: Final Round with HR and Manager, Tasks were provided in google sheets, questions were like perform countifs, sumifs, vlookup, Nested IF, importrange, query, Pivot table, pivot chart.
Add your answer

Q1. General Question Tell me about yourself
Add your answer
Q2. How soon you can join
Add your answer

Read about MPIN that is used to access mobile banking apps

Many a times users end up setting an MPIN that is guessable because

1. It is a commonly used MPIN eg 1122

2. It is a combination of easily known demographics of the user. Eg: if the birthdate is 02- Jan-1998 then MPIN could be 0201 or 9802 or 0201 etc. Demographics such as these could be used alone or in a combination

a. DOB

b. Wedding Anniversary

c. Spouse birthday

Solutions Required

1. Part A: Assume that the MPIN is 4-digits. Write a program that suggests if the MPIN is a commonly used one. Ignore the demographics for this part

2. Part B: Enhance the above to take user's demographics as input and provides an output

a. Strength: WEAK or STRONG

3. Part C: Enhance the above to provide the following outputs

a. Strength: WEAK or STRONG

b. If weak then the reason why was it considered weak: It should give from the following the reasons as an array. Array should be empty if Strength is STRONG and non-empty if WEAK

i. COMMONLY_USED

ii. DEMOGRAPHIC_DOB_SELF

iii. DEMOGRAPHIC_DOB_SPOUSE

iv. DEMOGRAPHIC_ANNIVERSARY

4. Part E: Above with a 6-digit PIN

5. Write code that tests the above written code using a set of inputs. Write at least 20 test case in PYTHON

Q1. Medium leetcode
Add your answer

Q1. Regarding experience
Add your answer

Q1. General behavioural question
Add your answer

Q1. The interview was on sql first they took hacker rank test on dsa and in second round they called for f2f interview
Add your answer
Q2. They told to write two sql query
Add your answer

Q1. Ask basic details about me
Add your answer
Q2. Told me about company profile.
Add your answer

Q1. Ask me questions about technical knowledge
Add your answer
Q2. Discuss roll n responsibility and ask my background and experience
Add your answer

Given an assignment to complete and i did complete it but after it MR. Brajesh singh, totally ghosted me no as no reply no msg no call, even didnt tell me feed back that my assignment good or bad.