Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Birlasoft Team. If you also belong to the team, you can get access from here

Birlasoft Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Birlasoft Senior Consultant Interview Questions, Process, and Tips

Updated 1 Mar 2025

Top Birlasoft Senior Consultant Interview Questions and Answers

  • Q1. What is the difference between the cursors declared in procedures and those declared in package specifications?
  • Q2. What is the difference between triggers and stored procedures in a Database Management System (DBMS)?
  • Q3. What is a trigger in the context of a database management system?
View all 8 questions

Birlasoft Senior Consultant Interview Experiences

7 interviews found

Senior Consultant Interview Questions & Answers

user image Abhimanyu Moharana

posted on 10 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Java related starting from basic to advanced
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Questions from java basic to moderate and then advanced level java question
Round 2 - Technical 

(1 Question)

  • Q1. Some technical, then last project related then since situation and scenario based.

Senior Consultant Interview Questions Asked at Other Companies

asked in Capgemini
Q1. 1. What's the use of update sets and how do you move update set f ... read more
Q2. 1. What is Virtual DOM? How does it work & Its algorithm? 2. ... read more
asked in Capgemini
Q3. 1. If MAM is there then why do we need MDM? 2. What are the diffe ... read more
asked in Birlasoft
Q4. What is the difference between the cursors declared in procedures ... read more
asked in Capgemini
Q5. JCL 1. Ways in which the you can paas on data from.jcl to cobol.: ... read more

I appeared for an interview in Jun 2021.

Round 1 - Video Call 

(3 Questions)

Round duration - 45 minutes
Round difficulty - Medium

Technical Interview round that lasted for around 45 minutes. Intermediate level of PL/SQL questions were asked.

  • Q1. What is the difference between the cursors declared in procedures and those declared in package specifications?
  • Ans. 

    Cursors declared in procedures are local to the procedure, while those declared in package specifications can be accessed by multiple procedures within the package.

    • Cursors declared in procedures are only visible within that specific procedure.

    • Cursors declared in package specifications can be shared and accessed by multiple procedures within the package.

    • Package-level cursors can be useful for reusing the same query logi

  • Answered by AI
  • Q2. What is a PL/SQL cursor?
  • Ans. 

    A PL/SQL cursor is a pointer used to fetch and manipulate data in a database table.

    • PL/SQL cursor is used to retrieve data row by row from a result set.

    • It allows for processing individual rows returned by a query.

    • Cursors are typically used in loops to iterate through query results.

    • Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;

  • Answered by AI
  • Q3. What is a trigger in the context of a database management system?
  • Ans. 

    A trigger in a database management system is a set of instructions that automatically execute in response to certain events on a table or view.

    • Triggers are used to enforce business rules, perform data validation, and maintain data integrity.

    • They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

    • Examples of triggers include auditing changes to a table, updating related tables when a r...

  • Answered by AI
Round 2 - Video Call 

(3 Questions)

Round duration - 45 minutes
Round difficulty - Medium

Technical interview round that lasted for about 45 minutes. Questions were based on PL/SQL in Oracle and dbms related.

  • Q1. What is the difference between triggers and stored procedures in a Database Management System (DBMS)?
  • Ans. 

    Triggers are automatically executed in response to certain events, while stored procedures are pre-written scripts that can be manually executed.

    • Triggers are event-driven and automatically executed when a specified event occurs in the database.

    • Stored procedures are pre-written scripts that can be manually executed by users or applications.

    • Triggers can be used to enforce data integrity rules or audit changes in the data...

  • Answered by AI
  • Q2. What is the difference between ROWID and ROWNUM in SQL?
  • Ans. 

    ROWID is a unique identifier for a row in a table, while ROWNUM is a pseudo-column that assigns a unique number to each row retrieved from a query.

    • ROWID is a physical address of a row in a table, while ROWNUM is a virtual column generated by a query result set.

    • ROWID remains constant for a row even if the row is updated, while ROWNUM changes based on the order of rows retrieved from a query.

    • ROWID is unique within a tabl

  • Answered by AI
  • Q3. Can you explain SQL join related queries?
  • Ans. 

    SQL join queries are used to combine rows from two or more tables based on a related column between them.

    • Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • INNER JOIN returns rows when there is at least one match in both tables.

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN returns all rows from the right table and the matched rows from...

  • Answered by AI
Round 3 - HR 

Round duration - 30 minutes
Round difficulty - Easy

HR based round. The interviewer asked a few questions to know more about me. We also discussed the salary.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPABirlasoft Ltd. interview preparation:Topics to prepare for the interview - PL/SQL, SQL, DBMS, Algorithms, System Design, OOPSTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. What is your project exp in SCM module
  • Ans. 

    I have 5 years of project experience in implementing and optimizing SCM modules.

    • Implemented end-to-end supply chain solutions for a global manufacturing company

    • Optimized inventory management processes to reduce costs and improve efficiency

    • Led cross-functional teams in implementing new SCM software systems

    • Developed and implemented KPIs to measure supply chain performance

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Behavourial questions

Birlasoft interview questions for designations

 Senior Lead Consultant

 (2)

 Senior Technical Consultant

 (2)

 Senior Principal Consultant

 (1)

 Consultant Specialist

 (7)

 Lead Consultant

 (4)

 Software Consultant

 (1)

 JDE Consultant

 (1)

 Principal Consultant

 (1)

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Dec 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. 1.About technology basic to moderate? 2.Situation based questions? Your introduction All questions were based on our resume. Thank you so much
  • Q2. Situation based and from resume
  • Q3. Situation based questions were present.
Round 3 - One-on-one 

(2 Questions)

  • Q1. Situation based questions were involved.
  • Q2. Questions from resume were present

Interview Preparation Tips

Interview preparation tips for other job seekers - Thanks!!
Be clear with basics and attend interview confidently.

Get interview-ready with Top Birlasoft Interview Questions

I appeared for an interview in Sep 2021.

Round 1 - Technical 

(1 Question)

  • Q1. Idoc to proxy connections
Round 2 - Technical 

(1 Question)

  • Q1. Ale configurations in SAP PI PO
  • Ans. 

    ALE configurations in SAP PI PO

    • ALE (Application Link Enabling) is used for exchanging data between different SAP systems

    • ALE configurations in SAP PI/PO involve setting up logical systems, ports, partner profiles, and distribution models

    • ALE can be used for both inbound and outbound communication

    • ALE can be configured using transaction codes such as SALE, BD64, and WE20

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good over all experience and the on boarding process was also smooth.

Skills evaluated in this interview

Senior Consultant Jobs at Birlasoft

View all

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. 1. Tell me about yourself?
  • Q2. Ricefw concepts Reports Odata
  • Q3. Web dynpro
  • Q4. Smartform
  • Q5. Module pool programming Performance tuning techniques Enhancement techniques Oops ABAP concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare all basic concepts and be genuine with your answers. Web dynpro smartform and odata will add advantage.

Interview questions from similar companies

I applied via Approached by Company and was interviewed before Oct 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. General questions about my experience and expertise
Round 3 - Technical 

(1 Question)

  • Q1. About business analysis
Round 4 - HR 

(1 Question)

  • Q1. When can you start? Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Check each and every Salary component before accepting the offer

I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Coding Test 

There was one problem solving question based on binary tree concept.
And rest were aptitude test

Round 2 - Technical 

(2 Questions)

  • Q1. What is a binary tree?
  • Ans. 

    A binary tree is a data structure consisting of nodes, each having at most two children.

    • Each node has a left and/or right child node

    • The left child node is smaller than the parent node, while the right child node is larger

    • Used for efficient searching and sorting algorithms

    • Examples include binary search trees and Huffman trees

  • Answered by AI
  • Q2. Was given a scenario and was asked to solve that with optimized approach
Round 3 - HR 

(1 Question)

  • Q1. Why do you want to join this company?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. If you don't know something, tell that directly rather than giving wrong answer.

Skills evaluated in this interview

Interview Questionnaire 

20 Questions

  • Q1. What is Difference between C,C++?
  • Ans. 

    C is a procedural programming language while C++ is an object-oriented programming language.

    • C is a low-level language while C++ is a high-level language.

    • C++ supports object-oriented programming concepts like classes, inheritance, and polymorphism.

    • C++ has better support for exception handling and templates.

    • C++ is more complex than C and requires more memory.

    • C++ is used for developing applications like video games, while...

  • Answered by AI
  • Q2. What is a class?
  • Ans. 

    A class is a blueprint for creating objects that have similar attributes and behaviors.

    • Classes are used in object-oriented programming.

    • They define the properties and methods that objects of that class will have.

    • Objects are instances of a class.

    • Classes can inherit properties and methods from other classes.

    • Examples of classes include 'Person', 'Car', and 'Animal'.

  • Answered by AI
  • Q3. What is an object?
  • Ans. 

    An object is a self-contained entity that contains data and behavior.

    • An object is an instance of a class.

    • It has attributes (data) and methods (behavior).

    • Objects can interact with each other through their methods.

    • Examples include a car object with attributes like color and model, and methods like start and stop.

    • Another example is a person object with attributes like name and age, and methods like walk and talk.

  • Answered by AI
  • Q4. What is static variable?
  • Ans. 

    A variable that is associated with a class rather than with instances of the class.

    • Static variables are declared using the static keyword.

    • They are initialized only once, at the start of the program execution.

    • They retain their value throughout the program's execution.

    • They can be accessed without creating an instance of the class.

    • Example: public static int count = 0;

  • Answered by AI
  • Q5. What is difference between Static and Global Vaiable?
  • Ans. 

    Static variables have local scope but retain their value between function calls, while global variables have global scope.

    • Static variables are declared inside a function and retain their value between function calls

    • Global variables are declared outside of any function and can be accessed from any part of the program

    • Static variables have local scope, while global variables have global scope

    • Static variables are initializ...

  • Answered by AI
  • Q6. What are pointers?
  • Ans. 

    Pointers are variables that store memory addresses of other variables.

    • Pointers allow for dynamic memory allocation and manipulation.

    • They are commonly used in programming languages like C and C++.

    • Example: int *ptr; // declares a pointer to an integer variable

    • Example: ptr = # // assigns the memory address of num to ptr

    • Example: *ptr = 5; // assigns the value 5 to the variable pointed to by ptr

  • Answered by AI
  • Q7. What are structures?
  • Ans. 

    Structures are arrangements of elements that form a framework or framework-like support.

    • Structures can be found in various fields such as engineering, architecture, and biology.

    • They can be made of different materials such as steel, wood, or bone.

    • Examples include bridges, buildings, and the skeletal system.

    • Structures can be designed to withstand different types of forces such as compression, tension, or bending.

  • Answered by AI
  • Q8. What is a stack and various operations on it?
  • Ans. 

    A stack is a data structure that follows the Last In First Out (LIFO) principle.

    • Push: adds an element to the top of the stack

    • Pop: removes the top element from the stack

    • Peek: returns the top element without removing it

    • IsEmpty: checks if the stack is empty

    • Size: returns the number of elements in the stack

  • Answered by AI
  • Q9. What are 3 steps for using function in c?
  • Ans. 

    Three steps for using functions in C.

    • Declare the function with its return type, name, and parameters.

    • Define the function by writing the code for it.

    • Call the function by using its name and passing arguments if necessary.

  • Answered by AI
  • Q10. What is limit for no of arguments passed to functions? if limit is 10 den how to pass more parameters? Ans:- either Array or Structure
  • Ans. 

    The limit for the number of arguments passed to functions is not fixed. Arrays or structures can be used to pass more parameters.

    • The limit for the number of arguments passed to functions is not fixed and depends on the programming language and system architecture.

    • In C programming language, there is no limit on the number of arguments that can be passed to a function.

    • In Java, the maximum number of arguments that can be ...

  • Answered by AI
  • Q11. What is union?
  • Ans. 

    A union is an organization formed by workers to protect their rights and interests in the workplace.

    • Unions negotiate with employers for better wages, benefits, and working conditions.

    • They also provide support and representation for workers in disputes with management.

    • Membership in a union is voluntary, but members pay dues to support the union's activities.

    • Unions can be industry-specific, such as the United Auto Worker...

  • Answered by AI
  • Q12. What is difference between if else and switch case statements?
  • Ans. 

    if else is used for simple conditions while switch case is used for multiple conditions.

    • if else is a sequential decision-making statement while switch case is a multi-branch decision-making statement

    • if else is used when there are only a few conditions to be checked while switch case is used when there are multiple conditions to be checked

    • if else can have multiple conditions in a single statement while switch case can o...

  • Answered by AI
  • Q13. What are member functions?
  • Ans. 

    Member functions are functions that are defined inside a class and can access the class's private and protected members.

    • Member functions are also known as methods.

    • They can be used to manipulate the data members of an object.

    • They can be overloaded, meaning multiple functions with the same name but different parameters can exist within a class.

    • They can be declared as const, meaning they do not modify the object's state.

    • E...

  • Answered by AI
  • Q14. Find the output:- a=5;b=4;c=++a+b--; find c?
  • Ans. 

    Find the output of c=++a+b-- where a=5 and b=4.

    • The value of a is incremented by 1 before the addition operation

    • The value of b is decremented by 1 after the addition operation

    • The final value of c is 10

    • The value of a becomes 6 and the value of b becomes 3

  • Answered by AI
  • Q15. Plant 10 plants in 5 rows such that each row has 4 plants
  • Ans. 

    10 plants can be planted in 5 rows with 4 plants in each row.

    • Divide the plants into groups of 4.

    • Arrange the groups in 5 rows.

    • Each row will have 4 plants.

  • Answered by AI
  • Q16. There is 2 pot one red and one blue. one pot contains tressure. Two statement are given 1. only one of the statement is correct. 2. Blue pot has the tressure. Find the tressure?
  • Q17. Exceptions handling in java?
  • Ans. 

    Exceptions handling is a mechanism to handle runtime errors in Java programs.

    • Exceptions are objects that are thrown at runtime when an error occurs

    • Java provides try-catch-finally blocks to handle exceptions

    • Checked exceptions must be handled or declared in the method signature

    • Unchecked exceptions can be handled or left unhandled

    • Custom exceptions can be created by extending the Exception class

  • Answered by AI
  • Q18. Run me through your resume
  • Ans. 

    I have experience in project management, data analysis, and consulting across various industries.

    • Managed multiple projects simultaneously, ensuring timely delivery and client satisfaction

    • Analyzed data to identify trends and provide insights for clients

    • Consulted with clients to develop and implement strategies for growth and efficiency

    • Worked with clients in industries such as healthcare, finance, and retail

    • Collaborated ...

  • Answered by AI
  • Q19. Mostly my nterview was project based. He asked me to explain me my project. My contribution in it
  • Q20. What are your 5 year plans
  • Ans. 

    To gain experience in consulting and develop skills in project management, team leadership, and client relations.

    • Gain experience in consulting

    • Develop skills in project management

    • Develop skills in team leadership

    • Develop skills in client relations

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Written Test consists of following sections:
Technical sections had questions from almost all the sections(C, C++, DBMS, DS, OS)
Quantitative aptitude’s questions were good.. All were almost of R. S. Aggarwal’s level.
Logical reasoning and verbal ability was good.. Some questions were little tough.
Tips: Try to be fast n practice Quantitative aptitude to increase speed..

Round: Technical Interview
Experience: Technical Interview was conducted on skype. I was able to answer most of the questions. And if i could not answer i tried to explain my approach using examples...It lasted for 50 mins..

Tips: Brush up basics knowledge of C,C++ and be confident of what you know. And try to explain your approach if you couldn't tell answer.

Round: HR Interview
Experience: This interview was also through skype. You can drive this Interview towards the direction you want... This interview also lasted for 50 mins... I explained him my project.
Tips: Just be cool.. He was just checking your confidence n spirit to complete the task given to you..

All the best!!!!

General Tips: Practice Quant regularly from Rs.Agrawal, solve questions on DBMS and C,C++ from India Bix.. Test was conducted by AMCAT so try to find if its questions are available on internet.
Skills: C,C++
College Name: NIT Raipur
Motivation: Its clients which are AUDI, Ferrari, Coca-cola,Unilever.
Funny Moments: To try to make me comfortable he asked me weather i like coke or pepsi. He asked why? i said bcoz i feel coke has little less soda content in it.:P Next when i told him my hobbies are watching sitcoms he asked which sitcoms have u watched. I started naming sitcoms he had to intreuppt me.. den asked which one u liked best n y i was telling him the reason then in between he asked me about my project n i thought it was about sitcom so i was answering him about sitcom rather than my project then after a big confusion i co

Skills evaluated in this interview

Birlasoft Interview FAQs

How many rounds are there in Birlasoft Senior Consultant interview?
Birlasoft interview process usually has 2-3 rounds. The most common rounds in the Birlasoft interview process are Technical, One-on-one Round and Resume Shortlist.
How to prepare for Birlasoft Senior Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Birlasoft. The most common topics and skills that interviewers at Birlasoft expect are Javascript, Consulting, SAP, Troubleshooting and Oracle.
What are the top questions asked in Birlasoft Senior Consultant interview?

Some of the top questions asked at the Birlasoft Senior Consultant interview -

  1. what is your project exp in SCM mod...read more
  2. Ale configurations in SAP PI...read more
  3. 1.About technology basic to moderate? 2.Situation based questions? Your intr...read more

Tell us how to improve this page.

Birlasoft Senior Consultant Interview Process

based on 6 interviews

1 Interview rounds

  • Technical Round
View more
Birlasoft Senior Consultant Salary
based on 851 salaries
₹5 L/yr - ₹20 L/yr
38% less than the average Senior Consultant Salary in India
View more details

Birlasoft Senior Consultant Reviews and Ratings

based on 87 reviews

3.8/5

Rating in categories

3.7

Skill development

3.9

Work-life balance

3.4

Salary

3.9

Job security

3.8

Company culture

3.2

Promotions

3.6

Work satisfaction

Explore 87 Reviews and Ratings
Sr Consultant

Pune

4-5 Yrs

₹ 5-21 LPA

Explore more jobs
Software Developer
1.5k salaries
unlock blur

₹2.5 L/yr - ₹11.2 L/yr

Senior Software Engineer
1.2k salaries
unlock blur

₹5.9 L/yr - ₹24 L/yr

Technical Specialist
1.2k salaries
unlock blur

₹8 L/yr - ₹30 L/yr

Technical Lead
1.1k salaries
unlock blur

₹9 L/yr - ₹36 L/yr

Software Engineer
1.1k salaries
unlock blur

₹2.8 L/yr - ₹11 L/yr

Explore more salaries
Compare Birlasoft with

Accenture

3.8
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare

Wipro

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview