CEEW Research Analyst Interview Questions and Answers for Experienced

Q1. Tell me about yourself
Add your answer

Basic excel, Reasoning, English Grammar

Q1. Breif about Yourself.
Ans. Why do you want to work at night shift.
Answered by Syed Mohammed Hanafia
Add your answer

Related to codeing
Mathematical question

Q1. Introduce yourself
Ans. 
I am a dedicated Research Analyst with a strong background in data analysis and a passion for uncovering insights to drive decision-making.
• Educational Background: I hold a Master's degree in Data Science from XYZ University, where I focused on statistical analysis and machine learning.

• Professional Experience: I have over 3 years of experience working at ABC Corp, where I analyzed market trends to support strategic plan...read more
Answered by AI
Add your answer
Q2. Why do you want to join us
Ans. 
I admire your commitment to innovation and data-driven decision-making, which aligns perfectly with my career aspirations and skills.
• Your company's reputation for cutting-edge research in analytics excites me, as I want to contribute to impactful projects.

• I am impressed by your collaborative culture, which fosters learning and growth; I thrive in environments where teamwork is valued.

• The opportunity to work with advanc...read more
Answered by AI
Add your answer
Q3. Where do u see yourself in next 5 year
Ans. 
In five years, I envision myself as a seasoned Research Analyst, leading impactful projects and mentoring junior analysts.
• I aim to deepen my expertise in data analysis techniques, such as machine learning and predictive modeling.

• I plan to take on leadership roles in projects, guiding teams to deliver actionable insights for strategic decisions.

• I aspire to publish research findings in reputable journals, contributing to...read more
Answered by AI
Add your answer
Q4. What are your strength and weaknesses
Ans. 
I excel in analytical thinking and attention to detail, but I sometimes struggle with time management under tight deadlines.
• Strength: Strong analytical skills - I can dissect complex data sets to identify trends, as demonstrated in my previous role analyzing market research.

• Strength: Attention to detail - I ensure accuracy in reports, which helped reduce errors by 20% in my last project.

• Weakness: Time management - I oc...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Started with project description, deep dive into project
Questions about ML, Statistics
Coding questions for Python, SQL

Q1. 
Stream of Characters Problem Statement
You are provided with a list, DICTIONARY[], which contains a collection of words, along with a stream of characters (queries). The task is to implement a class Chara...read more
Ans. 
Implement a class to check if a string formed by the last queried characters exists in a dictionary of words.
• Initialize the class with the dictionary of words.

• Implement a method to check if the string formed by the last queried characters exists in the dictionary.

• Use appropriate data structures to efficiently solve the problem.

• Ensure the class handles multiple test cases and character queries.

• Example: DICTIONARY[] = ['...read more
Answered by AI
Add your answer
Q2. How do you retrieve the second highest salary from a SQL database?
Ans. 
Use a subquery to retrieve the second highest salary from a SQL database.
• Use a subquery to select the maximum salary from the table.

• Then use another subquery to select the maximum salary that is less than the maximum salary found in the first step.

• Combine both subqueries to retrieve the second highest salary.
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Projects
Machine Learning

Q1. Aptitude Questions
Questions about Statistics
Ans. 
Answering aptitude questions related to statistics
• Statistics is the study of collecting, analyzing, interpreting, presenting, and organizing data.

• Key concepts include mean, median, mode, standard deviation, and probability.

• Examples of statistical questions include 'What is the average income of a population?' and 'What is the likelihood of an event occurring?'
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Behavioral Round
Questions asked about Amazon Leadership Principles

Round duration - 60 minutes
Round difficulty - Easy

Medium Python questions
Medium SQL questions

Q1. Ninja and Mathematics
Ninja is a genius in mathematics. He got an interview call from MIT. During the interview, the professor asked Ninja a challenging question.
Given two integers 'N1' and 'N...read more
Ans. 
Calculate the fraction when one integer is divided by another, with repeating decimal parts enclosed in parentheses.
• Divide the first integer by the second integer to get the fraction

• Identify if the fractional part is repeating and enclose it in parentheses

• Return the fraction for each test case
Answered by AI
Add your answer
Q2. How can you find the top 2 salaries for each department in SQL?
Ans. 
Use SQL query with window functions to find top 2 salaries for each department.
• Use PARTITION BY clause to partition the data by department.

• Use ORDER BY clause to order the salaries in descending order.

• Use ROW_NUMBER() function to assign a rank to each row within the partition.

• Filter the results to only include rows with rank 1 and 2.
Answered by AI
View 1 more answer

Medium to Hard 4 DSA questions