Consolidated Contractors Data Analyst Interview Questions and Answers

Q1. Data Sceince related questions
Add your answer

The test will be conducted in a interview process

Group discussion is a communicate in a people

Q1. Hr face to face commutation
Add your answer
Q2. Self introduction and
Add your answer

Q1. It is the individual interview
Add your answer
Q2. Personal questions only
Add your answer

Financial condition of India

Q1. Analysis and company audit.
Add your answer

30 questions and time was approx. 45 min to 60 min

There were some basic as well as some high level questions

Q1. What are joins and its types?
Ans. 
Joins 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.

• FULL ...read more
Answered by AI
Add your answer
Q2. What are aggregate functions?
Ans. 
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
• Aggregate functions are used to perform operations on a group of rows and return a single result.

• Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• For example, SUM function calculates the total of a column, AVG calculates the average, COUNT counts the number of rows, MIN finds the minimu
Answered by AI
Add your answer

Q1. Coding questions in python eda part
Add your answer

Q1. Where do u see in next 5 years
Add your answer

Q1. In Agile development what is the DOR
Ans. 
DOR stands for Definition of Ready in Agile development.
• DOR is a checklist of criteria that a user story must meet before it can be considered ready for development.

• It ensures that the team has a shared understanding of the requirements and that the story is feasible and testable.

• DOR helps to prevent scope creep and ensures that the team is working on the most valuable features.

• Examples of DOR criteria include clear ac...read more
Answered by AI
Add your answer

Q1. What is Data sharding
Ans. 
Data sharding is the process of splitting a database into smaller, more manageable parts called shards.
• Data sharding helps distribute data across multiple servers to improve performance and scalability.

• Each shard contains a subset of the data, allowing for parallel processing and faster query times.

• Common sharding techniques include range-based sharding, hash-based sharding, and key-based sharding.

• Examples of data shar...read more
Answered by AI
Add your answer
Q2. What is clustering
Ans. 
Clustering is a technique used in data analysis to group similar data points together based on certain criteria.
• Clustering is an unsupervised machine learning technique.

• It is used to discover hidden patterns or groupings in data.

• Common clustering algorithms include K-means, hierarchical clustering, and DBSCAN.

• Example: clustering customers based on their purchasing behavior to identify different market segments.
Answered by AI
Add your answer