Upload Button Icon Add office photos

Filter interviews by

SDCS Senior Technical Lead Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. How will you optimize the performance while reading a huge file with more than 100 columns and 1 lac rows?
  • Ans. 

    Use efficient file reading techniques like memory mapping, parallel processing, and columnar storage.

    • Utilize memory mapping to directly access file data without loading it into memory

    • Implement parallel processing to read and process data concurrently for faster performance

    • Consider using columnar storage to optimize data retrieval for specific columns

    • Use appropriate data structures and algorithms for efficient data proc

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared thoroughly with your resume, share your success stories and prepare for scenario based question and answers

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Spring Boot Multiple datasource setup?
  • Ans. 

    Spring Boot allows setting up multiple data sources for database connectivity.

    • Define multiple data source configurations in application.properties or application.yml

    • Create separate DataSource beans for each data source

    • Use @Primary annotation to specify the primary data source

    • Use @Qualifier annotation to specify the data source for specific repositories or services

    • Configure JPA or JDBC templates for each data source

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
Less than 2 weeks
Result
-

I applied via Company Website and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is the difference between JPA repository and CRUD repository?
  • Ans. 

    JPA repository is a standard interface provided by Spring Data for generic CRUD operations, while CRUD repository is a sub-interface of JPA repository with additional CRUD methods.

    • JPA repository is a high-level abstraction that provides methods for common database operations like save, delete, findById, etc.

    • CRUD repository extends JPA repository and adds additional methods like findAll, deleteAll, count, existsById, et...

  • Answered by AI

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic Aptitude Questions like Maths Time Work

Round 2 - Coding Test 

Basic DSA and OOPS questions were asked

Interview Preparation Tips

Topics to prepare for Xyz Company Technical Consultant interview:
  • DSA
  • Java
  • OOPS
Interview preparation tips for other job seekers - Do a grasp on at least one programming language like Java
Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Asked questions on multithreading and deadlocks. Data flow between components in React - Parent to Child and vice versa. State management techniques in React. Life Cycle methods. HTML DOC and related ta...
Round 2 - HR 

(1 Question)

  • Q1. General discussion on current CTC and Expected CTC.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Magento migration
Round 2 - Technical 

(1 Question)

  • Q1. Adobe commerce cloud
Round 3 - HR 

(1 Question)

  • Q1. Reason for job change
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Company Website and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Coding Test 

2 hours coding round with 3 sections
1st being mcq aptidute+coding question 20 mins were given for this section and 20 questions were there in this section

2nd section consisted of 8 questions where we had to do the error correction in the given code 20 mins were also given for this section

3rd section consisted of 2 coding problems 20 mins were given for each one was a dp and one was a segment tree question

I was able to do everything correctly and was selected for the first interview round

Round 2 - Technical 

(1 Question)

  • Q1. Firstly they asked me to Tell me about myself Then a little bit about my projects Then 3 coding questions were ASKED 1st was a really recursion problem 2nd was a dp problem specifically a generic problem ...
Round 3 - HR 

(4 Questions)

  • Q1. Why do you want to join the company
  • Q2. Tell me what do you know about the company
  • Q3. Then I was asked about my project and cross questioned on it
  • Q4. Then i was asked about a system design question (since I didn't study about it I tanked here :))

Interview Preparation Tips

Topics to prepare for Morgan Stanley Technical Analyst interview:
  • System Design
Interview preparation tips for other job seekers - Basically I the hr round I was asked everything from my resume except system design

I applied via Company Website and was interviewed in Oct 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. Questions on office 365 administration Scenario based questions Desktop support and troubleshooting
  • Q2. Questions on past experience
  • Q3. Questions on mail forwarding,shared mailbox.DL

Interview Preparation Tips

Topics to prepare for BNY Senior Technical Analyst interview:
  • Office 365
  • Active directory
  • iTIs
  • Service desk management
  • Desktop Support
  • Citrix
Interview preparation tips for other job seekers - Interview questions are average
Totaly 5 rounds
Be prepared with your resume
They ask questions from you resume
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before May 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Projects on resume , basic dsa, real life example fo data struct, oops . procedure - pl /sql
Round 3 - HR 

(1 Question)

  • Q1. Family backgroudn , hobbies , general discussion

I was interviewed in Apr 2021.

Interview Questionnaire 

1 Question

  • Q1. Asked to explain my blockchain project, reverse a doubly link list, some puzzles, coding questions based on dp.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview experience was good. One of the interviewer was amazing.

Tell us how to improve this page.

Interview Questions from Similar Companies

Citicorp Interview Questions
3.7
 • 562 Interviews
Wells Fargo Interview Questions
3.9
 • 560 Interviews
Bajaj Finserv Interview Questions
4.0
 • 504 Interviews
HSBC Group Interview Questions
4.0
 • 490 Interviews
Xyz Company Interview Questions
3.8
 • 455 Interviews
American Express Interview Questions
4.2
 • 360 Interviews
UBS Interview Questions
4.0
 • 337 Interviews
BNY Interview Questions
3.9
 • 334 Interviews
Morgan Stanley Interview Questions
3.7
 • 305 Interviews
View all
Compare SDCS with

JPMorgan Chase & Co.

4.0
Compare

Wells Fargo

3.9
Compare

HSBC Group

4.0
Compare

UBS

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview