Upload Button Icon Add office photos

Filter interviews by

Lonar Consulting Services Interview Questions and Answers

Updated 6 Jul 2023

Lonar Consulting Services Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jun 2023. There were 3 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 - Technical 

(4 Questions)

  • Q1. Asking Basic question and project related knowledge
  • Q2. Opps Concept and Agine methology
  • Q3. Sql Server function and Store Procedure
  • Ans. 

    SQL Server functions and stored procedures are used to encapsulate logic for reuse and performance optimization.

    • Functions are used to return a single value, while stored procedures can perform multiple operations.

    • Functions can be used in SELECT statements, WHERE clauses, and JOIN conditions.

    • Stored procedures can be called from applications to execute a series of SQL statements.

    • Functions can be scalar (returning a singl...

  • Answered by AI
  • Q4. Agular interseptopr routing decorator
Round 3 - HR 

(1 Question)

  • Q1. Basic Details and Salary Discussion and

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't go here.

Skills evaluated in this interview

Senior Software Engineer Interview Questions asked at other Companies

Q1. Tell me about yourself. What technology are you using? What is a Collection? What are the different types of collection there? What is the difference between ArrayList and LinkedList What are the basic building blocks of Stream operators, s... read more
View answer (2)

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. About the projects I have managed in my previous organizations, the dashboards I have worked on , data analysis tools skills
  • Ans. 

    I have managed various projects and worked on dashboards and data analysis tools.

    • Managed projects in previous organizations

    • Worked on dashboards

    • Skilled in data analysis tools

    • Used Tableau to create dashboards for sales and marketing teams

    • Analyzed customer data using Excel and Python

    • Created reports on project progress using JIRA

  • Answered by AI
  • Q2. I have thorough knowledge about my projects, dashboards

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough about the projects you have handled , Don't go after multiple technical skills just make the existing ones stronger.

I applied via Walk-in and was interviewed in May 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Self intro & Data & network related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - No

Interview Questionnaire 

3 Questions

  • Q1. Work experience
  • Q2. Advance excel
  • Q3. Puzzles

Interview Questionnaire 

1 Question

  • Q1. I was experienced that's why they only asked me about what I do in my previous job. Which is they exactly required.

Interview Questionnaire 

2 Questions

  • Q1. My skills , qualification, last job experiences
  • Q2. Salary expectations

I applied via LinkedIn and was interviewed before Jul 2020. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Tell me about yourself.
  • Ans. I am MBA and had worked very consistently with my past organisation. I had been provided with the role of a quality assurance analyst and I did my job very efficiently.
  • Answered Anonymously
  • Q2. How can you add value to this organisation.
  • Ans. I will try to put best of my abilities while keeping in mind the core values that this organisation have. Will bring innovative ideas into practice which will be aligned with the teams objective.
  • Answered Anonymously
  • Q3. Advance excel questionnaire: Power Pivot, VBA, lookup functions, dynamic dashboard advices and some statistical concepts like standard deviation, mean, median, mode and their uses. How to create charts and...
  • Q4. Case Study: I have to come-up with the list of owners who owns the most expensive cars in South Delhi region. I have to think about the data sources and the type of data that I would needed. Have to figure...

Interview Preparation Tips

Interview preparation tips for other job seekers - Having technical superiority is not the best ability to have rather try to find out how to integrate the findings to add value to the business

Try to put only those things in resume with which you are confident

Be smart, active and positive while giving answers

I applied via LinkedIn and was interviewed in Mar 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All were Ds and algo questions?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared on DS and algo section. Also keep practising on online competitive coding.

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Medium

The test was scheduled around 5 evening and it had 3 coding questions. First question was on Dynamic Programming and other was medium question and was easy and the third was based on graph. And there were 20 mcq questions on Data structures, DBMS and OS

  • Q1. 

    Matrix Word Search Problem

    Explanation: You are given an 'M' x 'N' matrix of characters named CHARACTER_MATRIX and a string WORD. Your task is to identify and list all the occurrences of the string within...

  • Ans. 

    Matrix Word Search Problem - Find occurrences of a given word in all eight possible directions within a matrix.

    • Iterate through each cell in the matrix and check for the starting character of the word.

    • For each occurrence of the starting character, check all eight directions for the complete word.

    • Keep track of the coordinates of each character in the word for each occurrence found.

    • Ensure boundaries are not crossed while ...

  • Answered by AI
Round 2 - Video Call 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

Normal Coding question on Graphs and some basics from DBMS

  • Q1. 

    Transitive Closure of Directed Graph Problem Statement

    Given a directed graph with 'V' vertices and 'E' edges, determine if a vertex i is reachable from vertex j for all pairs of vertices (i, j). A vertex...

  • Ans. 

    Determine reachability between all pairs of vertices in a directed graph.

    • Use Floyd Warshall algorithm to find transitive closure of the graph.

    • Initialize a V x V matrix with 1s on the diagonal and 0s elsewhere.

    • Update matrix by checking if there is a path from i to j through k.

    • Repeat the process for all vertices to get the transitive closure matrix.

  • Answered by AI
Round 3 - Video Call 

(1 Question)

Round duration - 60 minutes
Round difficulty - Hard

He asked me to read about Morse language in wikepedia and asked me to write a code on it i. e. If the input Morse code and in output we should get it in English

  • Q1. 

    Morse Code to English Problem Statement

    You are provided with a string of morse code(s) of length N. Your task is to convert this morse code into the corresponding alphanumeric code consisting of lowercas...

  • Ans. 

    Convert Morse code to alphanumeric code using a predefined table.

    • Iterate through the morse code string and convert each morse code to its corresponding alphanumeric character using the given table.

    • Join the converted characters to form the final alphanumeric string.

    • Handle spaces between morse code characters by adding a space in the final alphanumeric string.

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from Banasthali University. I applied for the job as SDE - 1 in BangaloreEligibility criteriaAbove 7 CGPAGoldman Sachs interview preparation:Topics to prepare for the interview - Dynamic Programming, Data Structures, Algorithms, Pointers, OOPsTime required to prepare for the interview - 2 monthsInterview preparation tips for other job seekers

Tip 1 : Do all the questions of interview bit atleast twice for those who are not good in coding much. And simultaneously do mcqs from geeks for geeks especially from the topics Data structures, DBMS and Operating system
Tip 2 : Do go through all the dynamic programming questions from geeks for geeks. 
Tip 3 : Practice lot of questions from leetcode.

Application resume tips for other job seekers

Tip 1 : Always keep your resume short 
Tip 2 :Try to keep it on one page . And never put false things on resume and write only those topics that you have thorough knowledge

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Java based questions
  • Q2. Tool based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep it simple and straightforward

Lonar Consulting Services Interview FAQs

How many rounds are there in Lonar Consulting Services interview?
Lonar Consulting Services interview process usually has 3 rounds. The most common rounds in the Lonar Consulting Services interview process are Resume Shortlist, Technical and HR.
How to prepare for Lonar Consulting Services interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Lonar Consulting Services. The most common topics and skills that interviewers at Lonar Consulting Services expect are Oracle Apps, Database Administration and Oracle Development.
What are the top questions asked in Lonar Consulting Services interview?

Some of the top questions asked at the Lonar Consulting Services interview -

  1. Sql Server function and Store Proced...read more
  2. Opps Concept and Agine methol...read more
  3. Agular interseptopr routing decora...read more

Tell us how to improve this page.

Lonar Consulting Services Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Cognizant Interview Questions
3.7
 • 5.7k Interviews
WNS Interview Questions
3.4
 • 1.1k Interviews
Goldman Sachs Interview Questions
3.5
 • 380 Interviews
TCE Interview Questions
3.8
 • 251 Interviews
Mu Sigma Interview Questions
2.6
 • 234 Interviews
Tiger Analytics Interview Questions
3.7
 • 227 Interviews
Gallagher Interview Questions
3.7
 • 223 Interviews
BCG Interview Questions
3.7
 • 197 Interviews
Capita Interview Questions
3.6
 • 147 Interviews
View all

Lonar Consulting Services Reviews and Ratings

based on 2 reviews

4.0/5

Rating in categories

3.0

Skill development

4.0

Work-life balance

3.0

Salary

2.0

Job security

3.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 2 Reviews and Ratings
Compare Lonar Consulting Services with

Cognizant

3.7
Compare

WNS

3.4
Compare

Capita

3.6
Compare

Gallagher

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