Axtria Senior Data Engineer Interview Questions and Answers

Q1. How did you ingest kafka data and you day to day activity
Ans. 
I ingested Kafka data using Kafka Connect and performed data processing and analysis on a daily basis.
• Used Kafka Connect to ingest data from various sources into Kafka topics

• Developed custom Kafka Connect connectors for specific data sources

• Utilized Kafka Streams for real-time data processing and analysis

• Worked with schema registry for data serialization and deserialization
Answered by AI
Add your answer
Q2. What is catalyst optimizer
Ans. 
Catalyst optimizer is a query optimization framework in Apache Spark that improves performance by generating optimized query plans.
• Catalyst optimizer is a rule-based optimization framework in Apache Spark.

• It leverages advanced techniques like predicate pushdown, constant folding, and join reordering to optimize query plans.

• Catalyst optimizer helps in improving the performance of Spark SQL queries by selecting the most ...read more
Answered by AI
Add your answer

Q1. Stored procedure sql hard
Add your answer
Q2. Easy dsa problem solving
Add your answer

SQL test, 3-5 questions. Easy to moderate difficult.

Q1. Your current and expected slaray
Add your answer
Q2. Do you have any offer in hand
Ans. 
Yes, I have received an offer from another company.
• Received an offer from XYZ company for a Senior Data Engineer position

• Currently evaluating the offer and considering my options

• Have not made a decision yet
Answered by AI
Add your answer

Normal online code / frontend test

Q1. How would you build book my show
Ans. 
Designing and building a platform similar to BookMyShow involves creating a user-friendly interface for booking tickets for various events.
• Develop a user-friendly website and mobile app for users to browse and book tickets for movies, concerts, plays, etc.

• Implement a secure payment gateway for users to make online transactions.

• Integrate a database to store information about events, venues, tickets, and user bookings.

• In...read more
Answered by AI
Add your answer

Q1. Solid principals, awareness of patterns
Add your answer

Q1. How would you build tinyurl like service, systems designs
Ans. 
To build a tinyurl-like service, design a system with a URL shortening algorithm, a database to store mappings, and a redirect service.
• Use a hashing algorithm to generate short URLs from long URLs (e.g. MD5, SHA-256).

• Store the mappings of short URLs to long URLs in a database (e.g. MySQL, Redis).

• Implement a redirect service that takes a short URL, looks up the corresponding long URL in the database, and redirects the u...read more
Answered by AI
Add your answer

Q1. Non-technical questions
Add your answer

Q1. Easy array problem
Add your answer
Q2. Easy tree traversal problem
Ans. 
Implement tree traversal algorithm to visit each node in a tree structure
• Use depth-first search (DFS) or breadth-first search (BFS) to traverse the tree

• DFS can be implemented using recursion or a stack data structure

• BFS can be implemented using a queue data structure

• Example: Inorder traversal of a binary tree - left, root, right
Answered by AI
Add your answer

Q1. Trapping rain water
Add your answer
Q2. Path of longest sum
Ans. 
Find the path in a matrix with the longest sum of elements
• Start from the top-left corner of the matrix

• Move only right or down in the matrix

• Keep track of the sum of elements in each path

• Return the path with the longest sum
Answered by AI
Add your answer

Q1. Reverse the linked list.
Add your answer

Q1. Internel working of Hashmap
Add your answer

Q1. Salary Discussion
Add your answer

Q1. Explain OOPS concept and how you apply it in your implementation
Ans. 
OOPS is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
• OOPS focuses on the concept of classes and objects

• Encapsulation: bundling data and methods that operate on the data within a single unit

• Inheritance: allows a class to inherit properties and behavior from another class

• Polymorphism: ability to present the same interface for diffe...read more
Answered by AI
View 1 more answer
Q2. Difference between Comparable and Comparator. Difference between Abstract Class and Interface
Ans. 
Comparable is an interface used for natural ordering, Comparator is an interface used for custom ordering. Abstract class can have method implementations, Interface cannot.
• Comparable interface is used to define the natural ordering of objects. Example: String class implements Comparable interface for natural ordering based on alphabetical order.

• Comparator interface is used to define custom ordering of objects. Example:...read more
Answered by AI
View 1 more answer
Q3. Given a string. Find the number of occurrences of each character
Ans. 
Count occurrences of each character in a given string
• Create an array to store the count of each character

• Iterate through the string and increment the count of each character in the array

• Return the array with counts for each character
Answered by AI
Add your answer
Q4. Given an array. Remove the number of duplicates
Ans. 
Remove duplicates from an array of strings
• Iterate through the array and store each element in a set to keep track of unique values

• Create a new array with the unique values from the set
Answered by AI
Add your answer
Q5. Given a student object having name and grade data variables. Sort the object on the basis of highest grade.
Add your answer

It was well designed

Q1. Basic Questions about data warehousing
Add your answer
Q2. Dbt Scenarios
Add your answer