Publicis Sapient Senior Technical Lead Interview Questions and Answers

Basic question on general aptitude like percentage, train and speed, dates, reasoning

Leetcode medium problem on string and easy problem on array sorting

Q1. Behavioral question like why you want to changes etc etc
Add your answer

Q1. Related to profiles
Add your answer
Q2. Related to job profile
Add your answer

Q1. Salary and type of job
Add your answer

Q1. Related your past experience
Add your answer

Q1. Long running queries Blockings Backup Index HADR
Add your answer

Q1. Data center migrations AG FLEXIBLE SHIFTS
Add your answer

Q1. Package discussion Location Any offer
Add your answer

Q1. It was technical questions in relevant area
Add your answer
Q2. The questions relevant to my skill set and experience
Add your answer

Q1. The questions relevant to my skills and experience
Add your answer
Q2. The questions relevant to job requirements
Add your answer

Q1. General discussion about the profession and career
Add your answer
Q2. Discussed job location and client
Add your answer

Q1. Discussed about client and company
Add your answer
Q2. Orientation related things discussed.
Add your answer

Q1. Fake Interview, Didn't expect this from virtusa
Add your answer
Q2. FakeInterviews conducted, Didn;t expect this from virtusa
Add your answer
Q3. Virtusa Scammers
Add your answer

Q1. Describe 5 non functional requirements
Ans. 
Non functional requirements are criteria that specify how a system should behave, rather than what it should do.
• Performance - system should respond within 2 seconds for all user interactions

• Scalability - system should be able to handle 1000 concurrent users

• Reliability - system should have a 99.99% uptime

• Security - system should encrypt all sensitive data

• Usability - system should have a user-friendly interface
Answered by AI
Add your answer
Q2. How will you improve performance of legacy app which has to work with your latest microservice.
Ans. 
Improve legacy app performance by optimizing code, implementing caching, and scaling resources.
• Optimize code by identifying and removing bottlenecks

• Implement caching to reduce database calls and improve response time

• Scale resources by using containers or serverless architecture

• Use asynchronous processing for long-running tasks

• Upgrade hardware or infrastructure if necessary
Answered by AI
Add your answer

Q1. Explain security in microservices
Ans. 
Security in microservices involves implementing authentication, authorization, encryption, and monitoring to protect data and services.
• Implement authentication and authorization mechanisms to control access to microservices.

• Use encryption to secure communication between microservices and external clients.

• Implement monitoring and logging to detect and respond to security incidents.

• Consider using API gateways for central...read more
Answered by AI
Add your answer
Q2. Describe microservices architecture for a wealth management app
Ans. 
Microservices architecture for a wealth management app involves breaking down the application into smaller, independent services.
• Each microservice focuses on a specific business function, such as client onboarding, portfolio management, or reporting.

• Services communicate through APIs, allowing for flexibility and scalability.

• Each microservice can be developed, deployed, and scaled independently, leading to faster develo...read more
Answered by AI
Add your answer

Q1. Delete vs Drop in sql?
Ans. 
DELETE is used to remove rows from a table while keeping the table structure intact. DROP is used to remove an entire table from the database.
• DELETE is a DML (Data Manipulation Language) command, while DROP is a DDL (Data Definition Language) command.

• DELETE can be rolled back, while DROP cannot be rolled back.

• Example: DELETE FROM table_name WHERE condition; DROP TABLE table_name;
Answered by AI
Add your answer
Q2. Autocalender, duicate vs refrence in power bi
Ans. 
Autocalender creates a date table automatically, while duplicate creates a copy of a table and reference creates a linked table in Power BI.
• Autocalender automatically generates a date table based on the data in your model.

• Duplicate creates a copy of a table with the same data and structure.

• Reference creates a linked table that shares the same data as the original table.

• Autocalender is useful for quickly creating date t...read more
Answered by AI
Add your answer