Publicis Sapient Interview Questions, Process, and Tips

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.
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

Q1. Thread questions
Add your answer
Q2. Design patterns
Add your answer

Q1. LLD Design of any popular ecommerce
Add your answer
Q2. HLD Design of any popular ecommerce
Add your answer

Q1. How to Ensure Data loss in ETL pipeline
Add your answer
Q2. Why to spin up Dataproc cluster when there is serverless batch job exists.
Add your answer