G N Altech Senior Engineer 3 Interview Questions and Answers

4 Rounds:
Online Assesment, Leetcode medium type questions
Application Design: Write solution with Design patterns
LLD
HLD

3 questions, 2 dsa and 1 sql query

LeetCode style DS Algo Questions

Q1. Low Level Design
Add your answer

Q1. High Level Design
Add your answer

Q1. Normal Behavioural Questions
Add your answer

Q1. Design a Url Shortener serive
Ans. 
A URL shortener service that converts long URLs into shorter, more manageable links.
• Generate a unique short code for each long URL

• Store the mapping between short code and long URL in a database

• Redirect users from short URL to original long URL when accessed
Answered by AI
Add your answer

Q1. What programming language are you most proficient?
Ans. 
I am most proficient in Java.
• Extensive experience in developing applications using Java

• Strong understanding of object-oriented programming principles

• Familiarity with popular Java frameworks like Spring and Hibernate
Answered by AI
Add your answer
Q2. .NET, Angular and Sql Server
Add your answer

Q1. How would you design a system that needs to handle million of records
Ans. 
I would design a system using scalable architecture, efficient data storage, and optimized query processing.
• Utilize a distributed database system like Cassandra or Hadoop for storing large volumes of data

• Implement data partitioning and sharding to distribute the data across multiple servers

• Use indexing and caching mechanisms to optimize query performance

• Employ load balancing techniques to evenly distribute incoming req...read more
Answered by AI
Add your answer