Searce Logistics Analytics Senior Analyst Interview Questions and Answers

Usual questions about self and experience

Q1. Windows and server related questions
Add your answer

Q1. The Final HR round where everything finalized
Add your answer

Q1. Highlight the odd cells in excel
Ans. 
Use conditional formatting to highlight odd cells in Excel
• Select the range of cells you want to highlight

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose 'New Rule' and select 'Use a formula to determine which cells to format'

• Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

• Choose the formatting style you want for the odd cells
Answered by AI
Add your answer
Q2. What are Joins in SQL, explain different joins and their outputs
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• 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 the left table

• FU...read more
Answered by AI
Add your answer
Q3. Query to give running sum of salary
Ans. 
Use window function to calculate running sum of salary in SQL
• Use window function like SUM() with OVER() clause

• Partition the data by employee ID if needed

• Order the data by date or any other relevant column
Answered by AI
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

Its a sectional round. It has 4 sections. Quants, Logical, pseudo code, Reasoning, Gaming

Q1. Aptitude question solving
Add your answer
Q2. Resume related questions
Add your answer

Q1. About your past experience
Add your answer
Q2. Reason for leaving the last job
Add your answer

Q1. Process related and journal entries for the questions previously prepared kept by the interviewer.
Add your answer

Very simple and can clear easily

Q1. I was looking job as a fresher and the interview questions were mostly on academic project, team handling and some personal questions.
Add your answer
Q2. What is your role in project?
Ans. 
As a Quality Analyst, my role in the project is to ensure that the software meets the required quality standards.
• Conducting quality assurance activities to identify and resolve defects

• Creating and executing test cases to validate software functionality

• Collaborating with developers and stakeholders to understand project requirements

• Performing regression testing to ensure previous functionality is not affected

• Documenting...read more
Answered by AI
Add your answer
Q3. Are there any disputes while working in team and how you handled it?
Ans. 
Yes
• Yes, there have been disputes while working in a team.

• I handled disputes by actively listening to all parties involved and understanding their perspectives.

• I encouraged open communication and facilitated discussions to find common ground and resolve conflicts.

• I promoted a collaborative environment where everyone's opinions were valued and respected.

• For example, in a project where there was a disagreement about the p...read more
Answered by AI
Add your answer