Affinity Global Advertising Team Lead Interview Questions and Answers for Experienced

Q1. 1. Explain about your self and the current company you work with.
Add your answer
Q2. 2. Any revenues achieved if yes was it a team target or on Individual role?
Add your answer
Q3. 3. Do you have any idea about our company 3 Minds Digital ?
Add your answer

Q1. 1. Explain about yourself, overall journey and your current role.
Add your answer
Q2. 2. Explain about your revenue contribution to the company.
Add your answer
Q3. 3. Explain about what understanding you have about the company 3 Minds Digital.
Add your answer
Q4. 4. One to One Client Game.
Add your answer

1. Basic Aptitude Test in order to check the ability. Duration was about 60 minutes.

Q1. Questions on vlook up, h-look up, pivot and if else condition
Add your answer
Q2. You must know how to use vlook up, h-look up and if-else condition
Add your answer

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

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
Add your answer
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 ...read more
Answered by AI
Add your answer

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
Add your answer
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
Add your answer

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
Add your answer

Q1. About datorama explain how it works
Add your answer
Q2. More about digital marketing
Add your answer

Easy leetcode data structure 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
Add your answer

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...read more
Answered by AI
Add your answer

Q1. Basic SQL related- had to write 2 queries with basic joins.
Add your answer
Q2. Questions related to past experience
Add your answer
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
Add your answer

Q1. Laravel framework question.
Add your answer

Q1. Laravel framework question
Add your answer