Upload Button Icon Add office photos

Filter interviews by

Object Technology Solutions Senior Data Engineer Interview Questions and Answers

Updated 16 Oct 2024

Object Technology Solutions Senior Data Engineer Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Asking to submit your original document
  • Q2. Not being transparent with the shift timings

Interview Preparation Tips

Interview preparation tips for other job seekers - I have had a worse experience; I got selected but HR Vijayalakshmi and Swathi in OTSI, they were very professional. They were pushing me to submit my original document before releasing offer and forcing to commit.
but after that I got to know shift timings which I was not comfortable with and I said no to them, then they argued very badly, claiming that they have talked about the shift timing 2 months ago. saying words like karma will see you and all, very unprofessional.

Please don't try to even attempt OTSI interview, worse experience of my life in 8 years.

Interview questions from similar companies

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

I applied via Approached by Company and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL problems to solve nth highest salary
  • Ans. 

    Use SQL query with subquery to find nth highest salary

    • Use ORDER BY and LIMIT to get the nth highest salary

    • Use a subquery to exclude the top n-1 salaries before selecting the nth highest salary

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. GCP big query Architecture

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Angular A to Z Hooks,Services,Api Integration,component communication
  • Q2. Html ,CSS basic
Round 2 - Behavioral 

(1 Question)

  • Q1. Server and web api related questions
Round 3 - HR 

(2 Questions)

  • Q1. Can you provide details about yourself and your educational background?
  • Ans. 

    I am a software engineer with a Bachelor's degree in Computer Science and experience in developing web applications.

    • Bachelor's degree in Computer Science

    • Experience in developing web applications

  • Answered by AI
  • Q2. About Winjit technologies

Interview Preparation Tips

Interview preparation tips for other job seekers - Trust the process; ensure a clear understanding of the basics and the logic of object-oriented programming concepts. Wishing you all the best.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral

Round 1 - Coding Test 

Print a specific pattern using any programming language.

Round 2 - One-on-one 

(3 Questions)

  • Q1. What is a class in Object-Oriented Programming (OOP)?
  • Ans. 

    A class in OOP is a blueprint for creating objects, defining their properties and behaviors.

    • Classes are templates for creating objects in OOP

    • They define the properties (attributes) and behaviors (methods) of objects

    • Objects are instances of classes, each with its own unique data

    • Inheritance allows classes to inherit properties and behaviors from other classes

    • Encapsulation ensures that the data is hidden and can only be a...

  • Answered by AI
  • Q2. What is the difference between an abstract class and an interface?
  • Ans. 

    Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.

    • Abstract class can have constructors, fields, and methods, while interface cannot have any implementation.

    • A class can only extend one abstract class, but can implement multiple interfaces.

    • Abstract classes are used to define common characteristics of subclasses, while interfaces are used to define contracts for...

  • Answered by AI
  • Q3. What is joining and creating an inner join query?
  • Ans. 

    Joining is combining data from two or more tables based on a related column, while an inner join query retrieves only the matching records.

    • Joining is used to combine data from multiple tables in a database.

    • Inner join query retrieves only the records that have matching values in both tables.

    • Syntax for inner join: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;

    • Example: SELECT orders.order_i...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Webkul Software Associate Software Engineer interview:
  • OOPS
  • Baisc Of any of Programing
  • MySQL
  • joins
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Starts with a introduction, Core Java concepts, OOPS concepts, Singleton design pattern, Spring boot annotations like service, restcontroller.
  • Q2. DSA logical questions like 2nd highest number. How to find missing number from an array.
Round 2 - Behavioral 

(4 Questions)

  • Q1. Tell me about yourself.
  • Ans. 

    I am a software engineer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.

    • 5 years of experience in software development

    • Proficient in Java, Spring Boot, and Angular

    • Strong problem-solving skills

    • Experience working in Agile development environment

    • Bachelor's degree in Computer Science from XYZ University

  • Answered by AI
  • Q2. Tell me about your family.
  • Ans. 

    I come from a close-knit family of five, including my parents, older sister, and younger brother.

    • Close-knit family of five

    • Parents, older sister, and younger brother

    • We enjoy spending time together traveling and trying new restaurants

  • Answered by AI
  • Q3. Why do you want to change the company
  • Ans. 

    Seeking new challenges and opportunities for growth in a different environment.

    • Desire for new challenges and learning opportunities

    • Seeking a better work-life balance

    • Interested in working with new technologies or industries

    • Looking for a more collaborative team environment

  • Answered by AI
  • Q4. After that interviewer describes my work and position in the company.

Interview Preparation Tips

Interview preparation tips for other job seekers - I have applied for Java position through the referral. I have received a call on Thursday that we want to schedule your interview on Saturday. And on Saturday both the rounds happened with positive feedback.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

There were 30 questions on the aptitude test, all of which were part of the total count.

Round 2 - Coding Test 

I have three questions: two related to data structures and algorithms, and one concerning SQL.

Round 3 - Technical 

(1 Question)

  • Q1. Got two questions DSA medium and Easy one

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep calm and have confidences do your best
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jul 2024.

Round 1 - Coding Test 

Leet code medium level question

Round 2 - Technical 

(2 Questions)

  • Q1. About Java Streams
  • Q2. Restful API coding completion based on given file
Round 3 - HR 

(2 Questions)

  • Q1. To check your attitude
  • Q2. Given detailed about company and what project you are going to work on?
Round 4 - One-on-one 

(5 Questions)

  • Q1. Hashmap working
  • Ans. 

    Hashmap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.

    • Hashmap uses a hashing function to map keys to indices in an array.

    • It allows for constant time complexity O(1) for insertion, deletion, and retrieval operations.

    • Example: HashMap<String, Integer> map = new HashMap<>(); map.put("key", 123); int value = map.get("key");

  • Answered by AI
  • Q2. Multithreading cases
  • Q3. Scenario specific on how to handle multiple events on a single variable to have accurate result
  • Q4. Database indexing
  • Q5. Architecture level
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Springboot notations
  • Q2. How to handle multiple request on springboot
  • Ans. 

    Use thread pooling and asynchronous processing to handle multiple requests efficiently in Spring Boot.

    • Implement thread pooling to manage multiple requests concurrently.

    • Use asynchronous processing to handle requests without blocking the main thread.

    • Consider using reactive programming with Spring WebFlux for better scalability.

    • Optimize database queries and external API calls to reduce response times.

    • Implement caching mec...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Sep 2024.

Round 1 - Coding Test 

I was given a test which was not that difficult

Round 2 - Behavioral 

(2 Questions)

  • Q1. Why are you leaving the current job
  • Ans. 

    Seeking new challenges and growth opportunities in a more innovative environment.

    • Looking for new challenges and opportunities for growth

    • Interested in working in a more innovative environment

    • Seeking a change in company culture or work-life balance

  • Answered by AI
  • Q2. What's the driving factor for you to join Altair
  • Ans. 

    The innovative projects and collaborative work environment at Altair are the driving factors for me to join.

    • Innovative projects: I am excited about the opportunity to work on cutting-edge projects that push the boundaries of technology.

    • Collaborative work environment: I value teamwork and believe that working with talented individuals at Altair will help me grow professionally.

    • Company culture: I have heard great things ...

  • Answered by AI

Data Engineer Interview Questions & Answers

DataMetica user image CSE_A_45_Nidhi Kamboj

posted on 13 Nov 2024

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is Informatica tool
  • Ans. 

    Informatica is a data integration tool used for ETL (Extract, Transform, Load) processes in data engineering.

    • Informatica is used for extracting data from various sources like databases, flat files, etc.

    • It can transform the data according to business rules and load it into a target data warehouse or database.

    • Informatica provides a visual interface for designing ETL workflows and monitoring data integration processes.

    • It ...

  • Answered by AI
  • Q2. What is Datastage tool
  • Ans. 

    Datastage is an ETL tool used for extracting, transforming, and loading data from various sources to a target destination.

    • Datastage is part of the IBM Information Server suite.

    • It provides a graphical interface to design and run data integration jobs.

    • Datastage supports parallel processing for high performance.

    • It can connect to a variety of data sources such as databases, flat files, and web services.

    • Datastage jobs can b...

  • Answered by AI

Skills evaluated in this interview

Object Technology Solutions Interview FAQs

How many rounds are there in Object Technology Solutions Senior Data Engineer interview?
Object Technology Solutions interview process usually has 1 rounds. The most common rounds in the Object Technology Solutions interview process are HR.
How to prepare for Object Technology Solutions Senior Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Object Technology Solutions. The most common topics and skills that interviewers at Object Technology Solutions expect are Big Data, AWS, Hadoop, Hive and NoSQL.
What are the top questions asked in Object Technology Solutions Senior Data Engineer interview?

Some of the top questions asked at the Object Technology Solutions Senior Data Engineer interview -

  1. not being transparent with the shift timi...read more
  2. Asking to submit your original docum...read more

Tell us how to improve this page.

Object Technology Solutions Senior Data Engineer Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Object Technology Solutions Senior Data Engineer Salary
based on 4 salaries
₹19 L/yr - ₹35 L/yr
31% more than the average Senior Data Engineer Salary in India
View more details
Software Engineer
176 salaries
unlock blur

₹3 L/yr - ₹11.5 L/yr

Senior Software Engineer
98 salaries
unlock blur

₹5.6 L/yr - ₹18 L/yr

Associate Software Engineer
94 salaries
unlock blur

₹2 L/yr - ₹5 L/yr

Test Engineer
22 salaries
unlock blur

₹5.1 L/yr - ₹10.4 L/yr

Technical Lead
19 salaries
unlock blur

₹14 L/yr - ₹28 L/yr

Explore more salaries
Compare Object Technology Solutions with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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