Cummins Data Engineer Interview Questions and Answers

Q1. It was an algorithm question which I had to code in 30 minutes
Add your answer
Q2. Java/Spring related questions were asked
Add your answer

They asked me about my current project and asked me to design a system similar to that

Q1. Why we should select you
Add your answer
Q2. What are your qualifications
Add your answer
Q3. Tell me something about us
Add your answer
Q4. Howyoun are good than othes
Add your answer

Q1. Introduce yourself?
Add your answer
Q2. Tell me about your projects
Add your answer

Q1. What is polymorphism in OOPS
Ans. 
Polymorphism in OOPS refers to the ability of a single function or method to operate on different types of data.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

• Example: Inheritance allows a child class to override a method of its parent class, providing different implem
Answered by AI
Add your answer
Q2. How SQL Performance Can Be Optimized
Ans. 
SQL performance can be optimized by using indexes, optimizing queries, minimizing network round trips, and using proper data types.
• Use indexes on columns frequently used in WHERE clauses to speed up data retrieval.

• Optimize queries by avoiding unnecessary joins, using WHERE clauses effectively, and limiting the number of rows returned.

• Minimize network round trips by batching multiple queries into a single request.

• Use pr...read more
Answered by AI
Add your answer

Q1. Salary Expectation as per Your Role
Ans. 
My salary expectation as a Senior Software Engineer is based on industry standards, my experience, and the responsibilities of the role.
• Research industry standards for Senior Software Engineer salaries

• Consider my years of experience and expertise in software development

• Factor in the specific responsibilities and requirements of the role

• Negotiate based on the company's budget and benefits package

• Be open to discussing sa
Answered by AI
Add your answer
Q2. How will manage If you see the application is crashed
Ans. 
I will investigate the root cause, analyze logs, and work on fixing the issue to prevent future crashes.
• Investigate the crash logs to identify the root cause

• Analyze the code to understand the issue

• Implement a fix for the crash

• Test the fix thoroughly before deploying it

• Implement monitoring and alerting to catch similar issues in the future
Answered by AI
Add your answer

It was about to 30 min.

It was about to 15 min.

Q1. All questions related to our technical part.
Add your answer

Q1. About your self
Add your answer

Q1. What is ETL ?
Ans. 
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database.
• Extract: Data is extracted from different sources such as databases, files, APIs, etc.

• Transform: Data is cleaned, validated, and transformed into a consistent format suitable for analysis.

• Load: The transformed data is loaded into a target database ...read more
Answered by AI
Add your answer

Q1. HR reached out to me through naukri. Based on my tech stack i matched the requirements. On the first call HR asked me a lot of the questions on why i was looking out for a change, what kind of work have i ...read more
Add your answer

Q1. Write a program to find last non repeating character in a given string using Java 8 functions only like Streams and Lambda's.
Ans. 
Program to find last non-repeating character in a given string using Java 8 functions only.
• Use Java 8 Streams and Lambda's to filter the string and find the last non-repeating character.

• Create a Map to store the frequency of each character in the string.

• Use the filter() method to get the non-repeating characters and find the last one using reduce().
Answered by AI
Add your answer
Q2. Given two interface, Interface A and Interface B both having the same functions in them let's say apply(). If a class implements both of these interface then which function will get implemented?
Add your answer
Q3. Given a employee table with name, ID, age, salary and ratings column. Find the top 3 employee based on the ratings.
Ans. 
Find the top 3 employees based on ratings in an employee table.
• Sort the employee table based on ratings in descending order.

• Select the top 3 employees from the sorted table.

• Return the selected employees as the result.
Answered by AI
Add your answer
Q4. Group anagram coding question.
Add your answer
Q5. Given an Employee class with 3 fields name, age and salary. Make changes in the class so that any two employee objects having same names are considered duplicates.

Ans. 

Modify Employee class to consider objects with same names as duplicates.

• Add a static HashSet to keep track of unique names.

• Override equals() and hashCode() methods to compare names.

• In the constructor, check if the name already exists in the HashSet and mark it as duplicate if true.

Add your answer