Sutherland Global Services Associate Technical Consultant Interview Questions and Answers for Experienced

Hacker Rank test, problem solving. Java 8

Q1. Java 8 feature related questions.
Add your answer
Q2. Jvm architecture and memory management
Add your answer
Q3. Sql self join query and query tuning
Add your answer
Q4. Spring boot microservices design pattern discussion
Add your answer

Q1. Problem solving based on java and case study
Add your answer
Q2. Team handling and management skills
Add your answer
Q3. Docker and Orchetratetion framework
Add your answer
Q4. Aws cloud and cicd and related technologies
Add your answer

Q1. Questions about Interfaces,, Abstract Classes, Multi-Threading, Parallel Programming concepts, SQL Server
Add your answer

Q1. Questions about Design Patterns, SOLID Principles, Extension Methods, LINQ, Entity Framework
Add your answer

Q1. Questions about current project and my roles and responsibilities, my salary structure, my aspirations whether I want to be Architect or just Team Lead.
Add your answer

Q1. My CTC and ECTC, and asked for negotiation, to which I said yes and accepted the compensation they can offer to me. But still offer letter not released without giving any reason.
Add your answer

Q1. Sql queries join and left join
Add your answer

Q1. Introduce yourself
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

Q1. SOA vs Micro Service
Ans. 
SOA focuses on large, monolithic services while Microservices are small, independent services.
• SOA is a centralized architecture with shared services, while Microservices are decentralized with each service having its own database.

• SOA is typically implemented using ESB (Enterprise Service Bus), while Microservices communicate via lightweight protocols like HTTP or messaging queues.

• SOA is more suitable for large enterpri...read more
Answered by AI
Add your answer

Round robin base in os schedule