Add office photos
Filter interviews by
Great Four Systems Interview Questions and Answers
1 interview found
Anonymous
I applied via Hirist and was interviewed in May 2022.
3 Interview Rounds
Resume Shortlist Round
Coding Test Round
Be prepared for frequently asked questions if you're going for upto 2yrs of experience. Questions like how to remove duplicate records? How to display each record twice in a table? What is Index and its types?
What's the syntax of procedure? How to get nth highest record in a table?
What's the difference between delete and truncate?
What's the difference between commit, rollback and savepoint?
So on may be expected...
HR Round (1 Question)
- Q1. HR informed about Company Norms and discussed with the LPA. Add Answer
Interview Preparation Tips
Initial 2 interviews will become toughest of all but note the questions asked in each interview and prepare them for next interview to boost the confidence.
All the best...
Top trending discussions
Interview questions from similar companies
Artyom Yeprikyan
I applied via Approached by Company and was interviewed in Oct 2024.
4 Interview Rounds
HR Round (3 Questions)
- Q1. Salary Expectation Add Answer
- Q2. Work Experience Add Answer
- Q3. Relocation Plans Add Answer
Coding Test Round
Codility Test General C# and SQL
Technical Round (9 Questions)
- Q1. (live coding) Create a class Employees with fields FirstName LastName, DoB, and Gender Return avg age of employees, return avg age by genders View Answers (1)
- Q2. What design pattern you know View Answers (1)
- Q3. SOLID principles Add Answer
- Q4. How to optimize SQL Queries View Answers (1)
- Q5. Which type of Indexes you know View Answers (1)
- Q6. Have you ever read SQL Execution Plan? View Answers (1)
- Q7. .NET Framework DI 3th party tools Add Answer
- Q8. Are you familiar with MSUnit, xUnit, nUnit Add Answer
- Q9. Unit Testing libraries (e.g Bogus, Moq..) Add Answer
Final Round Round (3 Questions)
- Q1. What questions do you have? Add Answer
- Q2. How was your interview's? Add Answer
- Q3. Why you want to change your job? Add Answer
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement
3 Interview Rounds
Aptitude Test Round
It was a MCQ test on CS Fundamentals. We have to answer 50 questions in 40 minutes. Accuracy is must. Company have its own cutoff and it's usually high. So try to gain maximum marks as possible. The results were announced in 1.5 hrs. The selected candidates will be appearing for the coding challenge.
Coding Test Round
There are 5 questions. 1 easy , 3 medium, 1 hard. You should solve atleast 4 questions to get shortlisted for the interview. Results are announced in 2-3 hours. Take a look at these questions. One of the questions from the coding challenge will be asked in the interview.
Technical Round (5 Questions)
- Q1. Email validation question from coding challenge Add Answer
- Q2. Binary Search on rotated arrays View Answers (1)
- Q3. About projects (reason behind using the mentioned database) Add Answer
- Q4. Use of package.json file View Answers (1)
- Q5. What are scripts in package.json file View Answers (1)
Interview Preparation Tips
Skills evaluated in this interview
Selected
10 Interview Rounds
One-on-one Round (1 Question)
- Q1. I have around 9 rounds interview in span of 2 months View Answers (1)
One-on-one Round (1 Question)
- Q1. Everyday one round interview View Answers (1)
One-on-one Round (1 Question)
- Q1. Same as above .it is too much Add Answer
One-on-one Round (1 Question)
- Q1. Same as above .it is too much Add Answer
One-on-one Round (1 Question)
- Q1. Same only .it is too much Add Answer
Case Study Round
4 member team interview
One on one interview Round (1 Question)
- Q1. One on one interview Add Answer
One on one interview Round (1 Question)
- Q1. Reference . through referral I sent my resume Add Answer
HR Round (1 Question)
- Q1. Salary discussion Add Answer
No Round (1 Question)
- Q1. It is too much Add Answer
2 Interview Rounds
Technical Round (2 Questions)
- Q1. Graph theory questions related Add Answer
- Q2. Programming,data structure and algo Add Answer
One-on-one Round (2 Questions)
- Q1. Intro about your self Add Answer
- Q2. Mostly focused on CSE fundamentals Add Answer
I applied via Job Portal and was interviewed in Oct 2024.
1 Interview Round
Technical Round (3 Questions)
- Q1. SQL question ( window functions) dense_rank Add Answer
- Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins Add Answer
- Q3. Some question on spark optimisations Add Answer
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in May 2024.
5 Interview Rounds
HR Round (3 Questions)
- Q1. Tell me about yourself? Add Answer
- Q2. Why did you living your current organization? Add Answer
- Q3. What is your expected CTC? View Answers (1)
One-on-one Round (7 Questions)
- Q1. Tell me about yourself? View Answers (1)
- Q2. Why did you living your current organization? Add Answer
- Q3. How did you manage the night shift and traveling? View Answers (1)
- Q4. What do you know about the EXL? View Answers (1)
- Q5. What is Insurance? View Answers (1)
- Q6. What do you know about the premium? View Answers (1)
- Q7. What is your current CTC and expectation? View Answers (1)
Aptitude Test Round
Aptitude test to check grammar and English fluency. It has different types of questions like passage reading and give the answers of questions from the passage, email writing, essay, grammar sections with fill in the blanks and picture based scenario in which you have to write the steps.
Typing Test Round (2 Questions)
- Q1. Speed minimum 30. Add Answer
- Q2. Accuracy minimum 90 percent. Add Answer
HR Round (2 Questions)
- Q1. Discussion about the salary. Add Answer
- Q2. Fixing the package. Add Answer
Interview Preparation Tips
1 Interview Round
One-on-one Round (5 Questions)
- Q1. Salary why not time being paid ? Add Answer
- Q2. Without any evidence how blaming staff ?? View Answers (1)
- Q3. Company always carried out theft staff ? Add Answer
- Q4. No one professional staff in office and overall company ?? Add Answer
- Q5. Why directors board unseen to thefts?? View Answers (1)
Interview Preparation Tips
Hr team non capable and non educated people
I applied via Company Website and was interviewed in Jun 2024.
3 Interview Rounds
Coding Test Round
Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte
Aptitude Test Round
30 Aptitude Question
3 Mail Writing Question
Technical Round (5 Questions)
- Q1. Explain 1st Problem Solved in Coding Test. Optimize it. View Answers (1)
- Q2. Explain 2nd Problem Solved in Coding Test. I failed 1 test case in 1st round which was told to solve again. Add Answer
- Q3. Explain 3rd Question based on SQL Query. View Answers (1)
- Q4. Write a code to Reverse Digits. View Answers (2)
- Q5. A problem question for solving a SQL Query. Add Answer
Interview Preparation Tips
Stay continuously in contact, call the HR for updates as they don't call you, We need to call them else you will wait entire life.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Sep 2024.
1 Interview Round
Assignment Round
The Hiring team and the trial team is very supportive, and the trial assignment was challenging and enjoyable. At First round the assignment is for design the Ai chat to Human chat process, that was very challenging, and I think best lesson I get from the assignment. and 2nd assignment to design and case study of the helplama website and i give best from my side and the team was very supportive and the work environment also best.
Great Four Systems Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
People are getting interviews through
Interview Questions from Similar Companies
Great Four Systems Reviews and Ratings
based on 9 reviews
Rating in categories
|
Software Engineer
19
salaries
|  ₹4 L/yr - ₹9.6 L/yr |
|
Software Developer
14
salaries
| ₹2.5 L/yr - ₹6.5 L/yr |
|
Business Analyst
8
salaries
| ₹4.1 L/yr - ₹7.6 L/yr |
|
SQL Developer
8
salaries
| ₹4.2 L/yr - ₹4.8 L/yr |
|
Quality Analyst
6
salaries
| ₹3.1 L/yr - ₹6.2 L/yr |
Exl India
Amazon Sellers Services
Primus Global Technologies
GAMMON INDIA
Calculate your in-hand salary
- Home >
- Interviews >
- Great Four Systems Interview Questions
