DataMetica ETL Developer Interview Questions and Answers

Competitive coding, multiple choice questions

Q1. CS fundamentals, Object oriented programming, Networking, SQL
Add your answer
Q2. Explain 4 concept of OOPS
Ans. 
OOPS concepts include Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation details and showing only the necessary features.
Answered by AI
Add your answer
Q3. Explain subnet in networking
Ans. 
A subnet is a smaller network within a larger network, created by dividing the IP address range of the larger network.
• Subnets help in organizing and managing network resources efficiently.

• They allow for better security by isolating different parts of the network.

• Subnets can be created by dividing an IP address range into smaller ranges.

• For example, a company may have different subnets for different departments like HR,
Answered by AI
Add your answer
Q4. Concepts of Operating system
Add your answer

Q1. Behavioral questions, questions related to project, questions related to internship
Add your answer

Work well on loops and you will do well enough in the interview.

It was good

Q1. Some devs will ask questions
Add your answer

Salary discusiion

Moderate round . Easy to clear

Q1. Explain stream api
Ans. 
Stream API is a feature in Java that allows processing collections of objects in a functional style.
• Stream API provides a way to perform operations on a collection of objects in a declarative way.

• It supports functional-style operations like map, filter, reduce, and forEach.

• Streams can be created from various sources like collections, arrays, or I/O channels.

• Stream operations are lazy, meaning they are only executed whe...read more
Answered by AI
Add your answer
Q2. Data base connection in sprinh boot
Ans. 
Database connection in Spring Boot is configured using application.properties or application.yml file.
• Define database connection properties in application.properties or application.yml file

• Use @EnableJpaRepositories annotation to enable JPA repositories

• Use @Entity annotation to define entity classes

• Use @Autowired annotation to inject the DataSource or EntityManager
Answered by AI
Add your answer

Q1. Why you want to join in mgs
Ans. 
I want to join MGS because of its reputation for cutting-edge technology and innovative projects.
• Exciting opportunities for growth and learning

• Strong focus on technology and innovation

• Desire to work with talented and passionate individuals

• Alignment with company values and culture
Answered by AI
Add your answer
Q2. Notice period days
Add your answer

They want you to solve pattern questions

Same complex patterns then first round

Q1. Basics of html sql, linear equations
Add your answer

In 1st round they will provide a pattern question which you need to solve in 1 hour

Second round as well a coding test, which is a hard level of pattern coding test which you need to solve with in 45 minutes.

Q1. What is arrow function, write code to create a table (table structure will be provided).
Ans. 
Arrow functions are a concise way to write functions in JavaScript.
• Arrow functions are written using the '=>' syntax.

• They do not have their own 'this' keyword.

• They are best suited for non-method functions.

• Example: const add = (a, b) => a + b;
Answered by AI
Add your answer
Q2. Git commands, what are the steps to commit and push code in git.

Ans. 

To commit and push code in Git, you need to stage changes, commit them, and then push to the remote repository.

• Stage changes using 'git add ' or 'git add .' to add all changes

• Commit changes using 'git commit -m 'commit message''

• Push changes to remote repository using 'git push'

Add your answer