Tide - Business Management Platform Financial Crime Analyst Interview Questions and Answers

I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.

Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.

Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.

Q1. Current CTC, Preferred location
Ans. 
Current CTC and preferred location are confidential information.
• Current CTC and preferred location are personal and confidential details.

• It is common practice not to disclose current CTC during interviews.

• Preferred location may vary based on individual circumstances and preferences.
Answered by AI
Add your answer

Q1. About yourself, projects worked, sql questions, Python questions
Add your answer

Q1. How would you copy a large dataset
Ans. 
Use a data migration tool to copy the dataset efficiently.
• Utilize a data migration tool like AWS Data Pipeline, Apache Nifi, or Talend to copy the dataset.

• Break down the dataset into smaller chunks to avoid overwhelming the system.

• Ensure proper data validation and error handling during the copying process.

• Consider using parallel processing to speed up the copying process.

• Monitor the progress of the dataset copying to t...read more
Answered by AI
Add your answer
Q2. Do you think data analysis job is overrated?
Ans. 
No, data analysis job is not overrated as it plays a crucial role in decision-making and problem-solving.
• Data analysis helps in identifying trends and patterns in data

• It provides valuable insights for businesses to make informed decisions

• Data analysis is essential for optimizing processes and improving efficiency

• It can uncover hidden opportunities and potential risks

• Many industries rely on data analysis for strategic p...read more
Answered by AI
Add your answer

Q1. Questions on probability and puzzles
Add your answer

Q1. Tell me about yourself?
Ans. 
Experienced business analyst with a background in data analysis and process improvement.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Skilled in data analysis tools such as Excel, SQL, and Tableau

• Strong communication skills to collaborate with stakeholders and present findings

• Certified in Business Analysis Professional (CBAP)

• Previously led a project to streamline invent...read more
Answered by AI
Add your answer
Q2. Previous experience?
Ans. 
I have 5 years of experience as a Business Analyst in the finance industry.
• Worked on various projects to analyze financial data and provide insights for decision-making

• Collaborated with cross-functional teams to gather requirements and create business solutions

• Utilized data visualization tools such as Tableau to present findings to stakeholders
Answered by AI
Add your answer

Q1. Basic capital market question
Add your answer

Q1. Questions asked mostly related to SQL only.
Add your answer

Q1. Mix of questions are expected depending on interviewer i guess, -> few apititude questions on probability, PnC, 6 * 6 Grid Square questions -> Business case study questions on [how will you evaulate few m...read more
Add your answer

Q1. This is probably the elimination round. Majorly focus on 2 portions 1. project discussions mentioned in your resume [cross questioning will be here alot] 2. Case study dicussion
Add your answer