3Pillar Global Software Engineer Interview Questions and Answers

Q1. It is taken by manager's manager it is quit tough he asked high level of technical question
Add your answer

Q1. It was just a salary discussion .HR was very corporative and polite.
Add your answer

Q1. Core and Advance concepts of Java
Add your answer

Q1. Mainly on mutltithrerading concepts and previous experience on projects.
Add your answer

Q1. About projects and scenarios based questions.
Add your answer

Q1. About Salary negotiation and final round
Add your answer

Q1. Backend Questions regarding
Add your answer
Q2. UI Questions regarding Angular
Add your answer

Q1. Write an SQL query to fetch duplicates.
Ans. 
SQL query to fetch duplicates
• Use GROUP BY and HAVING clause to identify duplicates

• Select columns to be checked for duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Write SQL query to fetch nth highest Salary.
Ans. 
SQL query to fetch nth highest Salary
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary

• Consider handling cases where there might be ties for the nth highest salary
Answered by AI
Add your answer

Q1. Java,oop, microservice, JPA
Add your answer
Q2. Spring boot , MySQL
Add your answer

Q1. Java, spring boot
Add your answer
Q2. Microservice, rest api
Add your answer

Good technical round, you can manage, mainly Java questions used to come

Q1. HR round is also good package discussion will happen
Add your answer
Q2. Company personal so kept secret
Add your answer