Publicis Sapient Interview Questions, Process, and Tips

One question on pysaprk

Q1. Solve the query for the dataset
Add your answer
Q2. Solve it without using spark-sql
Add your answer

Q1. Write a program to print occurrence of character from a given string
Ans. 
Program to print occurrence of characters in a given string
• Create a map to store characters and their counts

• Iterate through the string and update the counts in the map

• Print the characters and their counts from the map
Answered by AI
Add your answer
Q2. Write a program to find sum of any two elements in an array is equal to x?(x=-1)
Ans. 
Program to find sum of any two elements in an array equal to -1
• Iterate through the array and for each element, check if there exists another element whose sum is equal to -1

• Use a hashmap to store the elements and their indices for faster lookup

• Handle edge cases like empty array or array with less than 2 elements

• Example: For array [-2, 3, 5, -3, 8], the pairs (-2, 1) and (3, -3) have sum equal to -1
Answered by AI
Add your answer
Q3. Find xpath for a given element
Ans. 
Use browser developer tools to inspect element and generate xpath
• Inspect element using browser developer tools

• Right click on element and select 'Copy' -> 'Copy XPath'

• Modify generated xpath if needed to make it more robust
Answered by AI
Add your answer

Frontend Show list of data from api using custom hooks

Q1. What Volume of data have you handled in your POCs ?
Ans. 
I have handled terabytes of data in my POCs, including data from various sources and formats.
• Handled terabytes of data in POCs

• Worked with data from various sources and formats

• Used tools like Hadoop, Spark, and SQL for data processing
Answered by AI
View 1 more answer
Q2. When will you decide to use repartition and coalesce?
Ans. 
Repartition is used for increasing partitions for parallelism, while coalesce is used for decreasing partitions to reduce shuffling.
• Repartition is used when there is a need for more partitions to increase parallelism.

• Coalesce is used when there are too many partitions and need to reduce them to avoid shuffling.

• Example: Repartition can be used before a join operation to evenly distribute data across partitions for bette...read more
Answered by AI
Add your answer
Q3. How will you design/configure a cluster if you have given 10 petabytes of data.
Ans. 
Designing/configuring a cluster for 10 petabytes of data involves considerations for storage capacity, processing power, network bandwidth, and fault tolerance.
• Consider using a distributed file system like HDFS or object storage like Amazon S3 to store and manage the large volume of data.

• Implement a scalable processing framework like Apache Spark or Hadoop to efficiently process and analyze the data in parallel.

• Utilize...read more
Answered by AI
Add your answer

Q1. How do you handle work-related pressure?
Ans. 
I manage work-related pressure by prioritizing tasks, maintaining open communication, and practicing stress-relief techniques.
• Prioritize tasks: I create a daily to-do list to focus on urgent tasks first, ensuring deadlines are met.

• Open communication: I regularly check in with my team to discuss workloads and share concerns, fostering a supportive environment.

• Stress-relief techniques: I practice mindfulness and take sho...read more
Answered by AI
Add your answer
Q2. What are your career aspirations?
Ans. 
I aspire to grow in Compensation and Benefits, enhancing employee satisfaction and driving organizational success through strategic initiatives.
• Aim to become a Compensation and Benefits Manager, leading innovative programs that attract and retain top talent.

• Desire to specialize in data analytics to assess compensation trends and improve decision-making processes.

• Plan to pursue certifications like Certified Compensation...read more
Answered by AI
Add your answer

Logical test and problem-solving test.

Q1. .NET stack related MCQ test
Add your answer

Asked to create WebAPI with all CRUD operations with some use case

Q1. Technical interview L1
Add your answer

Q1. Technical interview L2
Add your answer

Q1. Managerial interview questions
Add your answer
Q2. Questions asked were tricky to check your thoughts and communications
Add your answer