Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by UST Team. If you also belong to the team, you can get access from here

UST Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 4.2k Reviews

Filter interviews by

UST Lead Consultant Interview Questions and Answers

Updated 19 Oct 2024

UST Lead Consultant Interview Experiences

1 interview found

Lead Consultant Interview Questions & Answers

user image Naeem Majjid Shikalgar

posted on 19 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Tell me the sap journey
  • Ans. 

    The SAP journey involves implementing, customizing, and optimizing SAP software to meet business needs.

    • Start with understanding the business requirements and goals

    • Implement SAP software modules based on the requirements

    • Customize the software to fit the specific needs of the organization

    • Optimize the system for efficiency and effectiveness

    • Provide training and support to users for successful adoption

  • Answered by AI
  • Q2. Subcontracting process
  • Q3. Consignment process
Round 2 - HR 

(1 Question)

  • Q1. Salary expectations

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Tell me about the project you have worked recently?
  • Q2. Any challenges faced recently?
  • Q3. What is difference between union and union all
  • Ans. 

    UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicate rows.

    • UNION removes duplicate rows from the result set, while UNION ALL includes all rows

    • UNION is slower than UNION ALL because it has to perform a distinct operation

    • UNION requires that all SELECT statements have the same number of columns with compatible data types

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. How do you approach performance tuning of a stored procedure?
  • Ans. 

    I approach performance tuning of a stored procedure by analyzing query execution plans, optimizing indexes, and rewriting inefficient code.

    • Analyze query execution plans to identify bottlenecks

    • Optimize indexes to improve data retrieval speed

    • Rewrite inefficient code to reduce unnecessary processing

    • Consider parameter sniffing and data distribution for optimal performance

  • Answered by AI
  • Q2. What is recursive CTE
  • Ans. 

    A recursive CTE (Common Table Expression) is a query that references itself within the query definition.

    • Allows for hierarchical data querying

    • Uses a base case and recursive member in the query

    • Example: querying a table with parent-child relationship using recursive CTE

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Are you flexible on timing

Interview Preparation Tips

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

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
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 - One-on-one 

(1 Question)

  • Q1. Day to day activities
Round 3 - Technical 

(1 Question)

  • Q1. Day to day activities
Round 4 - HR 

(1 Question)

  • Q1. Package discussion and notice period discussion
Round 1 - Technical 

(2 Questions)

  • Q1. SAP PP technical related
  • Q2. Willing to Travel and are you ok to work any kind of project?
Round 2 - HR 

(1 Question)

  • Q1. Salary Expectation and location preference.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was good as the interviewers made me comfortable. Asked relevant questions.
Round 1 - HR 

(6 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?
  • Q4. Where do you see yourself in 5 years?
  • Q5. What are your strengths and weaknesses?
  • Q6. Tell me about yourself.
Round 2 - Technical 

(1 Question)

  • Q1. Questions relevant to Whatever knowledge you gained in your professional career
Round 3 - HR 

(4 Questions)

  • Q1. Share details of your previous job.
  • Q2. Why should we hire you?
  • Q3. What are your strengths and weaknesses?
  • Q4. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Get the clarity on email about your roles and responsibilities. Lot of confusion internal management and leaders have.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Solid principles with real time examples
  • Ans. 

    Solid principles are a set of design principles for writing clean, maintainable code.

    • Single Responsibility Principle - A class should have only one reason to change. Example: A class that handles user authentication should not also handle database operations.

    • Open/Closed Principle - Classes should be open for extension but closed for modification. Example: Using interfaces to allow for different implementations without ...

  • Answered by AI
  • Q2. Design patterns and its use
  • Ans. 

    Design patterns are reusable solutions to common problems in software design.

    • Design patterns help in creating flexible, maintainable, and scalable software.

    • Examples of design patterns include Singleton, Factory, Observer, and Strategy.

    • They provide a common language for developers to communicate and understand each other's code.

    • Design patterns can be categorized into creational, structural, and behavioral patterns.

  • Answered by AI

Skills evaluated in this interview

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

I was interviewed in Jul 2023.

Round 1 - Technical 

(1 Question)

  • Q1. Data Modelling , Data Warehouse
Round 2 - Technical 

(2 Questions)

  • Q1. Questions on Data Modelling, Previous projects worked in Data Analytics
  • Q2. SQL, Power BI, Data modelling Questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Basic Interview with Manager
Round 4 - HR 

(1 Question)

  • Q1. Basic Questions, Discussion on package

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on the topics if you are applying for Analytical Roles

Dimension Table, Fact Tables , Star schema , Snowflake schema , Power BI Concepts , SQL - Views , Joins , CTE's , Sub procedures
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. JavaScript Methods
  • Ans. 

    JavaScript methods are built-in functions that can be called on objects to perform specific tasks.

    • Methods are called using dot notation, like object.method().

    • Some common methods include toString(), toUpperCase(), and includes().

    • Methods can also be used to manipulate arrays, such as push(), pop(), and splice().

  • Answered by AI
  • Q2. Coding questions of JavaScript methods.
Round 2 - Technical 

(2 Questions)

  • Q1. Lifecycle methods
  • Q2. Coding questions

Skills evaluated in this interview

I applied via Recruitment Consulltant and was interviewed in Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Application functionality related questions.
  • Ans. Retention policy functionality, Legal hold applying and how many of them, app handling on server end. JReports functionality etc.
  • Answered by parimal raj
Round 3 - Client Interview 

(1 Question)

  • Q1. Best practices, Issues faced and how they were mitigated
  • Ans. 

    Best practices, issues faced, and their mitigation in the role of Lead Consultant

    • Implementing regular communication channels to ensure effective collaboration among team members

    • Establishing clear project goals and objectives to guide the team's efforts

    • Identifying and addressing potential risks and challenges proactively

    • Leveraging industry best practices and lessons learned from previous projects

    • Encouraging continuous l...

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. Expectation of Salary
  • Ans. Hike more than my existing offer.
  • Answered by parimal raj

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with the concepts of the tool you are using and have some server side handling capability.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jan 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Spring security
  • Q2. Spring boot end to end flow

UST Interview FAQs

How many rounds are there in UST Lead Consultant interview?
UST interview process usually has 2 rounds. The most common rounds in the UST interview process are Technical and HR.
How to prepare for UST Lead Consultant 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 UST. The most common topics and skills that interviewers at UST expect are JDA, Oracle, PL, PLSQL and RDBMS.
What are the top questions asked in UST Lead Consultant interview?

Some of the top questions asked at the UST Lead Consultant interview -

  1. Tell me the sap jour...read more
  2. Subcontracting proc...read more
  3. Consignment proc...read more

Tell us how to improve this page.

UST Lead Consultant Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
UST Lead Consultant Salary
based on 14 salaries
₹13 L/yr - ₹30 L/yr
At par with the average Lead Consultant Salary in India
View more details

UST Lead Consultant Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

1.0

Skill development

3.0

Work-life balance

1.0

Salary

1.0

Job security

3.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Software Developer
2.1k salaries
unlock blur

₹2.5 L/yr - ₹12.4 L/yr

Senior Software Engineer
1.7k salaries
unlock blur

₹6.5 L/yr - ₹26 L/yr

Software Engineer
1.3k salaries
unlock blur

₹3.6 L/yr - ₹14.8 L/yr

System Analyst
1.2k salaries
unlock blur

₹6.5 L/yr - ₹22.6 L/yr

Senior Software Developer
1.1k salaries
unlock blur

₹5.5 L/yr - ₹20 L/yr

Explore more salaries
Compare UST with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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