Merkle Business Analyst Interview Questions and Answers

It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.

Q1. They give you some questions and you have to write sql queries for them
Add your answer

Q1. You are given case study and come sql questions based on that
Add your answer

Q1. What is sdlc and uml
Ans. 
SDLC stands for Software Development Life Cycle, which is a process used by software development teams to design, develop, and test high-quality software. UML stands for Unified Modeling Language, which is a standardized modeling language used to visually represent software systems.
• SDLC is a framework that defines the tasks performed at each phase of software development, including planning, analysis, design, implement...read more
Answered by AI
Add your answer
Q2. What is waterfall and agile
Ans. 
Waterfall and Agile are two different project management methodologies used in software development.
• Waterfall is a linear and sequential approach where each phase must be completed before moving on to the next.

• Agile is an iterative and flexible approach that focuses on delivering small, incremental releases and adapting to changes quickly.

• Waterfall is more suitable for projects with well-defined requirements, while Agi...read more
Answered by AI
Add your answer

Q1. SQL QUERY QUESTIONS ON JOINS
Add your answer

Q1. Excel basic formulas like lookup
Add your answer

Q1. About Yourself, resume grilling
Add your answer

Sql test like joins and etc

Q1. Why do you want to join the company
Add your answer

Logical reasoning, aptitude

Q1. Projects of last companies
Ans. 
I have worked on various projects in my previous companies, ranging from system implementations to process improvements.
• Led a team in implementing a new CRM system to improve customer relationship management

• Analyzed data to identify bottlenecks in the supply chain and proposed solutions for optimization

• Collaborated with cross-functional teams to streamline communication processes and increase efficiency
Answered by AI
Add your answer
Q2. Financial analysis
Add your answer
Q3. MS Excel main fuctions
Add your answer

Q1. Find 3rd highest salary using SQL
Ans. 
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
• Use SELECT statement to retrieve salary column

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
Answered by AI
Add your answer
Q2. Queries on self join
Add your answer

Q1. Questions on Power B, DAX etc.,
Add your answer

Q1. Common BA Basic questions?
Add your answer
Q2. Previous project details?
Add your answer
Q3. Domain specific questions?
Add your answer
Q4. Cross questioning on requirement?
Add your answer
Q5. The puzzle was asked by the interviewer?
Add your answer

Q1. SQL queries with joins. How to do requirement gathering?
Ans. 
Requirement gathering involves identifying and documenting the needs and expectations of stakeholders.
• Identify stakeholders and their roles

• Conduct interviews and surveys

• Use techniques such as brainstorming and mind mapping

• Document requirements in a clear and concise manner
Answered by AI
Add your answer

Your past experience related questions.

Q1. Salary discussion and other HR related points.
Add your answer