Art Media Agency Data Engineer Interview Questions and Answers

First round is apti when in placement

Too hard all are dsa questions

DSA on trees, duration 2hrs

Trees DSA duration 20mins

Coding assessment in Code signal which is vedio proctored

Q1. Design a loan application system
Ans. 
Design a loan application system
• Collect applicant information such as personal details, employment history, and financial information

• Include a credit check process to assess applicant's creditworthiness

• Implement a system for loan approval/rejection based on set criteria

• Provide options for different types of loans and repayment plans

• Ensure security measures are in place to protect applicant's sensitive information
Answered by AI
Add your answer

Bank account creation, deposit money, withdraw money

Q1. Question around work experience and how a particular scenario or situation is handled
Add your answer

Suggest system cost optimization based on given data set

Aptitude test reasoning test 30 questions and technical part 30 questions

Q1. OOPS concept , constructor destructor , their types , SQL, DBMS , projects written in resume and their flow charts
Add your answer
Q2. Programs of method overloading and overriding , programs of for loop while loop and when we use them And so on
Ans. 
Method overloading and overriding are used in object-oriented programming to create multiple methods with the same name but different parameters or implementations. For and while loops are used for iteration in programming.
• Method overloading involves creating multiple methods in the same class with the same name but different parameters. Example: void print(int num) and void print(String str)

• Method overriding involves ...read more
Answered by AI
Add your answer

Q1. Self Introduction
Add your answer

Q1. How to secure data over the public internet?
Ans. 
Securing data over the public internet involves using encryption, secure protocols, VPNs, and regular security audits.
• Use encryption to protect data in transit, such as SSL/TLS for websites.

• Implement secure protocols like HTTPS, SSH, and SFTP for secure communication.

• Utilize Virtual Private Networks (VPNs) to create secure tunnels for data transmission.

• Regularly conduct security audits and updates to identify and patch...read more
Answered by AI
Add your answer

This is the round in which basic quant questions were asked

In this round basic 2 java questions were asked

In this round one topic was given and we need to discuss about that topic

Q1. What is java explain in detail
Ans. 
Java is a high-level, object-oriented programming language used to develop applications for various platforms.
• Java is platform-independent, meaning it can run on any platform with a Java Virtual Machine (JVM)

• It is known for its security features, such as the ability to run code in a sandbox environment

• Java is used for developing a wide range of applications, from web applications to mobile apps and games

• It is also used...read more
Answered by AI
Add your answer
Q2. What is searching and sorting
Ans. 
Searching is finding a specific item in a collection of items. Sorting is arranging items in a specific order.
• Searching involves looking for a specific item in a collection of items.

• Sorting involves arranging items in a specific order, such as alphabetical or numerical.

• Searching and sorting are commonly used in computer science and data analysis.

• Examples of searching algorithms include linear search and binary search.

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

Q1. What is binary tree explain
Ans. 
A binary tree is a data structure consisting of nodes, where each node has at most two children.
• Nodes in a binary tree have a left and/or right child node.

• The topmost node is called the root node.

• Binary trees are used in search algorithms and data compression.

• Examples of binary trees include binary search trees and heap trees.
Answered by AI
Add your answer

Q1. What is your current location
Add your answer
Q2. What is your salary expectations
Add your answer

Had assignment for ror and react basic crud

Q1. Elevator problem in java
Ans. 
Elevator problem in Java
• Create an Elevator class with methods for moving up and down

• Use a Queue to keep track of the floors that need to be visited

• Implement a scheduling algorithm to determine the order of floor visits
Answered by AI
Add your answer
Q2. Horse race puzzle solution
Add your answer

Quantitative aptitude, reasoning with time limit

Excel tasks were given. There were total 2 tasks related to excel. 1st one was basic and second one was moderate level of difficulty. SQL queries were basic.

Q1. Questions were from the Assignment only. Approach to the problems.
Add your answer

Q1. Basic HR questions like strength and weakness, why you want to join this organization
Add your answer