Es-Jay System & Software Interview Questions and Answers

Q1. Tell me about yourself?
Add your answer
Q2. Why ADP?
Add your answer

Q1. What do you know about SQL?
Add your answer
Q2. How can you write a query to retrieve details from two tables and present them in a single table format?
Add your answer
Q3. What is the SQL query to retrieve the number of students grouped by their respective streams?
Add your answer

Q1. More of your day to day activities as an engineering manager
Add your answer
Q2. Status reporting, Matrices EM should maintain,Risks and Mitigations , Conflict Resolution,
Add your answer

Q1. System Architecture
Add your answer
Q2. Basic Java collections like streams, collections , garbage collection , spring boot basic working
Add your answer

Q1. Team management
Add your answer
Q2. Project execution
Add your answer

Thirty-nine questions, including two coding challenges and three to four sets of games.

Q1. What is dynamic dispatch?
Add your answer
Q2. How do u manage stress?
Add your answer
Q3. What are environment variables in linux?
Add your answer
Q4. Explian merge sort.
Add your answer

Q1. Machine learning questions
Add your answer
Q2. Decision trees, random forest
Add your answer

Q1. ML Ops related questions
Add your answer

Q1. 1 hr interview divided into 4 sections - Intro - Backend - .NET & OOPS Concepts (Was given a code to analyze) - SQL - Write a sql query & some sql questions on joins etc. - Frontend - Angular related quest...read more
Add your answer

Q1. Bit low level Design Patterns Questions, SQL Questions, Angular Questions Checking your confidence while answering
Add your answer

Q1. This was Manegerial Round, asked about projects worked upon and some questions over the projects
Add your answer

Q1. For this round I was being called to their base location. Salary Discussion
Add your answer

The coding questions were at Leetcode difficulty level and were derived from the Striver sheet.

Q1. BFS graph level
Add your answer
Q2. Minimum flight distance . I was not shortlisted for interview.
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Arrays and strings - 90 mins

Create Modules, railway reservation system - 60 mins

Q1. Difference between hashmap and hasptable
Add your answer
Q2. Why typescript over javascript
Add your answer
Q3. Find the percentage of increace in the quantity of item after making it price 20% extra
Add your answer
Q4. What is normalization
Add your answer
Q5. Date and time api available
Add your answer