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

Clear (1)

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

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed 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 & 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

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 was interviewed 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 Resume 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 Technical Consultant

 (2)

 Senior Lead 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 Resume 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 was interviewed 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 Company Website and was interviewed in Sep 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Specific to SAP HANA Architecture and troubleshooting

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics should be clear and should have broader view with respect to scenario base questions.

I was interviewed before Jun 2016.

Interview Questionnaire 

3 Questions

  • Q1. I was given a case study of a business scenario and was asked to implement it technically as a functional consultant using SAP software
  • Q2. Salary negotiation based on the experience
  • Q3. Case study of a business scenario will be given to you based on the job profile

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resume shortlisted based on the skill set what the Infosys was looking for and the profile I was offering.
Tips: Resume should be as per the requirement of the job profile you are applying for.

Round: Technical Interview
Experience: Panel of Project manager took my interview based on the requirement of the vacancy and skill set I have mentioned in my resume.
Tips: Resume should not be extravagant, it should be very precise

Round: HR Interview
Experience: Always do a pre-check of the organization hierarchy as it helps in negotiating the position.

Round: Case Study Interview
Experience: Try to give precise answer.

Skills: Entrepreneurial Skills

I was interviewed in Jun 2016.

Interview Questionnaire 

2 Questions

  • Q1. General questions related to Windows administration
  • Q2. Questions about lack of past with experience.

Interview Preparation Tips

Round: Technical Interview
Experience: Some questions regarding active directory and file sharing
Tips: Keep it real and answer what you know. Donot argue unless interviewer demands discussion.

Round: HR Interview
Experience: Some questions regarding active directory and file sharing
Tips: Keep it real and answer what you know. Donot argue unless interviewer demands discussion.

Round: HR Interview
Experience: I didn't have work experience of a company.
Tips: Will if you have reached hr stage and don't have certain document tell the truth. And explain why you don't have it. If you can arrange the doc, great. If you can't clearly state the same. And tell about the references you can share.

Skills: Technical Analysis
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

REVIEWS

Aequs

3.6

(566 reviews)

REVIEWS

ABB

4.1

(2.7k reviews)

JOBS

Systechcorp

255 jobs

JOBS

Amgen

490 jobs

JOBS

Browse jobs

Discover jobs you love

JOBS

Bank of America

No Jobs

LIST OF COMPANIES

Ncr Eduservices

Locations

JOBS

Bank of America

No Jobs

INTERVIEWS

Birlasoft

100 top interview questions

INTERVIEWS

Bank of America

No Interviews

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 852 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 84 reviews

3.8/5

Rating in categories

3.7

Skill development

4.0

Work-life balance

3.4

Salary

3.9

Job security

3.8

Company culture

3.2

Promotions

3.6

Work satisfaction

Explore 84 Reviews and Ratings
Sr Consultant

Pune

4-5 Yrs

₹ 5-21 LPA

Explore more jobs
Software Developer
1.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
1.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Specialist
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
1.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
1.1k salaries
unlock blur

₹0 L/yr - ₹0 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