Publicis Sapient Interview Questions, Process, and Tips

Coding test on Pyspark and SQL

Q1. Optimization on spark
Ans. 
Optimizing Spark involves tuning configurations, partitioning data, using efficient transformations, and caching intermediate results.
• Tune Spark configurations for optimal performance

• Partition data to distribute workload evenly

• Use efficient transformations like map, filter, and reduce

• Cache intermediate results to avoid recomputation
Answered by AI
Add your answer
Q2. Azure services experience
Ans. 
I have extensive experience working with various Azure services such as Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Blob Storage.
• Experience with Azure Data Factory for ETL processes

• Proficiency in using Azure Databricks for big data processing

• Knowledge of Azure SQL Database for data storage and querying

• Familiarity with Azure Blob Storage for storing unstructured data
Answered by AI
Add your answer

It was fine, not very difficult

Was detailed. I was asked to prepare a ppt for RFP.

Q1. Why did i choose a particular method for my project timekines
Ans. 
I chose a particular method for my project timelines based on its proven effectiveness and alignment with project goals.
• I selected the method because it had been successfully used in similar projects before

• The method was recommended by industry experts as best practice

• The method allowed for clear tracking of progress and milestones

• The method was cost-effective and efficient for the project's scope
Answered by AI
Add your answer
Q2. MVP timelines in the larger project schedule
Add your answer

Q1. Agile and waterfall difference
Ans. 
Agile is iterative and flexible, while waterfall is sequential and rigid.
• Agile involves breaking projects into smaller tasks and adapting to changes quickly.

• Waterfall follows a linear approach with distinct phases like planning, design, development, testing, and deployment.

• Agile is more suitable for projects with evolving requirements, while waterfall is better for projects with fixed requirements.

• Agile promotes collab...read more
Answered by AI
Add your answer

Q1. Key business risks in recent project
Ans. 
Key business risks in recent project include budget overruns, scope creep, resource constraints, and stakeholder conflicts.
• Budget overruns can lead to financial losses and impact project timelines.

• Scope creep may result in project delays and increased costs.

• Resource constraints can hinder project progress and quality of deliverables.

• Stakeholder conflicts can lead to communication breakdowns and project failure.
Answered by AI
Add your answer

Q1. Testing related questions
Add your answer
Q2. Automation questions
Add your answer

DSA questions related to Array and Linked list

Q1. Sematic elements in HTML? What is Sass, SCSS, LESS and more about CSS? Design a HTML form? Test cases in javascript How you will implement security on a banking website.
Ans. 
Semantic elements in HTML are used to give meaning to the content, making it more accessible and SEO-friendly.
• Semantic elements like <header>, <footer>, <nav>, <article>, <section>, <aside>, <main>, <figure>, <figcaption>, <details>, <summary>, etc., provide structure and meaning to the content.

• They help search engines understand the content better, impr...read more
Answered by AI
Add your answer

Q1. All core questions about java8 ,java,spring ,database,kafka,rabbitmq,datastructure, singleton,coding questions . Questions like how java adopted stream.. what is internally done to adopt collection to st...read more
Add your answer

Code test which i hd not attended