AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clootrack Software Labs Senior Data Analyst Interview Questions and Answers
Clootrack Software Labs Senior Data Analyst Interview Experiences
2 interviews found
Anonymous
Selected
(3 Questions)
- Q1. Short question about tableau calculated fields
- Q2. Qts about SQL basics
- Q3. Basic python qts
Was asked to send 5 insights from Newyorker Hotel Sample data
(3 Questions)
- Q1. Salary expections
- Q2. Ready to relocate
- Q3. Notice period from old company
Aptitude test mental assessment
(1 Question)
- Q1. Project discussion
(1 Question)
- Q1. Project discussion
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Nov 2023. There were 3 interview rounds.
Basic Aptitude (prob, )
(1 Question)
- Q1. Basic sql and exel
(1 Question)
- Q1. Tell me about your self
Should know about software and hardware product lifecycle
(1 Question)
- Q1. Product Lifecycle knowledge
Interview Preparation Tips
2 ( 1 medium + 1 hard ) coding questions , 2 ( 1 medium + 1 easy ) sql questions, 10 MCQS( os, cn, dbms, aptitude ).
(1 Question)
- Q1. 1 easy coding and design problem on how would you design a web app like book my show.
Interview Preparation Tips
Praveen Kumar
Usual Leet code problems
System Design Questions
System Design Questions
Selected
I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.
(2 Questions)
- Q1. Education Details
- Q2. Skills, Strength
CRUD Application using Angular
(1 Question)
- Q1. Node.js, OOPs concepts
I appeared for an interview in Apr 2020.
Interview Questionnaire
4 Questions
- Q1. Explain the most challenging problem you faced at work
- Q2. Given the following design - A university has colleges, colleges have departments, departments have students. There are department level elections being held where students nominate themselves to stand fo...
- Ans.
Design a database for a university with colleges, departments, and students. Write a query to get students with maximum votes.
Use a relational database like MySQL or PostgreSQL
Create tables for colleges, departments, students, and elections
Use foreign keys to establish relationships between tables
Add columns for election details like candidate names and vote counts
Write a query to join tables and filter for maximum vot
- Q3. Explain how you would design a bit.ly URL shortening service. What would be the choice of database. What would be your table design what would be the endpoints
- Ans.
Design a bit.ly URL shortening service with database choice, table design, and endpoints.
Use a relational database like MySQL or PostgreSQL for scalability and ACID compliance.
Create a table with columns for the original URL, shortened URL, and metadata like creation date and click count.
Endpoints should include URL shortening, redirection, and analytics.
Implement caching to improve performance and reduce database load...
- Q4. Coding test - knapsack problem, 2 sum problem, alien language problem. All from leetcode.
Interview Preparation Tips
Read or watch system design questions explained on Youtube.
Skills evaluated in this interview
(1 Question)
- Q1. Asked about the previous job experience and area of interest like frontend or backend
Coding test was on reactjs and html
(1 Question)
- Q1. Asked about all the react concepts in detail
(1 Question)
- Q1. Javascript basics were asked
Create a hero section for website
Clootrack Software Labs Interview FAQs
Tell us how to improve this page.
Clootrack Software Labs Interviews By Designations
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Data Analyst Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Clootrack Software Labs Senior Data Analyst Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Clootrack Software Labs Senior Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Data Analyst
49
salaries
|  ₹3 L/yr - ₹9 L/yr |
|
Senior Data Analyst
17
salaries
| ₹6 L/yr - ₹10.3 L/yr |
|
HR Manager
6
salaries
| ₹6 L/yr - ₹12.5 L/yr |
|
Senior Product Manager
6
salaries
| ₹22 L/yr - ₹30 L/yr |
|
Software Development Engineer 3
5
salaries
| ₹26 L/yr - ₹40 L/yr |
GrapplTech
Rialtes Technologies
Wilco Source
TraviYo
- Home >
- Interviews >
- Clootrack Software Labs Interview Questions >
- Clootrack Software Labs Senior Data Analyst Interview Questions
