Episeron Interview Questions and Answers

Q1. Questions related to devops tools such as azure terraform kubernetes.
Add your answer
Q2. Java concurrency and exception handling
Add your answer

Q1. Why do you want to join this organization?
Add your answer
Q2. Expected salary
Add your answer

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

2 coding questions .
topics were array and string

Q1. 2D array question and a linkedlist question (find the middle element of the list)
Add your answer
Q2. Dbms questions like keys ,normalization, acid properties, types of network layer , deadlock in os
Add your answer

Q1. Detect loop in a linkedlist
Ans. 
Use Floyd's Tortoise and Hare algorithm to detect loop in a linked list.
• Initialize two pointers, slow and fast, at the head of the linked list.

• Move slow pointer by one step and fast pointer by two steps.

• If they meet at any point, there is a loop in the linked list.
Answered by AI
Add your answer
Q2. SQL queries basic level .
Add your answer

Q1. Oops questions like inheritance and interface
Add your answer
Q2. Sql queries from leetcode hard level
Add your answer

Q1. About yourself, your past work experience and why you want to get into this role The interviewer was very calm and just wanted to learn about the background.
Add your answer

Q1. All behavioural questions- 1 how do your prioritise your work? 2 do you have experience in managing cross functional teams? 3 what if one of your Co-worker decline working on a project, How would you tackl...read more
Add your answer

Q1. Again all behavioural questions- How do you work with large volume of works? How do you manage work life balance? How do you give harsh feedbacks to your coworkers?
Add your answer

Q1. All behavioural questions again- same as above just a bit here and there asked in different ways
Add your answer

6 mcqs and 2 sql questions

Q1. Difference between having and where in sql
Ans. 
In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows before grouping

• HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: S
Answered by AI
Add your answer
Q2. Sql joins and it types
Add your answer
Q3. Window functions and subqueries
Add your answer
Q4. Sql scenario question based on joins
Add your answer
Q5. Kpi's and metrics
Add your answer

Q1. Business problem related to case study
Add your answer

Q1. What is the SQL query used to remove duplicates from a dataset?
Ans. 
Use the DISTINCT keyword in a SELECT query to remove duplicates from a dataset.
• Use the SELECT DISTINCT statement to retrieve unique rows from a table

• Example: SELECT DISTINCT column1, column2 FROM table_name;

• Another way is to use the GROUP BY clause with aggregate functions like COUNT() or SUM() to remove duplicates
Answered by AI
Add your answer
Q2. What is the SQL query to find the third highest salary in a table?
Ans. 
Use a subquery to find the third highest salary in a table using SQL.
• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the results to the third row.

• Use a subquery to select the third highest salary from the sorted list.
Answered by AI
Add your answer

Q1. What are the different roles in Power BI?
Ans. 
Different roles in Power BI include Power BI Developer, Power BI Analyst, Power BI Administrator, and Power BI User.
• Power BI Developer - responsible for creating and maintaining Power BI reports and dashboards

• Power BI Analyst - analyzes data using Power BI to provide insights and recommendations

• Power BI Administrator - manages security, access, and data sources in Power BI

• Power BI User - consumes reports and dashboards
Answered by AI
Add your answer
Q2. SQL - basicand advanced questions
Add your answer

Mostly questions on logical aptitude

Q1. DSA questions. Reverse word of string, bubble sort, swap two variables without use of third variable
Add your answer
Q2. OOPs concepts also some questions on project
Add your answer
Q3. 1 puzzle (refer gfg)
Add your answer

Q1. Why do you want to work at our company?
Add your answer
Q2. What was the toughest challenge you have ever faced?
Add your answer

Asked about Parking LOT coding question in VM

Q1. About yourself?
Add your answer
Q2. Delegates
Add your answer
Q3. Linq
Add your answer
Q4. ORMs
Add your answer
Q5. OOPS
Add your answer