SD Global Services Senior Software Engineer Interview Questions and Answers

Duration was 1 hour, Topics covered were DSA, Concurrency in golang, Databse questions

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Q1. 30 minutes of discussion.
Add your answer

Q1. 75 minutes of discussion
Add your answer

Q1. SQL query to join 3 tables
Ans. 
Use SQL JOIN to combine data from 3 tables based on a common key.
• Use INNER JOIN, LEFT JOIN, or RIGHT JOIN depending on the desired result

• Specify the columns to select from each table

• Use ON clause to specify the join condition
Answered by AI
Add your answer
Q2. Spring boot annotations
Add your answer
Q3. Hibernate annotations
Add your answer
Q4. Java 8 Streams + Lambda
Add your answer

Q1. Working style: Independent contributor or Team
Add your answer
Q2. Are green-field projects alright?
Ans. 
Green-field projects are great opportunities to start fresh and implement new technologies.
• Green-field projects allow for creative freedom and innovation

• They provide the opportunity to work with the latest technologies and tools

• Starting from scratch can lead to cleaner code and better architecture

• Examples: Developing a new mobile app, creating a new website from scratch
Answered by AI
Add your answer
Q3. Are you ok with learning new tech stacks?
Add your answer

Q1. Sql question, joins , store procedure
Add your answer
Q2. Mvc question, mvc frame work
Add your answer

Group discussion is very important thing.

Q1. HR round is very easy.
Add your answer
Q2. Just hard and smart work for.
Add your answer
Q3. What is requirement.
Ans. 
A requirement is a specific need or expectation that must be met in order to achieve a desired outcome.
• A requirement is a statement of what a product or service must do or how it must perform.

• Requirements can be functional (what the product must do) or non-functional (how well it must do it).

• Requirements should be clear, concise, and measurable.

• Examples of requirements include: the ability to save and retrieve data, a ...read more
Answered by AI
Add your answer
Q4. What is your strength.
Ans. 
My strength is problem-solving and analytical thinking.
• I have a strong ability to analyze complex problems and break them down into manageable components.

• I excel at finding innovative solutions and thinking outside the box.

• I am skilled in debugging and troubleshooting software issues.

• I have a solid understanding of algorithms and data structures.

• I am experienced in optimizing code for performance and efficiency.
Answered by AI
Add your answer
Q5. What is your weekness.
Ans. 
My weakness is that I tend to be too detail-oriented, which can sometimes slow down my progress.
• I have a tendency to get caught up in the small details and can spend too much time on them.

• I often find myself double-checking my work to ensure accuracy.

• I sometimes struggle with prioritizing tasks because I want to make sure everything is perfect.

• I am actively working on improving my time management skills to balance atte
Answered by AI
Add your answer

Q1. What is dependency injection in laravel
Ans. 
Dependency injection in Laravel is a technique to manage class dependencies and improve code flexibility.
• Dependency injection allows for easier testing and maintenance of code.

• It involves passing dependencies to a class through its constructor or method parameters.

• Laravel's container class manages the dependencies and resolves them when needed.

• Example: injecting a database connection into a repository class.

• Can also us...read more
Answered by AI
View 1 more amswer
Q2. How do you find the second largest number in a coulmn in mySQL
Ans. 
To find the second largest number in a column in MySQL, you can use the ORDER BY and LIMIT clauses.
• Write a SELECT statement to retrieve the column values in descending order using ORDER BY.

• Use the LIMIT clause to limit the result set to the second row.

• The value in the second row will be the second largest number in the column.
Answered by AI
View 1 more amswer

Q1. What do you know about magic Edtech
Ans. 
Magic Edtech is an innovative educational technology company.
• Magic Edtech develops interactive learning platforms and tools.

• They use advanced technologies like AI, AR, and VR to enhance the learning experience.

• Their products include virtual classrooms, adaptive learning systems, and educational games.

• Magic Edtech focuses on personalized learning and data-driven insights.

• They collaborate with schools, universities, and
Answered by AI
View 1 more amswer
Q2. What was the most challenging task you faced and how you overcame it
Add your answer