Publicis Sapient Senior Associate Consultant Interview Questions and Answers

Simple ones , you can search on internet

Q1. Oops questions and some programming questions
Add your answer
Q2. Fundamentals questions of basic understandings
Add your answer

Q1. Dot net basic to advanced questions.
Add your answer
Q2. .Net core, MVC,Web APi and Angular
Add your answer

Q1. Dot net basic to advanced questions.
Add your answer

Q1. Client round advanced questions.
Add your answer

Q1. Asked experience in technologies and salary structure.
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

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. Why you prefer this job role
Ans. 
I prefer this job role because of the opportunity to work with a variety of clients and industries, utilizing my problem-solving skills.
• Opportunity to work with diverse clients and industries

• Utilizing problem-solving skills

• Enjoy the challenge of finding solutions for different scenarios
Answered by AI
Add your answer
Q2. Good with night shift?
Ans. 
Yes, I am comfortable with night shifts and have experience working during those hours.
• I have previous experience working night shifts in my previous job.

• I am able to adjust my sleep schedule to accommodate working at night.

• I understand the importance of being alert and focused during night shifts.

• I am willing to work night shifts as needed to support the team.
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
Q2. Good with night shift
Add your answer

Q1. Terraform questions related ones
Add your answer
Q2. Devops coding and data engg
Add your answer

Q1. Oops, java , collections basic questions asked
Add your answer

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
Add your answer
Q2. Subcontracting process
Add your answer
Q3. Consignment process
Add your answer

Q1. Salary expectations
Add your answer