Amantya Technologies Senior Data Engineer Interview Questions, Process, and Tips

Q1. All employees having same salary in the smae department sql and pysprk
Add your answer
Q2. How to create pipeline in databricks
Ans. 
To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.
• Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

• Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

• Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.
Answered by AI
Add your answer
Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...read more
Add your answer
Q4. String manuplation questions inpython
Add your answer

Print a specific pattern using any programming language.

Q1. What is a class in Object-Oriented Programming (OOP)?
Ans. 
A class in OOP is a blueprint for creating objects, defining their properties and behaviors.
• Classes are templates for creating objects in OOP

• They define the properties (attributes) and behaviors (methods) of objects

• Objects are instances of classes, each with its own unique data

• Inheritance allows classes to inherit properties and behaviors from other classes

• Encapsulation ensures that the data is hidden and can only be a...read more
Answered by AI
Add your answer
Q2. What is the difference between an abstract class and an interface?
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructors, fields, and methods, while interface cannot have any implementation.

• A class can only extend one abstract class, but can implement multiple interfaces.

• Abstract classes are used to define common characteristics of subclasses, while interfaces are used to define contracts for...read more
Answered by AI
Add your answer
Q3. What is joining and creating an inner join query?
Ans. 
Joining is combining data from two or more tables based on a related column, while an inner join query retrieves only the matching records.
• Joining is used to combine data from multiple tables in a database.

• Inner join query retrieves only the records that have matching values in both tables.

• Syntax for inner join: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Example: SELECT orders.order_i...read more
Answered by AI
Add your answer

Q1. Self Introduction
Add your answer
Q2. Twilio Framework
Add your answer

Q1. Related to Django Framework
Add your answer
Q2. Related to Twilio Framework
Add your answer

Job Roles and Responsibility & Salary Discussion

Q1. Springboot notations
Add your answer
Q2. How to handle multiple request on springboot
Ans. 
Use thread pooling and asynchronous processing to handle multiple requests efficiently in Spring Boot.
• Implement thread pooling to manage multiple requests concurrently.

• Use asynchronous processing to handle requests without blocking the main thread.

• Consider using reactive programming with Spring WebFlux for better scalability.

• Optimize database queries and external API calls to reduce response times.

• Implement caching mec...read more
Answered by AI
Add your answer

Q1. What is server and abap server
Ans. 
A server is a computer or software that provides functionality for other programs or devices. ABAP server is a server that runs ABAP programs.
• A server is a computer or software that provides services or resources to other computers or programs.

• ABAP server is a server that runs ABAP (Advanced Business Application Programming) programs, commonly used in SAP systems.

• ABAP server handles requests from clients and executes A...read more
Answered by AI
Add your answer

Q1. Basic all type questions
Add your answer

Q1. Project related and technology se related
Add your answer

Q1. Read the text over screen share
Ans. 
The candidate is asked to read and answer a question displayed on screen share.
• Read the text carefully to understand the question

• Analyze the information provided in the text

• Formulate a clear and concise answer based on the text
Answered by AI
Add your answer
Q2. Read news paper
Add your answer
Q3. Write details over screen share
Ans. 
The interviewer is asking the candidate to write details over screen share.
• Prepare a clear outline before starting to write

• Use bullet points or numbered lists for better organization

• Include relevant details and examples to support your points
Answered by AI
Add your answer

Q1. What is your name
Add your answer
Q2. What is your strength
Add your answer