Upload Button Icon Add office photos

Filter interviews by

411 Locals Technical Lead Interview Questions and Answers for Experienced

Updated 18 Jun 2021

411 Locals Technical Lead Interview Experiences for Experienced

1 interview found

I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. How to optimize SQL and database?
  • Ans. 

    Optimizing SQL and database involves improving query performance and database design.

    • Use indexes to speed up query execution

    • Normalize database tables to reduce redundancy

    • Avoid using SELECT * and instead specify required columns

    • Use stored procedures to reduce network traffic

    • Regularly analyze and optimize database performance

  • Answered by AI
  • Q2. Which all control statements are there in the database? Why we need it?
  • Ans. 

    Control statements in database are used to control the flow of execution of SQL statements.

    • Control statements in database include IF, CASE, WHILE, LOOP, and GOTO.

    • They are used to control the flow of execution of SQL statements.

    • They help in making decisions, looping through data, and jumping to specific parts of code.

    • For example, the IF statement can be used to check a condition and execute a block of code if the condit...

  • Answered by AI
  • Q3. Prepare on basics of PHP and few logical code relate

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was completely technical based on your problem-solving ability.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com

Interview Questionnaire 

2 Questions

  • Q1. Why Amazon?
  • Q2. What do you expect from Amazon?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be open to anything, and keep your expectations low as your expectations might kill you. Just relax and take everything in a healthy way

Associate Interview Questions & Answers

Amazon user image Arshiya Saba

posted on 10 Sep 2020

I applied via Company Website and was interviewed in Aug 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Basic Q & A

Interview Preparation Tips

Interview preparation tips for other job seekers - First-round I had English grammatical questions following that it took me to speech recognition, listen and type or type & email drafting. all you need is a calm mind and peaceful place and your set to go.

I applied via Referral and was interviewed before May 2021. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. How much time u work continues
  • Q2. How much salary do u expect

Interview Preparation Tips

Interview preparation tips for other job seekers - Really hard work as associate good for Hrs

I applied via Walk-in and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Group Discussion 

HR told about the company on the first day, how it works, told the rules, showed the management and a lot

Interview Preparation Tips

Topics to prepare for Amazon Associate interview:
  • Safery
  • Environment
  • Cleaning
Interview preparation tips for other job seekers - There is nothing to worry, if you have the desire to work and have passion, then you can work anywhere.

I was interviewed before May 2016.

Interview Preparation Tips

Round: Group Discussion
Experience: Extempore was conducted which is almost same as GD. In Extempore round each individual should select his own topic and talk for 2 minutes. Eye donation was the topic selected by me. The main concept of this round is to check the fluency over language
Tips: Be confident in what you speak. Dont get nervoused in this round

Round: Problem Statement
Experience: Extempore was conducted which is almost same as GD. In Extempore round each individual should select his own topic and talk for 2 minutes. Eye donation was the topic selected by me. The main concept of this round is to check the fluency over language
Tips: Be confident in what you speak. Dont get nervoused in this round

I was interviewed in Sep 2016.

Interview Questionnaire 

2 Questions

  • Q1. Being a mechanical engineer why do you choose corporate?
  • Ans. 

    As a mechanical engineer, I choose corporate because it offers diverse opportunities, professional growth, and stability.

    • Corporate provides a wide range of industries and sectors to work in, allowing me to explore different areas of mechanical engineering.

    • Working in a corporate environment offers opportunities for professional growth through training programs, mentorship, and exposure to new technologies.

    • Corporate jobs...

  • Answered by AI
  • Q2. Common puzzle questions

Interview Preparation Tips

Round: Group Discussion
Experience: Extempore was the name of the round. It is almost same as GD but instead each candidate should select his own topic and talk for 2 minutes.
Tips: Fluency over language is the main element focused in this round
Duration: 2 hours

Round: Problem Statement
Experience: In this round the candidate should attend online aptitude test for 1 hour. It consists of three parts : Logical part, Reasoning part, Language part. This round is easier one.
Tips: Concentrate more on English grammar

Round: HR Interview
Experience: Shortlisted candidates were called for HR round. For non IT students the main question asked was being a non IT student why do you choose corporate field.
Tips: The answer for this question cannot be provided by myself. Each of you candidates should build a genuine answer for this one

Round: Puzzle Interview
Experience: This is the final round of the whole interview process. In this round the candidates were focused asking only on puzzle questions. 3 to 5 questions were asked in this round depending upon the mentality of HR. 75 % score is required to clear this round
Tips: Just Google puzzle questions for interview, then work on those questions. You will get an idea on how to clear this round

Associate Interview Questions & Answers

Amazon user image Sayeda Peerzade

posted on 10 Jul 2017

I was interviewed in Mar 2017.

Interview Questionnaire 

1 Question

  • Q1. Self introduction, Strengthens and weakness, best friend, why Amazon

Interview Preparation Tips

Round: Resume Shortlist
Experience: We were asked to introduce ourselves and also speak about the environment of the room. Then asked to speak about Amazon and why do we want to work with Amazon
Tips: Be confident

Round: Test
Experience: Pronounciaton skills were examined
Tips: Flexible in talking in English
Duration: 20 minutes
Total Questions: 25

Round: HR Interview
Experience: HR was really cooperative he asked to relax and then started asking questions in a gentle manner. He made me feel comfortable. And reduced the nervous environment.
Tips: Be confident and don't be nervous

Skills: Language, Time Management
College Name: VHD central institute of home science

I applied via Company Website and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Your Personal Details, Your Qualifications?
  • Ans. This answer must be basied on you resume.
  • Answered Anonymously
  • Q2. Why IndiaMart?
  • Ans. This type of question are based on you knowledge and your experiences
  • Answered Anonymously
  • Q3. What are you skills and how you would implement them while working with us?
  • Ans. For this you need to know you Positive Point and Negative Point which are totally based on your behavior and Personality
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Natural and Original while interviewing

I applied via Referral and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. First they ask tell me about yourself and second they give you any topic to speak continues for 5 minutes. They check only your grammer if someone is not comfortable to that topic you can tell them to give...

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is so simple. Don't hesitate if someone looking for going to Paytm. They can free you in half n hour. All the documentation they can do on same day. Kindly get your marksheet and graduation degree certificate while you go for interview.

411 Locals Interview FAQs

What are the top questions asked in 411 Locals Technical Lead interview for experienced candidates?

Some of the top questions asked at the 411 Locals Technical Lead interview for experienced candidates -

  1. Which all control statements are there in the database? Why we need ...read more
  2. How to optimize SQL and databa...read more
  3. Prepare on basics of PHP and few logical code rel...read more

Tell us how to improve this page.

Executive Recruiter
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Digital Marketing Manager
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Leader SEO
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior PHP Developer
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare 411 Locals with

JustDial

3.5
Compare

Urban Company

3.4
Compare

Indiamart Intermesh

3.6
Compare

Quikr

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