Upload Button Icon Add office photos

Filter interviews by

Ideatelabs Interview Questions and Answers

Updated 24 Feb 2022

Ideatelabs Interview Experiences

1 interview found

Intern Interview Questions & Answers

user image Anonymous

posted on 24 Feb 2022

I applied via LinkedIn and was interviewed before Feb 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Your educational background and previous work experience
  • Q2. Why do you see yourself fit in our organisation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in the interview round

Intern Interview Questions asked at other Companies

Q1. Case. There is a housing society “The wasteful society”, you collect all the household garbage and sell it to 5 different businesses. Determine what price you will pay to the society members in Rs/kg, given you want to make a profit of 20% ... read more
View answer (8)

Interview questions from similar companies

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Coding Test 

Easy leetcode data structure question

Round 3 - Technical 

(1 Question)

  • Q1. Write working code for calling a rest API, design rate limiter
  • Ans. 

    Code for calling a REST API and designing a rate limiter

    • Use a library like requests or axios to make the API call

    • Implement a token bucket algorithm for rate limiting

    • Set a maximum number of requests per second and queue excess requests

    • Consider using a distributed rate limiter for scalability

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. Design Database schema for instagram
  • Ans. 

    Design a database schema for Instagram.

    • Create tables for users, posts, comments, likes, and follows.

    • Use primary and foreign keys to establish relationships between tables.

    • Store user data such as username, email, and password securely.

    • Include fields for post content, location, and timestamp.

    • Track likes and comments on posts.

    • Implement a notification system for follows and likes.

    • Consider scalability and performance in the...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - All round was smooth and interviewer were friendly.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Questions on vlook up, h-look up, pivot and if else condition
  • Q2. You must know how to use vlook up, h-look up and if-else condition
Round 2 - Assignment 

Excel file was give, used sumifs, countifs , index match formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - Just learn the excel famous questions and concept like look up, index match, nested if, concate function etc
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is invoke controller?
  • Ans. 

    Invoke controller is a component in a software application that manages the flow of requests and responses between the user interface and the backend services.

    • Manages the communication between user interface and backend services

    • Handles the routing of requests to appropriate functions or methods

    • Coordinates the flow of data and actions within the application

  • Answered by AI
  • Q2. What is facade in laravel?
  • Ans. 

    Facade in Laravel is a design pattern that provides a simple interface to a complex subsystem.

    • Facade provides a static interface to classes that are available in the application's service container.

    • It is used to simplify the usage of complex classes by providing a simpler interface.

    • Facade allows you to access Laravel's features without needing to instantiate objects or use dependency injection.

    • Example: The Auth facade ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
No response
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Laravel framework question.
Round 3 - One-on-one 

(1 Question)

  • Q1. Laravel framework question

Interview Preparation Tips

Interview preparation tips for other job seekers - Avoid this company
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Reasons for the drop in CPM
  • Ans. 

    Possible reasons for drop in CPM include seasonality, changes in ad inventory, shifts in audience demographics, and increased competition.

    • Seasonal fluctuations in advertising demand

    • Changes in available ad inventory

    • Shifts in audience demographics affecting targeting effectiveness

    • Increased competition leading to lower bids

  • Answered by AI
  • Q2. Types of floor in GAM
  • Ans. 

    Types of floors in GAM include carpet, hardwood, tile, and laminate.

    • Carpet

    • Hardwood

    • Tile

    • Laminate

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared and confident

I applied via Recruitment Consultant and was interviewed in Dec 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basics of Campaign building
  • Q2. What is Ad network and Ad exchange
  • Ans. 

    Ad network is a platform that connects advertisers with publishers to display ads. Ad exchange is a marketplace for buying and selling ad inventory.

    • Ad network connects advertisers with publishers to display ads

    • Ad exchange is a marketplace for buying and selling ad inventory

    • Ad network typically charges a commission on ad spend

    • Ad exchange uses real-time bidding to determine the price of ad inventory

    • Examples of ad network...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Always know about each and every term that you write in your resume. Do not brag about something that you don't know. Be transparent and calculative about your knowledge and offer.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. Basic SQL related- had to write 2 queries with basic joins.
  • Q2. Questions related to past experience
  • Q3. Drill down of 2 projects.
  • Ans. 

    Managed project to implement new inventory system and led team in redesigning customer service process.

    • Implemented new inventory system to streamline operations

    • Led team in redesigning customer service process to improve efficiency

    • Successfully managed project timelines and budgets

    • Collaborated with cross-functional teams to ensure project success

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very confident of your resume.

I applied via Campus Placement and was interviewed in Jul 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions from SQL, Python, Excel, Tableau and from my Projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with your projects properly
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Difference between union and union all in SQL?
  • Ans. 

    Union combines and removes duplicates, Union All combines without removing duplicates.

    • Union combines result sets and removes duplicates

    • Union All combines result sets without removing duplicates

    • Union is slower than Union All as it involves removing duplicates

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;

  • Answered by AI
  • Q2. How to show top 5 in pandas?
  • Ans. 

    To show top 5 in pandas, use the nlargest() function.

    • Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

    • For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. If we have 3 numerical columns, which chart is a better representation these column?
  • Ans. 

    A scatter plot is a better representation for 3 numerical columns.

    • Use a scatter plot to show the relationship between the numerical columns.

    • Scatter plots are effective for visualizing correlations and patterns in data.

    • Each point on the plot represents a data point with values from all 3 columns.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Omnicom Media Group Data Analyst interview:
  • SQL Server
  • Pandas
  • Power Bi

Skills evaluated in this interview

Ideatelabs Interview FAQs

How many rounds are there in Ideatelabs interview?
Ideatelabs interview process usually has 1 rounds. The most common rounds in the Ideatelabs interview process are One-on-one Round.

Tell us how to improve this page.

Ideatelabs Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

3 Minds Digital Interview Questions
4.4
 • 69 Interviews
Moris Media Interview Questions
4.4
 • 24 Interviews
Z1 Tech Interview Questions
4.0
 • 11 Interviews
Xapads Media Interview Questions
4.3
 • 10 Interviews
Bikayi Interview Questions
2.9
 • 10 Interviews
Jivox Interview Questions
3.8
 • 9 Interviews
Gushwork Interview Questions
4.1
 • 8 Interviews
View all

Ideatelabs Reviews and Ratings

based on 18 reviews

2.5/5

Rating in categories

1.9

Skill development

2.5

Work-life balance

2.5

Salary

1.8

Job security

2.1

Company culture

1.8

Promotions

1.6

Work satisfaction

Explore 18 Reviews and Ratings
Brand Manager
11 salaries
unlock blur

₹6 L/yr - ₹7.2 L/yr

Brand Associate
9 salaries
unlock blur

₹2 L/yr - ₹3.3 L/yr

Senior Brand Associate
7 salaries
unlock blur

₹2.7 L/yr - ₹4.8 L/yr

System Administrator
6 salaries
unlock blur

₹4 L/yr - ₹5.5 L/yr

Copywriter
6 salaries
unlock blur

₹3.8 L/yr - ₹5.8 L/yr

Explore more salaries
Compare Ideatelabs with

Omnicom Media Group

2.9
Compare

Z1 Tech

4.0
Compare

7Search PPC

4.8
Compare

Bikayi

2.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview