Subex Senior Consultant Interview Questions and Answers

Q1. Difference between procedure and function
Ans. 
A procedure is a set of instructions that performs a specific task, while a function returns a value after performing a specific task.
• Procedures do not return a value, while functions do.

• Functions can be called within expressions, while procedures cannot.

• Functions are used to calculate and return a value, while procedures are used to perform an action.

• Example: Procedure - a set of instructions to display a message on t...read more
Answered by AI
Add your answer
Q2. How many triggers can we create on a table
Ans. 
In SQL Server, you can create up to 32 triggers on a table.
• SQL Server allows up to 32 triggers per table

• Triggers can be of different types like DML triggers, DDL triggers, and logon triggers

• Each trigger can be defined for INSERT, UPDATE, or DELETE operations
Answered by AI
Add your answer

Q1. Expectation is to lead the data engineering team . So have to be technically strong. It was replacement position . Clearly have been informed Commercial LS experience was not mandatory. All the questions o...read more
Add your answer

Q1. This was conducted by partner of the organisation. After hearing about the salary he said Commercial LS is mandatory. Need not be technically sound.
Add your answer

Online hackerrank test. Keep time limit in mond. Sas test was easy for me, only had to keep track of time limit.

Q1. Not too difficult. Mainly questioned about the projects mentioned in resume.
Add your answer

Q1. Very similar to round 2 but got better clarity on role and ptoject
Add your answer

Q1. SpringBoot Questions
Add your answer
Q2. Server related questions
Add your answer

Q1. Ensemble Learning, Optimization techniques, Basics of Python and SQL
Add your answer
Q2. Know basics of ML and why for every model used in your projects
Add your answer

SQL questions with emphasis on business understanding

Q1. Mostly SQL questions, no questions from resume asked
Add your answer

Q1. Managerial round with questions about job change and roles in Fractal
Add your answer

Q1. Collection, java 8
Add your answer
Q2. Solid principles in java
Ans. 
SOLID principles are design principles in Java that promote software design that is easy to understand, maintain, and extend.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Subtypes must be substitutable for their base types.

• I - Interface Segregation...read more
Answered by AI
Add your answer
Q3. Spring mvc flow
Add your answer

SQL + Python test. 8 questions. Need to get 5 correct at least. Moderate difficulty.

Q1. Questions on profile background and details of projects delivered
Add your answer

Q1. 3 to 5 year goals
Ans. 
To become a recognized expert in the field of consulting and contribute to the growth and success of the organization.
• Obtain advanced certifications in consulting methodologies

• Lead and successfully deliver complex consulting projects

• Develop strong relationships with clients and become a trusted advisor

• Mentor and guide junior consultants to help them grow professionally

• Contribute to thought leadership by publishing arti
Answered by AI
Add your answer
Q2. Preferred mode of working
Ans. 
I prefer working in a collaborative environment that encourages open communication and feedback.
• I enjoy working in a team where everyone's ideas are valued and considered.

• I appreciate a work culture that fosters open communication and encourages feedback.

• I am comfortable working independently as well, but I believe that collaboration leads to better results.

• I am adaptable and can work in different modes depending on th...read more
Answered by AI
Add your answer
Q3. Background about fractal
Add your answer