Publicis Sapient Interview Questions, Process, and Tips

Q1. Explain architecture of your project
Add your answer
Q2. Some questions on Java, Spring Boot and sql
Add your answer

Q1. Project flow and some behavioural questions
Add your answer
Q2. Project contribution of yours
Ans. 
Developed a web application for tracking employee attendance and performance
• Implemented user authentication and authorization using Spring Security

• Utilized Hibernate for database interaction and data persistence

• Designed and developed RESTful APIs for frontend integration

• Used AngularJS for frontend development to create interactive user interfaces
Answered by AI
Add your answer

Q1. Basic formalities before offer release
Add your answer

If is purely coding language related mcq test

Leet code low to medium level problem.

Q1. How does azure durable functions
Add your answer
Q2. Tells us about recent design pattern you used and why it was chosen
Add your answer

Q1. Personal information
Add your answer
Q2. Expectations and Expected earliest date of joining
Add your answer

Q1. Coding, selenium, testNG questions
Add your answer
Q2. Wap to find char icc. Only once in a string
Add your answer
Q3. Wap to print sum of integers in a string
Add your answer

It was a concept and coding test, with MCQs. Very simple and straightforward.

Q1. Talk about SOLID Principles
Ans. 
SOLID principles are a set of five design principles in object-oriented programming to make software designs more understandable, flexible, and maintainable.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open/Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Objects of a superclass should be replaceable...read more
Answered by AI
Add your answer
Q2. Design pattern that you have used.
Ans. 
I have used the Singleton design pattern in my previous projects.
• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• It is useful when you want to control the number of instances that can be created.

• Example: Creating a Logger class that should have only one instance throughout the application.
Answered by AI
Add your answer
Q3. Talk about Concurrent API
Ans. 
Concurrent API allows multiple tasks to be executed simultaneously, improving efficiency and performance.
• Concurrent API enables parallel processing of multiple requests at the same time.

• It helps in reducing latency and improving overall system performance.

• Examples include Java's CompletableFuture class for asynchronous programming and Node.js's cluster module for parallel processing.
Answered by AI
Add your answer

Create scenario-based questions that challenge you to utilize all of your coding skills.

Q1. Explain the architect of your current project Multi threaded based questions Collection based questions Design pattern based questions Microservice architect based questions AWS cloud based questions
Add your answer
Q2. How to handle security in api.
Ans. 
Security in APIs is crucial for protecting sensitive data and preventing unauthorized access.
• Use authentication methods such as OAuth or API keys to verify the identity of users accessing the API.

• Implement encryption to secure data transmission between clients and servers.

• Set up rate limiting to prevent abuse and protect against denial of service attacks.

• Regularly update and patch the API to address security vulnerabil...read more
Answered by AI
Add your answer

A coding test on Codility that includes multiple-choice questions and two coding problems.

I was asked to implement a web page in Angular with server-side rendering.

Q1. What is the explanation of the coding exercise and the associated unit tests?
Ans. 
The coding exercise involves implementing a specific feature or functionality and writing unit tests to ensure its correctness.
• Explain the purpose of the coding exercise and what is expected to be implemented.

• Describe the approach taken to solve the problem and any challenges faced during implementation.

• Discuss the design decisions made and how they impact the overall code quality.

• Explain the unit tests written to vali...read more
Answered by AI
Add your answer

Q1. Other projects, experience with other projects
Add your answer

Platform - Hackerank
Duration - 2 Hours
Topics - Spark and SQL

Q1. What are the common file formats used in data storages? Which one is best for compression?
Ans. 
Common file formats used in data storages include CSV, JSON, Parquet, Avro, and ORC. Parquet is best for compression.
• CSV (Comma-Separated Values) - simple and widely used, but not efficient for large datasets

• JSON (JavaScript Object Notation) - human-readable and easy to parse, but can be inefficient for storage

• Parquet - columnar storage format that is highly efficient for compression and query performance

• Avro - efficie...read more
Answered by AI
Add your answer
Q2. SQL Problem - Given the empoyee attendance table, write a query to print the employees who is abscent for more than cosecutive 10 days in their tenure.
Add your answer
Q3. Given the list of words, write the Python program to print the most repeating substring out of all words.
Ans. 
Python program to find the most repeating substring in a list of words.
• Iterate through each word in the list

• Generate all possible substrings for each word

• Count the occurrences of each substring using a dictionary

• Find the substring with the highest count
Answered by AI
Add your answer