Data Axle Senior Data Reporting Specialist Interview Questions and Answers

Round duration - 60 mins
Round difficulty - Medium

Q1. 
Railway Seat Berth Determination
Given a railway seat number represented as an integer, determine if it is a valid seat number and identify its berth type. Possible berth types include lower berth, middle...read more
Ans. 
Given a railway seat number, determine if it is valid and identify its berth type.
• Parse input integer 't' for number of test cases

• For each test case, check if seat number is valid (1 <= N <= 100)

• Identify berth type based on seat number and output the result

• Possible berth types are Lower, Middle, Upper, Side Lower, and Side Upper
Answered by AI
Add your answer

Round duration - 90 mins
Round difficulty - Hard

First they asked me to introduce myself then they started questioning on oops concept from basic to advance level such as inheritance, polymorphism, abstraction, exception handling , STL etc. Next they started questioning on data structures. They asked me the logic of “how to find the middle of a linked list”.

Q1. 
Matrix Symmetry Check
You are provided with a square matrix. Your task is to return true if the matrix is symmetric; otherwise, return false.
A symmetric matrix is characterized by its transpose being eq...read more
Ans. 
Check if a square matrix is symmetric by comparing it with its transpose.
• Iterate through the matrix and compare each element with its corresponding element in the transpose

• If any pair of elements do not match, return false immediately

• If all pairs match, return true at the end
Answered by AI
Add your answer

Leet code medium level question

Q1. About Java Streams
Add your answer
Q2. Restful API coding completion based on given file
Ans. 
Guide to completing a RESTful API coding task with essential pointers and examples.
• Understand REST principles: Use HTTP methods (GET, POST, PUT, DELETE) appropriately.

• Define clear endpoints: Example - /api/users for user-related operations.

• Implement status codes: Use 200 for success, 404 for not found, 500 for server errors.

• Use JSON for data interchange: Ensure requests and responses are in JSON format.

• Consider authent...read more
Answered by AI
Add your answer

Q1. To check your attitude
Add your answer
Q2. Given detailed about company and what project you are going to work on?
Add your answer

Q1. Hashmap working
Ans. 
A hashmap is a data structure that stores key-value pairs for efficient data retrieval using a hash function.
• Uses a hash function to compute an index for storing values.

• Handles collisions using methods like chaining or open addressing.

• Example: Inserting a key-value pair (key: 'apple', value: 1) involves hashing 'apple' to find an index.

• Retrieving a value involves hashing the key again to find the corresponding index.
Answered by AI
Add your answer
Q2. Multithreading cases
Add your answer
Q3. Scenario specific on how to handle multiple events on a single variable to have accurate result
Ans. 
Managing multiple events on a single variable requires careful synchronization to ensure accurate results.
• Use locks or mutexes to prevent race conditions when accessing the variable.

• Implement event debouncing to limit the frequency of updates, ensuring only the final event is processed.

• Utilize a queue to handle events sequentially, processing them one at a time to maintain accuracy.

• Consider using atomic operations for ...read more
Answered by AI
Add your answer
Q4. Database indexing
Add your answer
Q5. Architecture level
Add your answer

Question on various topics

More questions on oops, coding

Coding Rount
DSA Round + Puzzle
SQL + Project Discussion
JS

Just plain leetcode medium questions

Basic Aptitude questions like quantitative and logical

Programs have to written for given questions

Q1. F2F interview programming questions were asked
Add your answer
Q2. Questions were asked about projects and technology used in project
Add your answer

The test contains basic programming output questions and some aptitude questions.

We have to solve 5 programming questions in 1 hour. Questions are on arrays and strings.

Q1. Parenthesis balancing Reversing the string Finding the angle between hour and minute hand of clock
Ans. 
Three technical questions related to string manipulation and clock calculations.
• For parenthesis balancing, use a stack data structure to keep track of opening and closing brackets.

• To reverse a string, use two pointers starting from the beginning and end of the string and swap characters until they meet in the middle.

• To find the angle between hour and minute hand of clock, use the formula (30H - 11/2M) degrees, where H ...read more
Answered by AI
Add your answer
Q2. Prime no Add all digits in a number
Ans. 
The question asks to check if a number is prime and add all its digits.
• To check if a number is prime, we can use a loop to divide it by all numbers from 2 to its square root.

• If the number is divisible by any of these numbers, it is not prime.

• To add all digits in a number, we can use a loop to extract each digit and add it to a running total.
Answered by AI
Add your answer