Affinity Global Advertising Senior Associate Interview Questions and Answers for Experienced

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. Laravel framework question.
Add your answer

Q1. Laravel framework question
Add your answer

Q1. What are synthetic Events?
Ans. 
Synthetic Events are events that are created by the browser to mimic real user events.
• Synthetic Events are used in React to handle events in a consistent manner across different browsers.

• They are created by React to wrap native browser events and provide additional functionality.

• Examples include onClick, onChange, and onSubmit events in React.
Answered by AI
Add your answer
Q2. What is event bubbling?
Ans. 
Event bubbling is the process where an event triggered on a child element is propagated up through its parent elements.
• Event bubbling allows a single event handler to be attached to a parent element, which will be triggered for all its children.

• When an event occurs on a child element, it first runs the event handlers on the child, then on its parent, and so on up the DOM tree.

• Event bubbling can be stopped using event.s
Answered by AI
Add your answer

Q1. Self intro - tell me about yourself
Ans. 
I am a software developer with a passion for creating efficient and user-friendly applications.
• Proficient in multiple programming languages such as Java, C++, and Python

• Experience in developing web applications using HTML, CSS, and JavaScript

• Strong problem-solving and analytical skills

• Familiarity with agile development methodologies

• Excellent communication and teamwork abilities
Answered by AI
Add your answer
Q2. Experience & why do you want to switch
Ans. 
I have 5 years of experience as a Software Developer and I want to switch to explore new technologies and challenges.
• I have 5 years of experience as a Software Developer.

• I have gained expertise in various programming languages and frameworks.

• I have successfully delivered multiple projects and contributed to their success.

• I want to switch to explore new technologies and challenges.

• I believe switching will help me enhanc
Answered by AI
Add your answer

Simple basic code for Form data

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. 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