Profinch Solutions Senior Business Architect Interview Questions and Answers

Implement thread safe load balancer.
focus on input validations and cover all corner cases in tests

Q1. Self introduction
Add your answer
Q2. Company related information
Add your answer

General English, Aptitude and reasoning

Q1. General screening with operation manager
Add your answer
Q2. Opinion on KPI metrics. Example: Quality, AHT, CSAT etc.
Ans. 
KPI metrics are essential for measuring performance and identifying areas for improvement.
• KPI metrics provide a clear understanding of performance against goals

• Quality metrics can include error rates, compliance with standards, and customer satisfaction

• AHT (Average Handle Time) measures efficiency in handling customer interactions

• CSAT (Customer Satisfaction) metrics gauge customer happiness and loyalty

• Regularly reviewi...read more
Answered by AI
Add your answer

Q1. Explain Concurrency
Ans. 
Concurrency is the ability of a system to execute multiple tasks simultaneously.
• Concurrency allows multiple tasks to run concurrently, improving performance and efficiency.

• Concurrency can be achieved through multithreading or multiprocessing.

• Example: A web server handling multiple requests simultaneously using multithreading.
Answered by AI
Add your answer
Q2. Explain Acid principles
Ans. 
ACID principles are a set of properties that guarantee database transactions are processed reliably.
• Atomicity: Transactions are all or nothing. If one part of the transaction fails, the entire transaction is rolled back.

• Consistency: Transactions bring the database from one valid state to another. All constraints are satisfied.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once...read more
Answered by AI
Add your answer

Machine coding round.

Q1. Algorithm to calculate top k flight from source to destinaton.
Ans. 
Use Dijkstra's algorithm to find the top k shortest paths from source to destination.
• Implement Dijkstra's algorithm to find the shortest paths from source to all other nodes.

• Store the top k shortest paths found in a priority queue or heap.

• Return the top k shortest paths as the result.
Answered by AI
Add your answer

Machine coding round where SOLID principles are evaluated for real life use case

Q1. SQL Queries for JOINS
Ans. 
SQL queries for JOINS
• Use INNER JOIN to retrieve rows from both tables that have matching values

• Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table

• Use FULL JOIN to retrieve rows when there is a match in either table
Answered by AI
Add your answer
Q2. QUERY FOR metrics given in the sheet
Ans. 
The query is asking for metrics provided in a specific sheet.
• Identify the specific sheet being referred to in the question

• Review the metrics listed in the sheet

• Analyze the relevance of each metric to the query
Answered by AI
Add your answer

This is a case study round revolve around a business problem in which we have to analyse data driven solutions.

Q1. Find edge score of the nodes in a directed graph
Ans. 
Edge score of nodes in a directed graph
• Edge score is a measure of the importance of a node in a graph

• It is calculated by counting the number of edges that point to or from a node

• Nodes with higher edge scores are considered more important

• Edge score can be calculated using algorithms like PageRank or HITS
Answered by AI
Add your answer

Q1. Rotten oranges after every second in 2D matrix
Ans. 
Simulate rotting of oranges in a 2D matrix every second.
• Create a queue to store the coordinates of fresh oranges

• Iterate through the matrix and add the coordinates of fresh oranges to the queue

• Simulate the rotting process by iterating through the queue and rotting adjacent fresh oranges

• Keep track of the time taken for all oranges to rot

• Return -1 if there are any fresh oranges left after the simulation
Answered by AI
Add your answer
Q2. Java and Spring concepts, HTTP, HTTPS, OSI layers
Add your answer
Q3. DB design for air ticket booking system
Ans. 
DB design for air ticket booking system
• Create tables for flights, passengers, bookings, and payments

• Use foreign keys to establish relationships between tables

• Include fields for flight details, passenger information, and payment details

• Consider implementing a caching mechanism for frequently accessed data
Answered by AI
Add your answer

DP questions 1D DP and Array question

Q1. Java questions and technical questions from previous experience
Add your answer

Q1. Behavioural questions and standard HR questions
Add your answer
Q2. Why looking for job switch
Ans. 
Seeking new challenges and opportunities for growth in a different environment.
• Looking for new challenges and opportunities to learn and grow

• Interested in working with new technologies or industries

• Seeking a better work-life balance or company culture

• Want to expand my skill set and experience
Answered by AI
Add your answer