Upload Button Icon Add office photos

Filter interviews by

BAANS Consulting Services Interview Questions and Answers

Updated 13 May 2023

BAANS Consulting Services Interview Experiences

Popular Designations

2 interviews found

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Group by close? Procedure ?
  • Q2. What is procedure in mysql
  • Ans. 

    A procedure in MySQL is a set of SQL statements that perform a specific task and can be reused multiple times.

    • Procedures are stored in the database and can be called from other SQL statements or programs.

    • They can have input and output parameters, and can return result sets.

    • Procedures can be created using the CREATE PROCEDURE statement.

    • They are useful for encapsulating complex logic and improving performance.

    • Example: CR...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare MySQL database very well and in Java prepare pattern questions

Skills evaluated in this interview

Java Developer Interview Questions asked at other Companies

Q1. Sort 0 1You have been given an integer array/list(ARR) of size N that contains only integers, 0 and 1. Write a function to sort this array/list. Think of a solution which scans the array/list only once and don't require use of an extra arra... read more
View answer (4)

SQL Developer Interview Questions & Answers

user image Deepak Verma

posted on 13 May 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Coding Test 

Logic building through some problems

Round 3 - Technical 

(1 Question)

  • Q1. SQL queries are asked by interviewer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for sql

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
View answer (4)

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Campus Placement and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Two coding questions related to matrices and heaps.

Round 2 - Technical 

(1 Question)

  • Q1. Python and SQL coding
Round 3 - Technical 

(1 Question)

  • Q1. Same questions like tech 1
Round 4 - HR 

(2 Questions)

  • Q1. Self intro , why tiger
  • Q2. Relocation

Interview Preparation Tips

Topics to prepare for Tiger Analytics Data Analyst interview:
  • Python
  • SQL
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
-
Result
-
Round 1 - One-on-one 

(6 Questions)

  • Q1. What are the aml and kyc requirements?
  • Ans. 

    AML and KYC requirements are regulations that financial institutions must follow to prevent money laundering and verify the identity of their customers.

    • AML (Anti-Money Laundering) requirements involve monitoring transactions, reporting suspicious activities, and conducting customer due diligence.

    • KYC (Know Your Customer) requirements involve verifying the identity of customers, assessing their risk level, and maintainin...

  • Answered by AI
  • Q2. Why should we hire you, briefly describe a scenario where you would showcase a different skill or talent compared with your fellow employees?
  • Ans. 

    I have a strong attention to detail and analytical skills that set me apart from my colleagues.

    • I have a proven track record of accurately identifying and resolving discrepancies in KYC documentation.

    • I excel at conducting thorough research and analysis to ensure compliance with regulations.

    • My ability to effectively communicate complex information to stakeholders sets me apart in team collaborations.

  • Answered by AI
  • Q3. Strength and weakness?
  • Ans. 

    Strength: attention to detail, Weakness: perfectionism

    • Strength: Ability to meticulously review documents and identify discrepancies

    • Strength: Strong analytical skills to detect potential risks or fraudulent activities

    • Weakness: Striving for perfection may lead to spending too much time on a task

    • Weakness: Difficulty in delegating tasks due to desire for everything to be done perfectly

  • Answered by AI
  • Q4. Project and achievements?
  • Ans. 

    Implemented a new KYC process resulting in 30% reduction in onboarding time and 20% decrease in errors.

    • Led a team to revamp KYC procedures and systems

    • Introduced automation tools to streamline verification process

    • Trained staff on updated KYC regulations and best practices

  • Answered by AI
  • Q5. Are you a team player? What do you do when you don’t get along with certain colleagues? How do you manage conflict resolution?
  • Ans. 

    Yes, I am a team player. I believe in open communication and collaboration. When conflicts arise, I address them directly and seek resolution.

    • I believe in open communication and collaboration within the team.

    • I address conflicts directly and seek resolution through constructive conversations.

    • I focus on finding common ground and working towards a solution that benefits the team as a whole.

  • Answered by AI
  • Q6. Provide a situation where you might have failed previously? What has that experience taught you?
  • Ans. 

    I failed to meet a deadline due to poor time management.

    • Underestimated the time needed for a project

    • Did not prioritize tasks effectively

    • Learned to create a detailed schedule and set realistic deadlines

  • Answered by AI
Round 2 - Aptitude Test 

General English grammar knowledge and some calculations

Round 3 - HR 

(6 Questions)

  • Q1. CTC and expected salary details?
  • Q2. No you cannot negotiate and end up taking what they give you!
  • Q3. No relocation time, do it during weekends
  • Q4. No target compensation or other benefits
  • Q5. If ur employed through agency or consultancy you will be always a contingent and treated less than permanent employees
  • Q6. 12 hours a day, 6 days a week, no social or life balance

Interview Preparation Tips

Interview preparation tips for other job seekers - The experience is good overall 120 candidates only 2 of us got selected but the politics is bad
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Approached by Company and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

I have given 4 rounds of WNS and was selected. They congratulated me for being selected and then asked me the documents. But later HR and Interviewer both stopped picking my call and then told me after 15-20 days we are putting you on hold and not proceeding with your application

Round 2 - Technical 

(1 Question)

  • Q1. Why you are taking less salary
Round 3 - One-on-one 

(2 Questions)

  • Q1. Why are you leaving your current job
  • Q2. NA
Round 4 - HR 

(1 Question)

  • Q1. Why are you not satisfied by your current job
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via Walk-in and was interviewed in Nov 2024. There were 4 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Walk me through your resume. About insurance process what is policy life cycle.
  • Q2. Tell me about your previous role.
  • Ans. 

    I was responsible for analyzing and improving processes to increase efficiency and productivity.

    • Led process improvement initiatives to streamline operations

    • Identified bottlenecks and implemented solutions to optimize workflows

    • Collaborated with cross-functional teams to gather data and feedback

    • Utilized data analysis tools to track performance metrics

    • Developed and implemented process documentation and training materials

  • Answered by AI
Round 2 - Aptitude Test 

Yet to complete the test

Round 3 - One-on-one 

(2 Questions)

  • Q1. Asked about Gallagher.
  • Q2. What do you know about Gallagher.
  • Ans. 

    Gallagher is a global insurance brokerage, risk management, and consulting firm.

    • Founded in 1927 by Arthur J. Gallagher

    • Headquartered in Rolling Meadows, Illinois

    • Provides insurance, risk management, and consulting services globally

    • Offers services in areas such as commercial insurance, employee benefits, and personal insurance

    • Has a strong focus on client relationships and personalized service

  • Answered by AI
Round 4 - One-on-one 

(2 Questions)

  • Q1. Situation based questions were asked.
  • Q2. How would you built the trust with the stakeholders
  • Ans. 

    Building trust with stakeholders involves open communication, transparency, and delivering on commitments.

    • Establish open lines of communication with stakeholders to address concerns and provide updates

    • Be transparent about project progress, challenges, and decisions

    • Deliver on commitments and follow through on promises to build credibility

    • Seek feedback from stakeholders and incorporate their input into decision-making pr...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Bid process Bid calculation bid submission
  • Q2. RFP process flow . Project management goverment project handling process
  • Q3. Financial bid submission and PPT preparation knowledge
Round 2 - Technical 

(2 Questions)

  • Q1. Bid submission and RFP submition financial bid proposal
  • Q2. Bid submission and RFP submission financial bid proposal PPT
Round 3 - Case Study 

RFP Preparation bid submission financial

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

1 good coding question and 33 mcqs

Round 2 - Technical 

(2 Questions)

  • Q1. Easy questions are asked
  • Q2. Like create a database of the collages composes of students and professors
  • Ans. 

    Create a database to store information about colleges, students, and professors.

    • Create tables for colleges, students, and professors

    • Include columns for relevant information such as name, ID, courses, etc.

    • Establish relationships between the tables using foreign keys

    • Use SQL queries to insert, update, and retrieve data

    • Consider normalization to avoid data redundancy

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Some hr questions
  • Q2. Project discussions
Round 4 - HR 

(1 Question)

  • Q1. Hr questions about family
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. How does Django apply migrations to the database?
  • Q2. What is hoisting in javascript?
Round 2 - Assignment 

Create a full stack application in 3 days.

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

I applied via Referral and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. In Angular input and output parameters.
  • Ans. 

    In Angular, input parameters are used to pass data into a component, while output parameters are used to emit events from a component.

    • Input parameters are defined using the @Input decorator in Angular.

    • Output parameters are defined using the @Output decorator in Angular.

    • Input parameters allow parent components to pass data into child components.

    • Output parameters allow child components to emit events to parent components...

  • Answered by AI
  • Q2. Write inner join query using two table
  • Ans. 

    Inner join query is used to retrieve records that have matching values in both tables.

    • Use SELECT statement to specify the columns you want to retrieve

    • Use INNER JOIN keyword to combine the tables based on a related column

    • Specify the ON clause to define the relationship between the tables

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Fibonacci series code
  • Q2. Sql query related question
Round 3 - HR 

(2 Questions)

  • Q1. Package discussion expectation and they offer
  • Q2. Joining date, and the policies of company

Skills evaluated in this interview

BAANS Consulting Services Interview FAQs

How many rounds are there in BAANS Consulting Services interview?
BAANS Consulting Services interview process usually has 2-3 rounds. The most common rounds in the BAANS Consulting Services interview process are Resume Shortlist, One-on-one Round and Coding Test.
What are the top questions asked in BAANS Consulting Services interview?

Some of the top questions asked at the BAANS Consulting Services interview -

  1. What is procedure in my...read more
  2. SQL queries are asked by intervie...read more
  3. Group by close? Procedur...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.2k Interviews
Accenture Interview Questions
3.9
 • 8k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Deloitte Interview Questions
3.8
 • 2.8k Interviews
IBM Interview Questions
4.1
 • 2.4k Interviews
View all

BAANS Consulting Services Reviews and Ratings

based on 20 reviews

3.1/5

Rating in categories

3.5

Skill development

2.9

Work-Life balance

2.7

Salary & Benefits

3.0

Job Security

2.8

Company culture

2.6

Promotions/Appraisal

2.8

Work Satisfaction

Explore 20 Reviews and Ratings
Software Developer
21 salaries
unlock blur

₹2 L/yr - ₹3.4 L/yr

Explore more salaries
Compare BAANS Consulting Services with

Infosys Consulting

3.4
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

Accenture

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview