Zensar Technologies Senior Lead Consultant Interview Questions, Process, and Tips

Q1. Unprofessional HR asks any random thing but are themselves don't know anything
Add your answer
Q2. Whatever HR says is false so read ambition box and Google reviews of both Bangalore and Mumbai office to know the reality
Add your answer
Q3. This review is to help other candidates make decision before interviewing at Datamatics
Add your answer

Q1. Mysql query for 3rd highest salary
Ans. 
Use a subquery to find the third highest salary from the employees table in MySQL.
• Use a subquery to select distinct salaries from the employees table.

• Order the salaries in descending order and use LIMIT to get the third highest salary.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 2, 1;
Answered by AI
Add your answer
Q2. What are the steps to connect to a database?
Ans. 
Steps to connect to a database involve specifying the database type, providing credentials, and establishing a connection.
• Specify the type of database you want to connect to (e.g. MySQL, PostgreSQL, MongoDB).

• Provide the necessary credentials such as username and password.

• Establish a connection using a programming language or tool like JDBC, ODBC, or ORM frameworks.
Answered by AI
Add your answer

Q1. How to do Deployment
Add your answer
Q2. Mvc page life cycle
Add your answer

A 60-minute aptitude test.

In this round, you will receive multiple questions tailored to your area of expertise.

Q1. What motivated you to pursue a career in UI/UX design?
Add your answer
Q2. Could you please showcase your previous work experiences?
Add your answer

Q1. Responsibility in current company
Ans. 
I am currently responsible for managing client relationships and project timelines in my current company.
• Managing client relationships by ensuring clear communication and addressing any concerns or issues promptly

• Creating and maintaining project timelines to ensure deliverables are met on time

• Collaborating with cross-functional teams to ensure project success

• Providing regular updates to clients on project progress and
Answered by AI
Add your answer
Q2. What are the business process involve in sap pp
Ans. 
SAP PP involves business processes related to production planning and control.
• Creation of production orders

• Material requirement planning

• Capacity planning

• Shop floor execution

• Production scheduling
Answered by AI
Add your answer
Q3. Org structure of SAP
Ans. 
The org structure of SAP refers to the way in which SAP organizes its internal departments, teams, and reporting relationships.
• SAP typically follows a matrix organizational structure, with functional departments (such as sales, marketing, finance) and project teams working together.

• The org structure can vary depending on the size and complexity of the organization, as well as the specific industry or market focus.

• SAP m...read more
Answered by AI
Add your answer

Q1. Exolain jvm Architecture
Add your answer
Q2. Write pallindrome code
Ans. 
A palindrome code is a program that checks if a given string reads the same forwards and backwards.
• Create a function that takes a string as input

• Reverse the string and compare it to the original string

• Return true if they are the same, false otherwise
Answered by AI
Add your answer

Q1. What is cursor and it's use
Ans. 
A cursor is a database object used to retrieve and manipulate data in a database management system.
• A cursor allows for sequential processing of query results one row at a time.

• It can be used to update or delete specific rows in a result set.

• Cursors are commonly used in stored procedures and triggers.

• Example: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;
Answered by AI
Add your answer
Q2. Query using listagg
Ans. 
Query using listagg function to concatenate values into a single string
• Use the listagg function followed by the column name and delimiter in parentheses

• Specify the order by clause if needed

• Can be used in SQL queries to display aggregated data
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer
Q2. Confidence analysis
Add your answer

Q1. If you have a super power what would it be
Add your answer

Artifical Intelligence