AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Dataseers Technologies Data Engineer Interview Questions and Answers
Dataseers Technologies Data Engineer Interview Experiences
1 interview found
Anonymous
(2 Questions)
- Q1. What are the joins in sql
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the righ...
- Q2. Project related information
(2 Questions)
- Q1. They give you sql sum to solve
- Q2. Basic question about sql
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I was interviewed in Jun 2017.
Interview Questionnaire
12 Questions
- Q1. Write the annotation for controller?
- Ans.
An annotation for controller in software engineering.
The annotation for controller is used to define the class as a controller in a software application.
It is typically used in frameworks like Spring MVC or ASP.NET MVC.
The annotation helps in mapping the incoming requests to the appropriate controller methods.
It can also be used to specify the URL path for the controller.
Example: @Controller in Spring MVC, [ApiControll
- Q2. Write the annotation for request mapping?
- Ans.
The annotation for request mapping is used to map HTTP requests to specific methods in a controller class.
The annotation is @RequestMapping
It can be used at the class level to specify a common base URL for all methods in the class
It can also be used at the method level to specify the URL path and HTTP method for a specific method
Additional attributes can be used to further customize the mapping, such as specifying requ...
- Q3. What is front controller from context in spring mvc?
- Ans.
Front controller is a design pattern used in Spring MVC to handle incoming requests and route them to appropriate handlers.
Front controller acts as a central point of control for handling requests in Spring MVC.
It receives all incoming requests and delegates them to appropriate handlers called controllers.
Front controller provides a consistent way to handle requests and perform common tasks like authentication, logging...
- Q4. Write the css box model?
- Ans.
The CSS box model describes the layout and sizing of elements on a web page.
The box model consists of content, padding, border, and margin.
Content refers to the actual content of the element, such as text or images.
Padding is the space between the content and the border.
Border is a line that surrounds the padding and content.
Margin is the space outside the border, separating the element from other elements.
The width an...
- Q5. Select all div using jquery
- Ans.
Select all div using jQuery
Use the jQuery selector $('div') to select all div elements
This will return a jQuery object containing all the selected div elements
You can then perform operations on the selected div elements using jQuery methods
- Q6. Change all ul element to blue background color using jquery
- Ans.
Use jQuery to change the background color of all ul elements to blue.
Use the jQuery selector to select all ul elements
Use the css() method to change the background color to blue
- Q7. Change first li element to yellow background color using jquery
- Ans.
Use jQuery to change the background color of the first li element to yellow.
Use the :first-child selector to select the first li element
Use the css() method to change the background color to yellow
- Q8. Output of this var arr=[1,2,3,4,5] arr.push(6) arr.unshift(1) arr.pop() arr.shift()
- Ans.
The output of the given code is [1, 2, 3, 4, 5, 6].
The 'push' method adds an element to the end of the array.
The 'unshift' method adds an element to the beginning of the array.
The 'pop' method removes the last element from the array.
The 'shift' method removes the first element from the array.
- Q9. What are the uses of final in java
- Ans.
The 'final' keyword in Java is used to declare constants, prevent method overriding, and ensure thread safety.
Final variables cannot be reassigned once initialized
Final methods cannot be overridden by subclasses
Final classes cannot be extended by other classes
Final parameters ensure that they cannot be modified within a method
Final fields can be used to achieve thread safety
- Q10. Public static void getsum(int a,int b){System.out.println("a b method");}public static void getsum(int a,int b,int c){System.out.println("a b c method");}public static void getsum(int a,int ...b){System.o...
- Ans.
The question is about method overloading in Java.
Method overloading allows multiple methods with the same name but different parameters.
The method to be called is determined at compile-time based on the arguments passed.
In the given code, there are three overloaded methods with the same name 'getsum'.
The first method takes two integers as arguments.
The second method takes three integers as arguments.
The third method ta...
- Q11. Output of this program public static int floating(int x){ return x*floating(x-1); } public static void main(String[] args){ floating(10); }
- Ans.
The program will result in a StackOverflowError due to infinite recursion.
The 'floating' method is recursively calling itself without a base case to stop the recursion.
Each recursive call multiplies the input parameter by the result of the recursive call with a decremented parameter.
This will continue indefinitely until the stack overflows and an error is thrown.
- Q12. What is the output of this int i=0; int j=10;do{ if(i++ < --j){ } }while(i
- Ans.
The output of the code is 9.
The code initializes i as 0 and j as 10.
Inside the do-while loop, i is incremented by 1 and j is decremented by 1.
The loop continues until i becomes greater than or equal to j.
Since i is incremented before the comparison and j is decremented before the comparison, the loop runs 9 times.
Therefore, the output is 9.
Interview Preparation Tips
Skills evaluated in this interview
I was interviewed before Apr 2021.
(3 Questions)
Round duration - 60 minutes
Round difficulty - Easy
Technical Interview round with questions on CSS and Jquery mainly.
- Q1. What is the CSS box model?
- Ans.
The CSS box model is a design and layout concept that defines the structure and sizing of elements on a web page.
It consists of content, padding, border, and margin around an element.
Content area is where text and images are displayed.
Padding is the space between the content and the border.
Border is the line that goes around the padding and content.
Margin is the space outside the border.
Example: div { width: 200px; pad...
- Q2. How do you select all div elements using jQuery?
- Ans.
To select all div elements using jQuery, use the selector $('div').
Use the jQuery selector $('div') to select all div elements on the page.
You can also use the find() method to select div elements within a specific parent element.
To perform actions on the selected div elements, use jQuery methods like css(), text(), or addClass().
- Q3. How can you change the background color of all items in JavaScript?
- Ans.
You can change the background color of all items in JavaScript by selecting all elements and setting their background color property.
Select all elements using document.querySelectorAll()
Loop through the selected elements and set their style.backgroundColor property
Example: document.querySelectorAll('.item').forEach(item => item.style.backgroundColor = 'blue');
(4 Questions)
Round duration - 60 minutes
Round difficulty - Easy
Technical Interview round with questions on Java mainly.
- Q1. What are the uses of the final keyword in Java?
- Ans.
The final keyword in Java is used to define constants, prevent method overriding, and make a class immutable.
Final variables cannot be reassigned once initialized
Final methods cannot be overridden in subclasses
Final classes cannot be extended
- Q2. What is the Front Controller in Spring MVC?
- Ans.
Front Controller in Spring MVC is a design pattern that handles all requests and acts as a central point of control.
Front Controller is a servlet in Spring MVC that receives all requests and then dispatches them to the appropriate handlers.
It helps in centralizing request handling logic, improving code organization and reducing duplication.
Front Controller can perform tasks like authentication, logging, exception handl...
- Q3. What is the annotation for request mapping in Java?
- Ans.
The annotation for request mapping in Java is @RequestMapping.
@RequestMapping annotation is used to map web requests to specific handler methods in Spring MVC.
It can be applied at class level or method level to specify the URL path that the controller will handle.
You can also specify HTTP request methods, headers, parameters, and more using @RequestMapping.
- Q4. What is the annotation used for a controller in Java?
- Ans.
The annotation used for a controller in Java is @RestController.
Used to define a class as a controller in Spring MVC
Automatically serializes return objects into JSON/XML responses
Equivalent to @Controller + @ResponseBody annotations
Round duration - 30 minutes
Round difficulty - Easy
This was a typical HR round.
Interview Preparation Tips
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
Interview Preparation Tips
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40
Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.
Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.
Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P
General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore
I was interviewed in Mar 2017.
Interview Questionnaire
1 Question
- Q1. Views on their recruiting process
- Ans.
I believe the recruiting process is thorough and well-organized.
The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.
They have a clear timeline for the hiring process and keep candidates informed of their progress.
Feedback is provided to candidates after interviews to help them improve for future opportunities.
Interview Preparation Tips
Experience:
Software Engineer Interview Questions & Answers
Fractal Analytics
Saksham sharma
posted on 22 Sep 2023
Coding testing with 15 questions MCQ based
(1 Question)
- Q1. 1 or 2 DSA questions, rest tech stack related questions were asked
(1 Question)
- Q1. This was a technofunctional round, kind of a managerial round.
(1 Question)
- Q1. This was a HR round
Selected
I applied via Job Fair and was interviewed before Feb 2023. There were 3 interview rounds.
1 hour, 2 coding and 20 MCQs
(1 Question)
- Q1. 1 hour deep discussion on data engineering
(1 Question)
- Q1. Salary discussion, company policies etc
Interview Preparation Tips
(1 Question)
- Q1. Reg BW and ABAP and XSA
(1 Question)
- Q1. Reg sap BW and ABAP and XSA
(1 Question)
- Q1. Company structure
(1 Question)
- Q1. Basic SQL questions and Window fuctions
(1 Question)
- Q1. HR asked how was the interview last round and gave me feedback
Interview Preparation Tips
In fact interviewer turned camera off several times between and missed responding for a few seconds.
He even didn't tell me to share screen to see what I code.
Totally not serious about the interview..
Data Engineer Interview Questions & Answers
Fractal Analytics
Billuri Tejaswini
posted on 6 Jan 2024
Selected
I applied via Campus Placement and was interviewed before Jan 2023. There were 4 interview rounds.
Aptitude test has 70 questions to be done in 75 minutes. It's moderately tough but not very tough with right amount of preparation
I was from non-cs background so coding round was not mandatory but for cs people it was mandatory to clear it. It has SQL and python and they were easy to moderate. I am a fresher (imagineer) so we had to go this interview process
(1 Question)
- Q1. The interviewer was really nice and that went so smooth for me. 1. Asked questions from IC Engines and stuff 😄, as I was from mechanical 2.In coding, Sorting and Oops concepts were asked 3. Guessimates ...
(1 Question)
- Q1. Typical HR questions
Dataseers Technologies Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Dataseers Technologies Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
Dataseers Technologies Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
ETL Developer
7
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
QA Engineer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Full Stack Developer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Developer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Database Administrator
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- Dataseers Technologies Interview Questions >
- Dataseers Technologies Data Engineer Interview Questions
