Pirimid Fintech Interview Questions and Answers

Coding test was of 1.5 hours on a hackerrank (2 coding questions + 20 MCQs). It was having a greedy type coding questions. MCQs were mixed from topics like DBMS, OS, Output questions.

Q1. LinkedList reversal, LinkedList Given node delete.
Add your answer
Q2. Priority Queue based question, --> Sum of maximums of each subarray of a given size.
Add your answer

Q1. In Depth Questions on the Projects that I worked on.
Add your answer
Q2. Law Level design based simple questions.
Add your answer

Design L2 Cache in java,
DSA question on queue, set
OOPs questions in Java

Q1. Design Netflix DB
Ans. 
Design a database for Netflix
• Use relational database like MySQL or NoSQL database like Cassandra

• Create tables for users, movies, genres, ratings, etc.

• Use indexing for faster search and retrieval of data

• Implement caching for frequently accessed data

• Consider scalability and high availability in the design
Answered by AI
Add your answer
Q2. Write DB queries
Ans. 
Write DB queries for SDE 2 interview
• Use SELECT statement to retrieve data from a database

• Use WHERE clause to filter results based on specific conditions

• Use JOIN clause to combine rows from two or more tables based on a related column

• Use GROUP BY clause to group rows that have the same values into summary rows

• Use ORDER BY clause to sort the result set in ascending or descending order
Answered by AI
Add your answer