Publicis Sapient Senior Associate Interview Questions, Process, and Tips

Question was given to create Api.

Q1. .net core related questions
Add your answer
Q2. Azure related questions
Add your answer

Q1. Behaviour interview
Add your answer

Assignment repeated to GCP , TERRAFORM ,Scripting

Q1. GCP related, scripting
Add your answer
Q2. Terraform, Kubernates
Add your answer

Q1. Flatten a json file
Ans. 
Flatten a JSON file by converting nested objects into a single level structure.
• Use recursion to iterate through the JSON file and flatten nested objects.

• Combine keys from nested objects with parent keys to create unique keys for the flattened structure.

• Handle arrays by converting them into separate objects with numerical keys.
Answered by AI
Add your answer
Q2. SQL query related to ranks nd window function
Add your answer
Q3. Second highest salary for each department
Ans. 
To find the second highest salary for each department, sort the salaries within each department in descending order and select the second highest salary.
• Group the salaries by department

• Sort the salaries within each department in descending order

• Select the second highest salary for each department
Answered by AI
Add your answer

Q1. How to implement DWH n why
Ans. 
A data warehouse (DWH) is implemented to centralize and integrate data from various sources for analysis and reporting purposes.
• DWH helps in improving data quality and consistency by integrating data from multiple sources.

• It provides a single source of truth for decision-making by consolidating data into a unified view.

• DWH enables historical analysis and trend identification by storing large volumes of data over time.

• I...read more
Answered by AI
Add your answer
Q2. Diff between elt vs etl
Ans. 
ELT stands for Extract, Load, Transform while ETL stands for Extract, Transform, Load.
• ELT focuses on extracting data from the source, loading it into a target system, and then transforming it within the target system.

• ETL focuses on extracting data from the source, transforming it, and then loading it into a target system.

• In ELT, the target system has the processing power to handle the transformation tasks.

• In ETL, the t...read more
Answered by AI
Add your answer
Q3. Diff between oltp vs olap
Ans. 
OLTP is a transactional system that handles real-time data processing, while OLAP is an analytical system that deals with historical data analysis.
• OLTP focuses on day-to-day operations and supports high transaction volumes.

• OLAP focuses on complex queries and data analysis for decision-making.

• OLTP databases are normalized for efficient transaction processing.

• OLAP databases are denormalized for faster query performance.

• O...read more
Answered by AI
Add your answer
Q4. Use case to create a DHA
Ans. 
A DHA (Data Handling Application) is created to manage and process data efficiently.
• Identify the data sources and types of data to be handled

• Design a data model and schema for organizing the data

• Implement data collection and storage mechanisms

• Develop data processing algorithms and workflows

• Ensure data security and privacy measures

• Create user-friendly interfaces for data input and retrieval

• Perform regular data quality c...read more
Answered by AI
Add your answer

Problem around NER for NLP

Like they ask to code the react application

About project dicussion