i
Amantya Technologies
Filter interviews by
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 ...
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...
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
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...
The most frequently changing data
Customer preferences
Market trends
Weather data
Stock prices
Social media trends
Top trending discussions
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
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 ...
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
posted on 24 Jul 2024
posted on 3 Sep 2024
posted on 23 Aug 2024
I was interviewed in Feb 2024.
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
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
posted on 15 May 2024
I applied via Recruitment Consulltant and was interviewed before Nov 2023. There were 2 interview rounds.
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
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
Performance based questions
I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed before Nov 2023. There were 5 interview rounds.
2 coding questions in 45 min
30 min of logical reasoning and basic aptitude
30 min of GD over a general topic to check your communication skills
posted on 24 May 2021
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...
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
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.
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...
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
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
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.
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.
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
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...
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.
...
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
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
based on 1 interview
Interview experience
Software Engineer
250
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Senior Software Engineer
107
salaries
| ₹8.2 L/yr - ₹22 L/yr |
Technical Lead
72
salaries
| ₹11.8 L/yr - ₹31 L/yr |
Software Developer
35
salaries
| ₹3.5 L/yr - ₹13.4 L/yr |
Senior Test Engineer
21
salaries
| ₹7.1 L/yr - ₹16.5 L/yr |
TCS
Infosys
Wipro
HCLTech