AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Comfort
Click
Compare
Filter interviews by
Comfort Click Data Manager Interview Questions and Answers
Comfort Click Data Manager Interview Experiences
1 interview found
Anonymous
I appeared for an interview in Aug 2024.
(2 Questions)
- Q1. What's the difference between CTE and Subquery
- Ans.
CTE is a temporary result set defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. Subquery is a query nested within another query.
CTE stands for Common Table Expression and is defined using the WITH keyword.
CTEs can be referenced multiple times in a query.
Subquery is enclosed within parentheses and can only be referenced once in a query.
Subqueries can be correlated o...
- Q2. Use window functions to query the following data
- Ans.
Using window functions to query data
Use functions like ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() to perform calculations within a window of data
Window functions allow you to perform aggregate functions on a specific subset of rows within a result set
You can use window functions to calculate running totals, moving averages, and other analytical functions
Interview Preparation Tips
- SQL
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed in Sep 2024. There was 1 interview round.
(3 Questions)
- Q1. How to calculate requirement of Banana is a city like Mumbai
- Ans.
The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.
Calculate the population of Mumbai
Estimate the average consumption of bananas per person
Consider factors like tourism and events that may increase demand
Take into account the availability of bananas from local markets and imports
- Q2. How to know , difference between a good or bad retailer
- Ans.
A good retailer focuses on customer satisfaction, product quality, and efficient operations.
Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.
Good retailers offer high-quality products that meet customer expectations.
Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.
Bad retailers...
- Q3. Simple SQL questions
Interview Preparation Tips
- Guess Estimate
- SQL
Selected
I applied via LinkedIn and was interviewed before Jul 2023. There were 2 interview rounds.
Problem solving approach check
(2 Questions)
- Q1. Case study and problem solving
- Q2. Root cause Analysis
Selected
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Advanced formulas of Excel
- Ans.
Advanced Excel formulas are complex functions used for data analysis and manipulation.
Advanced formulas in Excel include VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and IFERROR.
These formulas are used for tasks like data lookup, conditional calculations, and summarizing data.
For example, VLOOKUP is used to search for a value in a table and return a corresponding value from another column.
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Oct 2023. There were 4 interview rounds.
Nirmal question asked in exam.
Basic topic of GD, sinariob base topic
(5 Questions)
- Q1. Interview round Interview 2
- Q2. Sineario base question, + sales question
- Q3. Sales questions
- Q4. Marketing question
- Q5. Definition of role and your understanding
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before Jan 2024. There was 1 interview round.
(3 Questions)
- Q1. PAST EXPERIENCE
- Ans.
I have diverse experience in consulting, project management, and data analysis across various industries.
Led a team of consultants in a project for a Fortune 500 company, improving operational efficiency by 20%.
Conducted market research for a startup, helping them identify key customer segments and refine their business model.
Implemented a data analytics solution for a healthcare provider, resulting in a 15% reduction ...
- Q2. SITUATION HANDLING
- Q3. TRAVEL WILLINGNESS
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Jun 2021. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Realted to my previous job
Interview Preparation Tips
Sql questions database modelling
I applied via LinkedIn
Hackerrank statistics and dsa
Selected
I applied via Approached by Company and was interviewed in May 2024. There were 3 interview rounds.
(1 Question)
- Q1. Project discussion, spark, python, sql, big data discussion
(1 Question)
- Q1. Project discussion and company profile alignment discussion
Data Modelling question and project discussion
Comfort Click Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
|
PPC Specialist
7
salaries
|  ₹7 L/yr - ₹11 L/yr |
|
Graphic Designer
6
salaries
| ₹3 L/yr - ₹5 L/yr |
|
Project Manager
5
salaries
| ₹13.7 L/yr - ₹24 L/yr |
|
Senior Graphic Designer
5
salaries
| ₹4.7 L/yr - ₹8.5 L/yr |
|
Procurement Specialist
5
salaries
| ₹4.5 L/yr - ₹8 L/yr |
InsanelyGood
Mogli labs
Vegrow
Shine
- Home >
- Interviews >
- Comfort Click Interview Questions
