Comcast India Engineering Center Data Analyst Interview Questions and Answers

Highly interactive and technical

1 hr test with focus on math and analytical thinking

It was very easy and out of 1000 students 300 students got shortlisted.

Q1. It was also easy and out of 300 students 30 got shortlisted.
Add your answer
Q2. What are oops? Explain 4 pillars
Ans. 
OOPs stands for Object-Oriented Programming. The 4 pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: Parent class 'Animal' and child class 'Dog' inheriting from 'Animal'.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables and public methods in...read more
Answered by AI
Add your answer
Q3. What is DBMS and SQL?
Ans. 
DBMS stands for Database Management System, which is a software system that manages databases. SQL is a language used to interact with databases.
• DBMS is a software system that allows users to define, create, maintain, and control access to databases.

• SQL (Structured Query Language) is a language used to communicate with a database. It is used to retrieve, update, and manage data in a database.

• Examples of popular DBMS in...read more
Answered by AI
Add your answer
Q4. What is MongoDB? Explain it.
Ans. 
MongoDB is a NoSQL database program that uses a document-oriented data model.
• NoSQL database program

• Document-oriented data model

• Uses JSON-like documents for data storage

• Supports dynamic schemas for flexible data structures
Answered by AI
Add your answer
Q5. Explain all hooks of React.
Ans. 
React hooks are functions that let you use state and other React features without writing a class.
• Hooks are functions that let you use state and other React features in functional components

• useState() - allows functional components to have local state

• useEffect() - allows functional components to perform side effects

• useContext() - allows functional components to access context

• useReducer() - an alternative to useState() ...read more
Answered by AI
Add your answer

Q1. Database related Query proformance and DBA related questions.
Add your answer

Q1. Python, pandas and Power BI
Add your answer

Q1. Salary discussion
Add your answer

Normal level questions

Q1. Puzzles were asked and resume based questions only
Add your answer

Case study questions regarding clothing brands etc were asked

Q1. What are your roles and responsibilities
Ans. 
As a Data Analyst, my roles and responsibilities include analyzing data, creating reports, identifying trends, and providing insights to support decision-making.
• Analyzing large datasets to extract meaningful insights

• Creating reports and visualizations to communicate findings

• Identifying trends and patterns in data

• Collaborating with stakeholders to understand business needs

• Providing recommendations based on data analysis

• ...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in next 4 years.
Ans. 
In the next 4 years, I see myself advancing my skills in data analysis, taking on more responsibilities, and potentially moving into a leadership role.
• Continuing to improve my data analysis skills through training and hands-on experience

• Taking on more complex projects and responsibilities within the data analysis field

• Possibly transitioning into a leadership role where I can mentor and guide junior analysts

• Exploring op...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a data analyst with a background in statistics and programming, passionate about uncovering insights from data.
• Background in statistics and programming

• Experience in data analysis and visualization tools like Python, R, and Tableau

• Strong problem-solving skills

• Ability to communicate complex data findings to non-technical stakeholders
Answered by AI
Add your answer
Q2. How mamy year of experience do you have?
Ans. 
I have 5 years of experience working as a Data Analyst in various industries.
• 5 years of experience as a Data Analyst

• Worked in multiple industries such as finance, healthcare, and technology

• Proficient in data analysis tools and techniques

• Experience in handling large datasets and generating insights

• Strong problem-solving and communication skills
Answered by AI
Add your answer

Contains math aptitide and basic tableau questions

Sql coding test with joins sub queries and stored procedures