Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Amantya Technologies Team. If you also belong to the team, you can get access from here

Amantya Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

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

Updated 12 Feb 2024

Amantya Technologies Senior Data Engineer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
Round 1 - Technical 

(5 Questions)

  • Q1. Ques -> Can you define difference b/w Azure data lake and Delta lake.
  • Ans. 

    Azure Data Lake is a cloud-based storage and analytics service, while Delta Lake is an open-source storage layer that adds reliability to data lakes.

    • Azure Data Lake is a service provided by Microsoft Azure for storing and analyzing large amounts of data.

    • Delta Lake is an open-source storage layer that adds ACID transactions and schema enforcement to data lakes.

    • Azure Data Lake is a cloud-based solution, while Delta Lake ...

  • Answered by AI
  • Q2. How to implemented Primary key and foreign key in delta tables.
  • Ans. 

    Primary keys and foreign keys can be implemented in delta tables using constraints and references.

    • Primary keys can be implemented using the PRIMARY KEY constraint, which ensures that each record in the table has a unique identifier.

    • Foreign keys can be implemented using the FOREIGN KEY constraint, which establishes a link between two tables based on a common column.

    • The referenced table must have a primary key defined, a...

  • Answered by AI
  • Q3. How to handle exception in python?
  • Ans. 

    Exception handling in Python allows for the graceful handling of errors and prevents program crashes.

    • Use try-except blocks to catch and handle exceptions.

    • Multiple except blocks can be used to handle different types of exceptions.

    • The finally block is executed regardless of whether an exception occurred or not.

    • Exceptions can be raised using the 'raise' keyword.

    • Custom exceptions can be defined by creating a new class that

  • Answered by AI
  • Q4. What is star schema and snowflake schema
  • Ans. 

    Star schema is a data modeling technique where a central fact table is connected to multiple dimension tables. Snowflake schema is an extension of star schema with normalized dimension tables.

    • Star schema is a simple and denormalized structure

    • It consists of a central fact table connected to multiple dimension tables

    • Dimension tables contain descriptive attributes

    • Star schema is easy to understand and query, but can lead t...

  • Answered by AI
  • Q5. Which are the most frequently change
  • Ans. 

    The most frequently changing data

    • Customer preferences

    • Market trends

    • Weather data

    • Stock prices

    • Social media trends

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Ecommerce salesforce
  • Q2. Ecommerce and salesforce
Round 2 - One-on-one 

(2 Questions)

  • Q1. Ecommerce salesforce
  • Q2. Salesforce com ecommerce
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Describe your workflow of the last project
  • Ans. 

    Developed ETL pipeline to ingest, clean, and analyze customer data for personalized marketing campaigns

    • Gathered requirements from stakeholders to understand data sources and business objectives

    • Designed data model to store customer information and campaign performance metrics

    • Implemented ETL process using Python and Apache Spark to extract, transform, and load data

    • Performed data quality checks and created visualizations ...

  • Answered by AI
  • Q2. What are the different transformations you have used
  • Ans. 

    I have used various transformations such as filtering, joining, aggregating, and pivoting in my data engineering projects.

    • Filtering data based on certain conditions

    • Joining multiple datasets together

    • Aggregating data to summarize information

    • Pivoting data from rows to columns or vice versa

  • Answered by AI
Round 2 - One-on-one 

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. There were multiple questions on azure cloud and projects i worked on
  • Q2. Sql queries and scenario based azure questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. Basic all type questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Project related and technology se related
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
More than 8 weeks
Result
Not Selected

I was interviewed in Feb 2024.

Round 1 - reading test 

(3 Questions)

  • 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
  • Q2. Read news paper
  • 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

Interview Preparation Tips

Interview preparation tips for other job seekers - A small company having hectic, pathetic, inhuman and never ending interview process. I was interviewed and they need immediate joiner and after clearing 3 round of technical interview they suppose to release offer letter after HR discussion. All of the sudden they came up with detail that requirement get full and later after 2 month they call again and ask for further interview process and took another 3 technical rounds which I have cleared all. Till the time I cleared 6 round of interviews for same roll and it has been 2.5 months and initially they were looking for immediate joiner. Now you under stand how pathetic their hiring process is. Again they came up with more round and even HR didn't bother to update me that what will be this discussion all about. and surprisingly its a reading test followed by a grammar test , which I think should be taken at start of the all interview process. My laptop screen having some issues and my glasses got broken ... if HR updated me I could get it fixed. but due to all this I was unable to read smaller text on the screen . This interview was done by a Architect level person , how foolish it look like, I even communicated HR about my situation as if he informed about this round I could have get thing fixed and performed in better way as I already cleared 6 technical round and having 10 + years of experience. He said that you are not shortlisted for further rounds. I even request him that please arrange another round as I have some technical issues with system and my glasses also broken, he denied. SO suggesting here is just stay away from this company they will create hope and waste all you efforts and time. I could have get selected in another organization but I spent more time in this organization hiring process. One more this .. all the rating about this organization was forced written by its employees who want to leave organization as if you join you will get trapped . I got to know about it from one of former employee. SO I am thanking to GOD that I am not selected in this organization.
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Functional Interface,java 8 features,predicate functions
Round 2 - One-on-one 

(1 Question)

  • Q1. General question & scenario based questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain recent project
  • Ans. 

    Developed a predictive model for customer churn in a telecom company

    • Collected and cleaned customer data from various sources

    • Performed exploratory data analysis to identify patterns and trends

    • Built a machine learning model using logistic regression to predict customer churn

    • Evaluated the model's performance using metrics such as accuracy, precision, and recall

  • Answered by AI
  • Q2. Cloud technologies used
  • Ans. 

    Various cloud technologies like AWS, Azure, and Google Cloud are commonly used for data analysis.

    • AWS (Amazon Web Services)

    • Azure (Microsoft Azure)

    • Google Cloud Platform

  • Answered by AI
Round 2 - Group Discussion 

Performance based questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed before Nov 2023. There were 5 interview rounds.

Round 1 - Coding Test 

2 coding questions in 45 min

Round 2 - Technical 

(2 Questions)

  • Q1. Basics of java and frameworks
  • Q2. Basics of SQL and types of queries
Round 3 - Aptitude Test 

30 min of logical reasoning and basic aptitude

Round 4 - Group Discussion 

30 min of GD over a general topic to check your communication skills

Round 5 - HR 

(2 Questions)

  • Q1. Why do you want to join our company
  • Q2. Why should we hire you

Interview Questionnaire 

15 Questions

  • Q1. What is entity framework.
  • Ans. 

    Entity Framework is an Object-Relational Mapping (ORM) framework that enables developers to work with relational databases using .NET objects.

    • EF is a tool for creating data access layer in .NET applications

    • It allows developers to work with databases using C# or VB.NET code instead of SQL

    • EF supports LINQ queries and provides automatic change tracking

    • EF can generate database schema from code-first approach

    • EF can also gen...

  • Answered by AI
  • Q2. What is dependency injection
  • Ans. 

    Dependency injection is a design pattern used to remove hard-coded dependencies and make code more modular and testable.

    • Dependencies are injected into a class rather than being hard-coded

    • This allows for easier testing and swapping of dependencies

    • Commonly used in frameworks like Spring and Angular

  • Answered by AI
  • Q3. Oops depth level question
  • Q4. Whatvis generics and collection
  • Ans. 

    Generics and collections are fundamental concepts in Java programming.

    • Generics allow for type safety and reusability of code.

    • Collections are data structures that store and manipulate groups of objects.

    • Examples of collections include ArrayList, LinkedList, and HashMap.

    • Generics can be used with collections to ensure type safety.

    • Collections provide methods for adding, removing, and accessing elements.

  • Answered by AI
  • Q5. What is sql injection
  • Ans. 

    SQL injection is a type of cyber attack where malicious SQL statements are inserted into an entry field to manipulate the database.

    • SQL injection attacks exploit vulnerabilities in web applications that do not properly validate user input.

    • Attackers can use SQL injection to steal sensitive data, modify or delete data, or even take control of the entire database.

    • Preventing SQL injection involves using parameterized querie...

  • Answered by AI
  • Q6. How to handle security in rest api
  • Ans. 

    Security in REST API can be handled by implementing authentication, authorization, encryption, and input validation.

    • Implement authentication using tokens or OAuth2

    • Implement authorization by defining roles and permissions

    • Encrypt sensitive data using SSL/TLS

    • Validate input data to prevent injection attacks

    • Implement rate limiting to prevent DDoS attacks

  • Answered by AI
  • Q7. What is soap. And what us differences between rest and soap
  • Ans. 

    SOAP is a protocol for exchanging structured information in the implementation of web services. REST is an architectural style for building web services.

    • SOAP stands for Simple Object Access Protocol

    • SOAP uses XML for message exchange

    • SOAP requires more bandwidth and processing power than REST

    • REST uses HTTP for communication

    • REST is more flexible and scalable than SOAP

    • RESTful APIs are easier to implement and maintain than

  • Answered by AI
  • Q8. How ro get table data in store procedures
  • Ans. 

    Table data can be retrieved in store procedures using SELECT statement.

    • Use SELECT statement to retrieve data from table in store procedures.

    • Specify the table name and columns to retrieve data from.

    • Use WHERE clause to filter data based on conditions.

    • Use ORDER BY clause to sort data based on column values.

  • Answered by AI
  • Q9. What is index in table
  • Ans. 

    An index in a table is a data structure that improves the speed of data retrieval operations.

    • Indexes are created on one or more columns of a table.

    • They allow for faster searching and sorting of data.

    • Indexes can be unique or non-unique.

    • Examples of indexes include primary keys, foreign keys, and clustered indexes.

  • Answered by AI
  • Q10. What happen if add index on all column in table
  • Ans. 

    Adding index on all columns in a table can slow down write operations and increase storage space.

    • Adding index on all columns can increase the storage space required for the table.

    • It can also slow down write operations as the index needs to be updated for every write operation.

    • It may improve read performance for queries that use all columns in the table.

    • It is generally not recommended to add index on all columns in a ta

  • Answered by AI
  • Q11. What is trigger
  • Ans. 

    A trigger is a piece of code that automatically executes in response to a specific event or change in a system.

    • Triggers are commonly used in databases to automatically perform actions when certain data is inserted, updated, or deleted.

    • Triggers can be used to enforce business rules, validate data, or perform complex calculations.

    • Examples of triggers include sending an email notification when a new record is added to a d...

  • Answered by AI
  • Q12. Difference between sp and function
  • Ans. 

    Stored procedures are precompiled and can return multiple result sets, while functions are not precompiled and can only return a single value.

    • Stored procedures are used to perform a set of operations and can return multiple result sets.

    • Functions are used to perform a single operation and can only return a single value.

    • Stored procedures are precompiled and stored in the database, while functions are compiled at runtime.

    • ...

  • Answered by AI
  • Q13. Mvc life cycle
  • Q14. What is action filter
  • Ans. 

    Action filter is a feature in ASP.NET MVC that allows you to execute code before or after an action method is executed.

    • Action filters are attributes that can be applied to controller actions or globally to all actions in the application.

    • They can be used for authentication, caching, logging, exception handling, and more.

    • Examples of action filters include AuthorizeAttribute, OutputCacheAttribute, HandleErrorAttribute, an

  • Answered by AI
  • Q15. Sequence of filters
  • Ans. 

    Sequence of filters in software development

    • Define the problem and requirements

    • Choose appropriate filters based on the problem

    • Implement and test the filters in sequence

    • Refine and optimize the filters as needed

  • Answered by AI

Skills evaluated in this interview

Amantya Technologies Interview FAQs

How many rounds are there in Amantya Technologies Senior Data Engineer interview?
Amantya Technologies interview process usually has 1 rounds. The most common rounds in the Amantya Technologies interview process are Technical.
What are the top questions asked in Amantya Technologies Senior Data Engineer interview?

Some of the top questions asked at the Amantya Technologies Senior Data Engineer interview -

  1. How to implemented Primary key and foreign key in delta tabl...read more
  2. Ques -> Can you define difference b/w Azure data lake and Delta la...read more
  3. How to handle exception in pyth...read more

Tell us how to improve this page.

Amantya Technologies Senior Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Software Engineer
250 salaries
unlock blur

₹3 L/yr - ₹11.8 L/yr

Senior Software Engineer
107 salaries
unlock blur

₹8.2 L/yr - ₹22 L/yr

Technical Lead
72 salaries
unlock blur

₹11.8 L/yr - ₹31 L/yr

Software Developer
35 salaries
unlock blur

₹3.5 L/yr - ₹13.4 L/yr

Senior Test Engineer
21 salaries
unlock blur

₹7.1 L/yr - ₹16.5 L/yr

Explore more salaries
Compare Amantya Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview