Colgate Global Business Services Business Analyst Interview Questions and Answers

The aptitude round was easy consisting of three sections

The second aptitude test was conducted by the HR of the company.

Q1. Behaviour based questions
Add your answer
Q2. Situation based questions
Add your answer
Q3. Aptitude based questions
Add your answer

24 mcqs were given and all of them were of aptitude and sql based

Q1. Interview went for 1hr based on probability and Permutations, also some sql based questions along with some puzzles
Add your answer
Q2. Gave some python pseudo codes
Add your answer

Q1. Case study about entering into a market
Add your answer
Q2. Asked to write a python code for given question
Add your answer

Q1. SQL and domain - Use case scenarios and real time examples
Ans. 
SQL is used in various domains for data analysis and reporting. Use cases include financial analysis, inventory management, and customer relationship management.
• Financial analysis - using SQL to analyze revenue, expenses, and profitability

• Inventory management - tracking stock levels, orders, and shipments

• Customer relationship management - analyzing customer data, preferences, and interactions
Answered by AI
Add your answer
Q2. SQL questions and domain related questions.
Add your answer

3 sections of test. First 2 sections was english and 3rd section was technical related to job.

Q1. Which company and its details. What was your job role?
Add your answer
Q2. What is SDLC? Asking to do role play on 1 topic asked by them.
Add your answer

Q1. What are types of Documents used in Business Analysis?
Ans. 
Various types of documents are used in business analysis to document requirements, processes, and project deliverables.
• Business Requirements Document (BRD) - outlines the high-level business objectives and requirements

• Functional Requirements Document (FRD) - details the specific functional requirements of a system or application

• Use Case Document - describes the interactions between users and a system

• Process Flow Diagra...read more
Answered by AI
Add your answer

Q1. Agile Process and Jira and Structured Document
Add your answer

Q1. More about Analytics and it's processing of data
Add your answer

Q1. What is account making and account search
Ans. 
Account making is the process of creating a new account, while account search is the process of finding existing accounts.
• Account making involves gathering necessary information and creating a new account for a user or entity.

• Account search involves searching for existing accounts based on specific criteria or parameters.

• Account making may include tasks such as collecting personal information, setting up login credenti...read more
Answered by AI
Add your answer