Yell Adworks Interview Questions and Answers

Q1. Face to face interview
Add your answer
Q2. What criteria are used to shortlist students?
Add your answer
Q3. Master degree in eligibility
Add your answer
Q4. Communication skills good
Add your answer
Q5. Marketing field
Add your answer

Q1. Basic Communication Skills
Add your answer
Q2. Background and why to change the job
Ans. 
Looking for new challenges and growth opportunities in a dynamic environment.
• Seeking opportunities to utilize my skills and expertise in a new setting

• Interested in taking on more responsibilities and challenges

• Want to work in a more innovative and fast-paced environment

• Seeking career advancement and professional growth

• Want to broaden my experience and knowledge in the field
Answered by AI
Add your answer

Q1. Brief about your background
Ans. 
I have over 10 years of experience in managing MIS systems and data analysis for various organizations.
• Managed and maintained databases for tracking and analyzing sales data

• Developed automated reports to streamline data analysis processes

• Implemented data visualization tools to present insights to senior management

• Led cross-functional teams to improve data accuracy and efficiency

• Trained staff on data management best pra
Answered by AI
Add your answer
Q2. Excel and SQL basic questions. For data visualisation.
Add your answer

Q1. What are the roles you were responsible for in previous company
Ans. 
In my previous company, I was responsible for managing database systems, developing reports, analyzing data, and providing technical support.
• Managed database systems to ensure data integrity and security

• Developed reports for management to track key performance indicators

• Analyzed data to identify trends and make recommendations for process improvements

• Provided technical support to end users for troubleshooting and syste
Answered by AI
Add your answer
Q2. Pivot tables and Financial basic questions on revenue.
Add your answer

Q1. How do you think will fit in the role?
Ans. 
I have extensive experience in managing MIS systems and analyzing data to drive business decisions.
• I have a strong background in MIS systems and data analysis

• I have successfully implemented new systems and processes to improve efficiency

• I have a track record of using data to drive strategic business decisions

• I am familiar with a variety of software tools and technologies used in MIS roles
Answered by AI
Add your answer
Q2. Basic understanding of Revenue and Financial statements.
Add your answer
Q3. What do you want to do in life? The goal.
Ans. 
My goal in life is to continuously learn, grow, and make a positive impact on others.
• Continuous learning and self-improvement through courses, workshops, and reading

• Advancing in my career by taking on challenging projects and seeking new opportunities

• Contributing to society through volunteering and mentorship programs
Answered by AI
Add your answer

Q1. Basic communication skills with the background test.
Add your answer
Q2. Why this role suits you.
Ans. 
I have a strong background in MIS and a proven track record of successfully implementing and managing systems to improve efficiency and productivity.
• I have extensive experience in analyzing data and identifying trends to make informed business decisions.

• I have a deep understanding of various MIS tools and technologies, allowing me to effectively streamline processes and optimize performance.

• I have a history of collabor...read more
Answered by AI
Add your answer
Q3. Current and expectation of salary.
Ans. 
My current salary is competitive based on my experience and skills. I am looking for a salary that reflects my value and contributions to the company.
• Current salary is in line with industry standards

• Expectation is based on market research and my experience

• Looking for a salary that recognizes my skills and contributions

• Open to negotiation based on benefits package
Answered by AI
Add your answer

This was a multiple-choice exam, and the questions were related to English, mathematics, and reasoning.

Q1. Technical questions related to paints chemistry
Add your answer
Q2. What are pigments and what are the types of pigments and what are resins
Add your answer
Q3. What is capillary action and what is PH value
Add your answer

Q1. This was with regional manager
Add your answer

Apne ap par bharosa aur attitude ke sath kam karna

While working, focus on your kaam

Q1. What are the positive aspects of the job?
Add your answer
Q2. Technical masino ka sahi tarike se karna
Add your answer

Q1. What are the standards for scaffolding codes?
Add your answer
Q2. What are the different types of scaffolding erection?
Add your answer
Q3. What type of use material for safety purchase
Add your answer
Q4. How to safe Erection
Add your answer
Q5. Identify risk and hazard
Add your answer

Q1. I am krishna murthy p
Add your answer
Q2. I am Instrested bmm ispat company one of the best company
Add your answer
Q3. One opportunity given sir
Add your answer
Q4. Electrical engineering
Add your answer
Q5. I am name krishna murthy p i am stady diploma electrical engineering I am experience totally 8 years
Add your answer

Q1. What is the Singleton pattern ? in how many ways can this pattern be broken ?
Ans. 
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
• Singleton pattern can be implemented by making the constructor private and providing a static method to access the instance.

• The pattern can be broken by using reflection to access the private constructor and create multiple instances.

• Another way to break the Singleton pattern is by using multiple class loaders in Java.

• Th...read more
Answered by AI
Add your answer
Q2. What is the internal implementation of hashmap? Let's assume that you want to store duplicate keys in the hashmap, how can we achieve the same in hashmap ?
Ans. 
HashMap internally uses an array of linked lists to store key-value pairs. To store duplicate keys, we can use a custom implementation of HashMap.
• HashMap internally uses an array of linked lists to handle collisions.

• To store duplicate keys, we can create a custom HashMap implementation that allows multiple values for the same key.

• One approach is to use a HashMap with values as lists, where each key can have multiple va
Answered by AI
Add your answer

Q1. What microservices patterns are you aware ? let's assume that there is a microservice based architecture and service A is calling service B which in turn service C. If service b fails, how will you manage ...read more
Ans. 
Use compensating transactions and distributed tracing for managing transaction and logging in case of service B failure.
• Implement compensating transactions to rollback changes made by service B in case of failure.

• Use distributed tracing to track the flow of requests and identify where the failure occurred.

• Implement retry mechanisms to handle transient failures in service B.

• Use circuit breakers to prevent cascading fail...read more
Answered by AI
Add your answer
Q2. System Design question : Design a booking wesite for.eg: bookin.com ?
Add your answer

Aptitude, Cloud services, Python, SQL queries

Q1. About the project from current company.
Add your answer
Q2. SQL: Write a sproc logic to upsert data into a table.
Add your answer

Q1. About the project, and other questions from resume
Add your answer
Q2. Guesstimate questions
Add your answer
Q3. Conflict resolution between team members.
Add your answer

Q1. Brief about your education, career, previous projects handled, and role & responsibility in past organisations?
Add your answer
Q2. Current roles & responsibilities and value addition done by you and your team?
Add your answer
Q3. Process flow for planning throughout project life-cycle?
Add your answer
Q4. Critical/concerning areas to be monitored?
Add your answer
Q5. Productivity and permissible material wastage, process to prepare material reconciliation?
Add your answer
Q6. Understanding about claim and type of claim raised/supported to raise in past experience?
Add your answer
Q7. Experience of technical aspects and planning assessment required at tendering stage, capabilities to prepare tender submittals and proving insights to management on same?
Add your answer
Q8. Necessity of providing PMO support to management?
Add your answer
Q9. Understanding about role & responsibility of regional planning manager?
Add your answer
Q10. MIS and type of reports prepared in past and their significance for Top managemennt?
Add your answer