AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Ethics Infotech
Compare
Filter interviews by
Ethics Infotech Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Software Engineer Interview Questions & Answers
Direction Software LLP
Anonymous
posted on 12 Oct 2024
I applied via Referral and was interviewed in Sep 2024. There were 3 interview rounds.
(17 Questions)
- Q1. What was your role and responsibilities in your previous company?
- Ans.
I was responsible for developing and maintaining software applications, debugging code, and collaborating with team members.
Developed and maintained software applications
Debugged code to identify and fix issues
Collaborated with team members on projects
- Q2. Key features of Java 8.
- Ans.
Key features of Java 8 include lambda expressions, functional interfaces, streams, and default methods.
Lambda expressions allow for functional programming style in Java.
Functional interfaces enable the use of lambda expressions.
Streams provide a way to work with collections in a more functional way.
Default methods allow interfaces to have method implementations.
- Q3. What is multi-threading and how have you used it in your application?
- Ans.
Multi-threading is a programming concept where multiple threads run concurrently within a single process.
Multi-threading allows for parallel execution of tasks, improving performance and responsiveness.
Used in applications that require handling multiple tasks simultaneously, such as web servers or video editing software.
Example: Implementing a multi-threaded server to handle multiple client requests concurrently.
- Q4. What are the compatible features of Java?
- Ans.
Some compatible features of Java include platform independence, object-oriented programming, and automatic memory management.
Platform independence allows Java programs to run on any platform with a Java Virtual Machine (JVM)
Object-oriented programming allows for modular and reusable code through classes and objects
Automatic memory management with garbage collection helps manage memory allocation and deallocation
Java al...
- Q5. Can you explain what ConcurrentModificationException is and how to resolve it?
- Ans.
ConcurrentModificationException occurs when a collection is modified while iterating over it.
Occurs in Java when a collection is modified while being iterated over
Can be resolved by using an Iterator to remove elements instead of directly modifying the collection
Alternatively, use synchronized collections or ConcurrentHashMap to avoid this exception
- Q6. What is Spring Boot?
- Ans.
Spring Boot is a Java-based framework used to create standalone, production-grade Spring-based applications.
Spring Boot simplifies the process of creating and deploying Spring applications.
It provides a set of pre-configured tools and conventions to get started quickly.
Spring Boot includes embedded servers like Tomcat, Jetty, or Undertow for easy deployment.
It allows for easy configuration through properties files or Y...
- Q7. What are microservices?
- Ans.
Microservices are a software development technique where applications are composed of small, independent services that communicate with each other.
Microservices are small, focused services that work together to form a complete application
Each microservice is responsible for a specific function or feature
Microservices communicate with each other through APIs
Microservices can be developed, deployed, and scaled independen...
- Q8. Do microservices contain transactional data?
- Ans.
Yes, microservices can contain transactional data.
Microservices can handle transactional data by using distributed transactions or event sourcing.
Each microservice can manage its own database, which can include transactional data.
Microservices can communicate with each other to ensure consistency in transactional data.
Examples: E-commerce platform with separate microservices for inventory, orders, payments, etc.
- Q9. How can microservices be updated with new data?
- Ans.
Microservices can be updated with new data by using versioning, rolling updates, blue-green deployments, and canary releases.
Use versioning to manage different versions of microservices.
Implement rolling updates to gradually update instances without downtime.
Utilize blue-green deployments to switch between old and new versions seamlessly.
Employ canary releases to test new data on a small subset of users before full dep
- Q10. What technologies can be used to update microservices with data?
- Ans.
Technologies like Kafka, RabbitMQ, and Apache Pulsar can be used to update microservices with data.
Kafka
RabbitMQ
Apache Pulsar
- Q11. How do you configure login in Spring Boot?
- Ans.
To configure login in Spring Boot, you can use Spring Security to handle authentication and authorization.
Add Spring Security dependency in your pom.xml file
Create a class that extends WebSecurityConfigurerAdapter to configure security settings
Override configure(HttpSecurity http) method to define login form, login processing URL, success and failure URLs
Use @EnableWebSecurity annotation on your main application class
- Q12. How do you handle multiple data sources in Spring Boot?
- Ans.
Multiple data sources in Spring Boot can be handled using Spring Data JPA and configuring multiple data source beans.
Use @Primary annotation to specify the primary data source bean
Configure additional data sources in application.properties or application.yml file
Use @Qualifier annotation to specify which data source to inject in a specific repository or service class
- Q13. Do you filter out duplicate employee records from a list?
- Ans.
Yes, I typically use a hash set or dictionary to filter out duplicate employee records from a list.
Iterate through the list of employee records
Use a hash set or dictionary to keep track of unique employee IDs
Check each employee record against the hash set or dictionary to filter out duplicates
- Q14. How do you identify an object in a collection?
- Ans.
To identify an object in a collection, you can iterate through the collection and compare each object with the target object.
Iterate through the collection using a loop
Compare each object in the collection with the target object using a conditional statement
Use a unique identifier or property of the object to match it with the target object
Example: Identifying a specific student in a list of students by comparing their
- Q15. What is a REST API?
- Ans.
REST API is a set of rules and conventions for building and interacting with web services.
REST stands for Representational State Transfer
Uses standard HTTP methods like GET, POST, PUT, DELETE
Communicates over HTTP using JSON or XML
Stateless, meaning each request from a client to server must contain all the information needed to understand the request
- Q16. How do you implement an authentication service in an application?
- Ans.
Implementing an authentication service involves creating a secure system for verifying user identities.
Use encryption to securely store user passwords
Implement multi-factor authentication for added security
Utilize tokens or cookies for session management
Integrate with OAuth or OpenID Connect for third-party authentication
Implement rate limiting and account lockout mechanisms to prevent brute force attacks
- Q17. How does REST service return data and in which format?
- Ans.
REST services return data in JSON or XML format.
Data is typically returned in JSON or XML format.
JSON is more commonly used due to its simplicity and readability.
REST services can also return data in other formats like HTML or plain text.
Example: {"name": "John Doe", "age": 30}
(9 Questions)
- Q1. What is the role of the Spring Boot actuator?
- Ans.
Spring Boot actuator provides production-ready features to help monitor and manage your application.
Provides endpoints to monitor application health, metrics, info, etc.
Can be used to check the status of the application, database connections, and more.
Allows customization and security configurations for the endpoints.
- Q2. How can you secure a spring boot application, especially in the context of a banking application? what are the basics of spring security?
- Ans.
Securing a Spring Boot application, especially in the context of a banking application, involves implementing Spring Security.
Use Spring Security to handle authentication and authorization
Implement secure communication using HTTPS
Utilize role-based access control to restrict user permissions
Enable CSRF protection to prevent cross-site request forgery attacks
Implement secure password storage and session management
- Q3. How can you integrate Spring Data JPA with Spring Boot?
- Ans.
Integrating Spring Data JPA with Spring Boot allows for easy database operations in a Spring Boot application.
Add Spring Data JPA dependency in pom.xml
Create JPA entity classes annotated with @Entity
Create a repository interface extending JpaRepository
Use repository interface in service classes for database operations
Configure application.properties with database connection details
- Q4. Can you explain the concept of Optional in Java?
- Ans.
Optional in Java is a container object which may or may not contain a non-null value.
Optional was introduced in Java 8 to handle null values more effectively.
It is used to avoid NullPointerExceptions by explicitly checking if a value is present before using it.
Optional can be used with methods that may return null to indicate that the value may be absent.
Example: Optional
optionalName = Optional.ofNullable(name);
- Q5. Do you have any experience with job scheduling?
- Ans.
Yes, I have experience with job scheduling in previous projects.
Utilized cron jobs to automate tasks at specific times
Worked with tools like Apache Airflow for complex job scheduling workflows
Implemented job scheduling in Python scripts using libraries like schedule or APScheduler
- Q6. How does microservice architecture differ from monolithic architecture?
- Ans.
Microservice architecture is a modular approach where an application is divided into smaller, independent services, while monolithic architecture is a single, unified structure.
Microservice architecture breaks down an application into smaller, loosely coupled services that can be developed, deployed, and scaled independently.
Monolithic architecture involves building the entire application as a single unit, making it ha...
- Q7. What is the use of the CI/CD pipeline in software development?
- Ans.
CI/CD pipeline automates the process of integrating code changes and deploying them to production.
Automates the process of integrating code changes
Automates the process of testing code changes
Automates the process of deploying code changes
Helps in detecting and fixing bugs early in the development cycle
Increases the speed of software delivery
Ensures consistency in the deployment process
- Q8. What technologies you were using to create the UI side of your springboard application?
- Ans.
I used AngularJS and Bootstrap to create the UI side of the springboard application.
AngularJS
Bootstrap
- Q9. What do you know about Vaadin?
- Ans.
Vaadin is an open-source web application framework for building modern web apps using Java.
Vaadin allows developers to build web applications using Java on the server-side and HTML/CSS/JavaScript on the client-side.
It provides a set of customizable UI components and a Java API for creating interactive web interfaces.
Vaadin simplifies the development process by handling client-server communication and UI updates automat...
(24 Questions)
- Q1. What is the difference between JDK and JRE?
- Ans.
JDK is a development kit for creating Java applications, while JRE is a runtime environment for executing Java programs.
JDK stands for Java Development Kit and includes tools for developing Java applications, such as compiler and debugger.
JRE stands for Java Runtime Environment and is used to run Java applications. It includes JVM, libraries, and other necessary components.
JDK is needed for developing Java applications...
- Q2. Can we run a program without JRE?
- Ans.
No, Java programs require JRE to run.
Java programs are compiled into bytecode which is executed by the Java Runtime Environment (JRE)
JRE is necessary to interpret and run Java programs
Without JRE, Java programs cannot be executed
- Q3. What is the internal working of HashMap in java?
- Ans.
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.
HashMap uses an array of linked lists to store key-value pairs.
When a key-value pair is added, the key is hashed to determine its index in the array.
If multiple keys hash to the same index, a linked list is used to handle collisions.
HashMap allows null keys and values, and does not guarantee the order of key-
- Q4. What happens if I have a key with a null value in HashMap and where it will get stored?
- Ans.
A key with a null value in HashMap will be stored in the HashMap as a key-value pair with a null value.
In a HashMap, keys can have null values but only one key with a null value is allowed.
If you try to store a key with a null value multiple times, the previous value associated with that key will be overwritten.
Example: HashMap
- Q5. Difference between fail-fast and fail-safe? which one is synchronized?
- Ans.
Fail-fast stops immediately upon detecting an error, while fail-safe continues to operate despite errors. Fail-safe is synchronized.
Fail-fast immediately stops the operation upon encountering an error, ensuring that no further damage is done.
Fail-safe continues to operate despite errors, often by handling the error and allowing the program to continue running.
Fail-safe is synchronized, meaning that it is designed to ha...
- Q6. HashMap vs LinkedHashMap?
- Ans.
HashMap is unordered while LinkedHashMap maintains insertion order.
HashMap does not maintain insertion order while LinkedHashMap does.
LinkedHashMap extends HashMap and adds a doubly-linked list to maintain order.
HashMap is faster for iteration while LinkedHashMap is slower due to maintaining order.
- Q7. Load factor in HashMap?
- Ans.
Load factor in HashMap determines when the HashMap should be resized to maintain performance.
Load factor is a measure of how full the HashMap is allowed to get before its capacity is automatically increased.
The default load factor of HashMap is 0.75, which means the HashMap will be resized when it is 75% full.
Increasing the load factor reduces the space overhead but increases the time cost of resolving collisions.
Examp...
- Q8. What is a Daemon thread?
- Ans.
A Daemon thread is a background thread that runs without blocking the main program from exiting.
Daemon threads are used for tasks that do not require user interaction or continuous monitoring.
They are automatically terminated by the JVM when all non-daemon threads have finished.
An example of a Daemon thread is the garbage collector in Java.
- Q9. Concept of multithreading in Java and how does it work?
- Ans.
Multithreading in Java allows multiple threads to execute concurrently, improving performance and responsiveness.
Multithreading allows multiple threads to run concurrently within a single process.
Each thread has its own stack and program counter, but share the same heap memory.
Java provides built-in support for multithreading through the java.lang.Thread class.
Example: Creating a new thread by extending the Thread clas
- Q10. What is the Executor framework in Java?
- Ans.
Executor framework in Java is a framework that provides a way to manage and control the execution of tasks in a multithreaded environment.
Allows for decoupling task submission from task execution
Provides a way to manage thread creation, pooling, and scheduling of tasks
Helps in handling exceptions and errors that occur during task execution
Examples include ThreadPoolExecutor and ScheduledThreadPoolExecutor classes
- Q11. Name some methods in Executor framework?
- Ans.
Some methods in Executor framework include execute(), submit(), shutdown(), awaitTermination(), and invokeAll().
execute() - Used to execute the given command at some time in the future.
submit() - Submits a Runnable or Callable task for execution and returns a Future representing the task.
shutdown() - Initiates an orderly shutdown in which previously submitted tasks are executed, but no new tasks will be accepted.
awaitT...
- Q12. What is the join method in Java?
- Ans.
The join method in Java is used to concatenate the elements of an array into a single string.
The join method is a part of the String class in Java.
It takes an array of strings as input and concatenates them with a specified delimiter.
Example: String[] arr = {"Hello", "World"}; String result = String.join(", ", arr); // Output: Hello, World
- Q13. Explain one-to-many and many-to-one relationships in Hibernate.
- Ans.
One-to-many and many-to-one relationships in Hibernate are used to define the relationship between entities in a database.
One-to-many relationship: One entity can be associated with multiple instances of another entity. For example, one department can have multiple employees.
Many-to-one relationship: Multiple instances of one entity can be associated with a single instance of another entity. For example, multiple emplo
- Q14. What is an ID in Hibernate and how it is used?
- Ans.
An ID in Hibernate is a unique identifier for an entity in a database. It is used to uniquely identify each record.
ID is a field in an entity class annotated with @Id in Hibernate.
It can be of different types like int, long, String, etc.
ID is used to uniquely identify each record in a database table.
It is often generated automatically using strategies like @GeneratedValue.
Example: @Id @GeneratedValue(strategy = Generat
- Q15. How do you create custom queries in Spring Data JPA?
- Ans.
Custom queries in Spring Data JPA can be created using @Query annotation or method naming conventions.
Use @Query annotation with JPQL or native SQL to define custom queries
Follow method naming conventions to automatically generate queries based on method names
Use parameters in custom queries by adding method parameters and referencing them in the query
- Q16. Name different annotations used in Spring Boot.
- Ans.
Some common annotations used in Spring Boot are @RestController, @Autowired, @RequestMapping, @Component, @Service, @Repository.
@RestController - Used to define a controller class in Spring MVC.
@Autowired - Used for automatic dependency injection.
@RequestMapping - Used to map web requests to specific handler methods.
@Component - Indicates that a class is a Spring component.
@Service - Indicates that a class is a Spring ...
- Q17. How to create a repository interface in Spring Data JPA?
- Ans.
To create a repository interface in Spring Data JPA, you need to define an interface that extends JpaRepository.
Create an interface that extends JpaRepository
Add custom query methods by defining method signatures in the repository interface.
Spring Data JPA will automatically generate the implementation for the repository interface at run
- Q18. How to define custom queries in the repository interface?
- Ans.
Custom queries in repository interface are defined using @Query annotation in Spring Data JPA.
Use @Query annotation above the method declaration in the repository interface.
Write the custom query in JPQL or native SQL within the @Query annotation.
You can also pass parameters to the query using method parameters.
- Q19. What is the difference between @Controller and @RestController?
- Ans.
The main difference is that @RestController is a specialized version of @Controller that is used for RESTful web services.
Both @Controller and @RestController are used in Spring MVC to handle HTTP requests, but @RestController is specifically used for RESTful web services.
@Controller is used to create web pages that return HTML, while @RestController is used to create RESTful web services that return data in JSON or XM...
- Q20. What is DispatcherServlet in Spring Boot?
- Ans.
DispatcherServlet is the front controller in Spring Boot that receives incoming requests and dispatches them to the appropriate handler.
DispatcherServlet is a servlet that manages the flow of incoming requests in a Spring Boot application.
It acts as the front controller, receiving all requests and then dispatching them to the appropriate handler for processing.
DispatcherServlet is configured in the web.xml file or thro...
- Q21. What are microservices?
- Ans.
Microservices are a software development technique where applications are broken down into smaller, independently deployable services.
Microservices allow for easier scalability and maintenance of complex systems.
Each microservice typically focuses on a specific business function.
Communication between microservices is usually done through APIs.
Examples of companies using microservices include Netflix, Amazon, and Uber.
- Q22. How does communication happen between microservices?
- Ans.
Communication between microservices can happen through synchronous or asynchronous protocols like HTTP, messaging queues, or gRPC.
Microservices can communicate through synchronous protocols like HTTP, where one service sends a request to another service and waits for a response.
Alternatively, microservices can communicate asynchronously using messaging queues like RabbitMQ or Kafka, where messages are sent between serv...
- Q23. Internal working of messaging between microservices.
- Ans.
Messaging between microservices involves communication through message brokers or direct API calls.
Microservices communicate through message brokers like RabbitMQ or Kafka.
Messages are sent in a format like JSON or XML.
Microservices can also communicate through direct API calls using REST or gRPC.
Message queues help in decoupling services and ensuring reliable communication.
Service discovery mechanisms like Consul or E
- Q24. Coding problem - Find the maximum and minimum sum after removing one element from an array. (what is the time complexity of the program?)
- Ans.
Find max and min sum after removing one element from array. Time complexity analysis required.
Iterate through array to find sum of all elements
For each element, calculate sum after removing it
Track max and min sum as you iterate
Time complexity: O(n) where n is the number of elements in the array
Interview Preparation Tips
Core Java, Java Generics, Spring Boot, Web Services, ORM, JMS, and Microservice Architecture.
Good to know about CI/CD and Vaadin.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
Test Paper Task, which is to be given in a Word Document.
1. WireFraming
2. User Story Writing
3. Use Case
4. Sequence Diagram
(19 Questions)
- Q1. Education Background and Work Experience
- Q2. How Educational Background Helped in IT Industry
- Ans.
Educational background in IT industry provides foundational knowledge, skills, and problem-solving abilities.
Educational background in computer science or related field helps in understanding technical concepts and languages used in IT industry.
Analytical and critical thinking skills acquired through education are essential for analyzing data and solving complex problems in IT projects.
Project management and communicat...
- Q3. 4 Requirement Development Component required in Req. gathering phases
- Ans.
Requirement development components in requirement gathering phases
Stakeholder analysis
Interviews with stakeholders
Document analysis
Observations
Prototyping
Brainstorming sessions
- Q4. What are Requirement Elicitation technique
- Ans.
Requirement elicitation techniques are methods used to gather and clarify requirements from stakeholders.
Interviews with stakeholders to understand their needs and expectations
Surveys and questionnaires to collect feedback from a larger group of stakeholders
Observations of current processes or systems to identify areas for improvement
Prototyping to visualize requirements and gather feedback early in the process
Brainsto...
- Q5. What is the next step after requirement gathering
- Ans.
The next step after requirement gathering is analyzing the gathered requirements to identify patterns, prioritize needs, and create a solution.
Analyze the gathered requirements to identify patterns and common themes
Prioritize the needs and requirements based on business goals and constraints
Create a solution design or proposal that addresses the identified requirements
Collaborate with stakeholders to validate the propo
- Q6. Difference between Validation & Verification
- Ans.
Validation ensures the product meets the customer's requirements, while verification ensures the product is built correctly.
Validation is checking if the right product is being built, while verification is checking if the product is being built right.
Validation involves evaluating the product against customer requirements, while verification involves checking the product against specifications.
Validation is subjective ...
- Q7. What is [project initiation plan
- Ans.
A project initiation plan is a document that outlines the objectives, scope, and deliverables of a project.
Defines the purpose and goals of the project
Identifies key stakeholders and their roles
Outlines the project scope and constraints
Includes a high-level timeline and budget estimate
Provides a roadmap for project execution
- Q8. Roles of different Stakeholders in the Business Analysis process
- Ans.
Stakeholders in business analysis include project sponsors, end users, developers, and testers.
Project sponsors provide funding and support for the project.
End users provide input on requirements and usability.
Developers implement the solutions based on requirements.
Testers ensure the quality of the final product.
Other stakeholders may include managers, customers, and regulatory bodies.
- Q9. What is RACI metrics
- Ans.
RACI metrics are used to define roles and responsibilities within a project or organization.
RACI stands for Responsible, Accountable, Consulted, and Informed
It helps clarify who is responsible for what tasks and decisions
Example: R - John is responsible for data analysis, A - Sarah is accountable for project success, C - Mark is consulted for technical expertise, I - Emily is informed of project updates
- Q10. What is RTM metrics
- Ans.
RTM metrics refer to the metrics used to track and measure the requirements traceability matrix.
RTM metrics help in tracking the progress of requirements throughout the project lifecycle.
They measure the coverage of requirements, identify gaps, and ensure all requirements are met.
Examples of RTM metrics include requirement status (e.g. implemented, in progress, pending), requirement source, and requirement priority.
- Q11. What is the MoSCoW matrix
- Ans.
MoSCoW matrix is a prioritization technique used in project management to categorize requirements into Must have, Should have, Could have, and Won't have.
MoSCoW stands for Must have, Should have, Could have, and Won't have
Must have - essential requirements that are critical for project success
Should have - important requirements that are high priority but not critical
Could have - desirable requirements that are nice to...
- Q12. How to prioritize the requirement
- Ans.
Requirements should be prioritized based on business value, impact on stakeholders, and feasibility.
Identify and prioritize requirements that align with the organization's strategic goals.
Consider the impact on stakeholders and prioritize requirements that address their needs.
Assess the feasibility of implementing each requirement and prioritize those that are achievable within constraints.
Use techniques like MoSCoW pr...
- Q13. What are the use cases
- Ans.
Use cases are specific scenarios where a product or service can be used to solve a particular problem or achieve a specific goal.
Identifying business needs and requirements
Improving processes and workflows
Enhancing decision-making through data analysis
Optimizing resource allocation
Increasing customer satisfaction
Reducing costs and increasing efficiency
- Q14. What does it mean by 'Alternate flow of Use Cases'
- Ans.
Alternate flow of Use Cases refers to scenarios in which the main flow of a use case is deviated due to certain conditions or exceptions.
Alternate flow describes deviations from the main flow of a use case
It represents different paths that a use case can take based on conditions or exceptions
These alternate flows are usually documented to ensure all possible scenarios are considered
Examples include error handling, vali...
- Q15. How JIRA is used in project management
- Ans.
JIRA is a project management tool used for tracking tasks, issues, and progress in projects.
JIRA allows users to create and assign tasks to team members
It provides a centralized platform for tracking project progress and deadlines
Users can create custom workflows and dashboards to visualize project status
JIRA integrates with other tools like Confluence and Bitbucket for seamless collaboration
- Q16. Ever Worked on pre-sales? (Effort & Cost estimation)
- Ans.
Yes, I have experience working on pre-sales efforts and cost estimation.
I have worked on creating proposals and estimates for potential clients
I have experience analyzing requirements and determining the effort needed for a project
I have collaborated with sales teams to provide accurate cost estimates
I have used tools and techniques such as cost-benefit analysis and risk assessment in pre-sales activities
- Q17. Explain the previous project where you worked
- Ans.
Implemented a data analytics solution for a retail company to optimize inventory management
Analyzed historical sales data to identify trends and patterns
Developed predictive models to forecast demand and optimize inventory levels
Collaborated with cross-functional teams to implement the solution and train end users
- Q18. What is Business Process Modeling
- Ans.
Business Process Modeling is the visual representation of a business process to analyze, improve, and optimize its efficiency.
It involves creating diagrams or flowcharts to illustrate the steps, activities, and decisions involved in a business process.
Business Process Modeling helps in identifying bottlenecks, redundancies, and inefficiencies in a process.
It can be used to simulate different scenarios and analyze the i...
- Q19. This company is in the Power Sector, How will you work in this new domain?
- Ans.
I will leverage my analytical skills to understand the unique challenges and opportunities in the Power Sector and collaborate with stakeholders to drive effective solutions.
Conduct thorough research on the Power Sector to understand industry trends, regulations, and key players
Collaborate with internal teams and stakeholders to gather requirements and identify pain points
Utilize data analysis and modeling techniques t...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
(10 Questions)
- Q1. Tell me about yourself, and project architecture. What are your day-to-day responsibilities?
- Ans.
I am a Data Engineer with experience in designing and implementing project architectures. My day-to-day responsibilities include data processing, ETL tasks, and ensuring data quality.
Designing and implementing project architectures for data processing
Performing ETL tasks to extract, transform, and load data into the system
Ensuring data quality and integrity through data validation and cleansing
Collaborating with cross-...
- Q2. SQL: To calculate the difference in marks for each student ID and marks across different years?
- Ans.
Use SQL to calculate the difference in marks for each student ID across different years.
Use a self join on the table to compare marks for the same student ID across different years.
Calculate the difference in marks by subtracting the marks from different years.
Group the results by student ID to get the difference in marks for each student.
- Q3. SQL: Statewise which gender purchase is the most?
- Ans.
The answer to the question is that in which state which gender makes the most purchases.
Aggregate the data by state and gender to calculate the total purchases made by each gender in each state.
Identify the gender with the highest total purchases in each state.
Present the results in a table or chart for easy visualization.
- Q4. What is ADF ??
- Ans.
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
ADF is used for building, scheduling, and monitoring data pipelines to move and transform data from various sources to destinations.
It supports data integration between various data stores such as Azure SQL Database, Azure Blob Storage, and on-premises data sources.
ADF provides a visu...
- Q5. Pysaprk Coding Question?
- Q6. What is DAG ??
- Ans.
DAG stands for Directed Acyclic Graph, a data structure used to represent dependencies between tasks in a workflow.
DAG is a collection of nodes connected by edges, where each edge has a direction and there are no cycles.
It is commonly used in data engineering for representing data pipelines and workflows.
DAGs help in visualizing and optimizing the order of tasks to be executed in a workflow.
Popular tools like Apache Ai...
- Q7. What is Lineage ??
- Ans.
Lineage refers to the history and origin of data, including its source, transformations, and dependencies.
Lineage helps in understanding how data is generated, processed, and transformed throughout its lifecycle.
It tracks the flow of data from its source to its destination, including any intermediate steps or transformations.
Lineage is important for data governance, data quality, and troubleshooting data issues.
Example...
- Q8. How does Spark handle fault tolerance?
- Ans.
Spark handles fault tolerance through resilient distributed datasets (RDDs) and lineage tracking.
Spark achieves fault tolerance through RDDs, which are immutable distributed collections of objects that can be rebuilt if a partition is lost.
RDDs track the lineage of transformations applied to the data, allowing lost partitions to be recomputed based on the original data and transformations.
Spark also replicates data par...
- Q9. There are four cores and four worker nodes in Spark. How many jobs will run in parallel?
- Ans.
Only one job will run in parallel in Spark with four cores and four worker nodes.
In Spark, each core can only run one task at a time, so with four cores, only four tasks can run concurrently.
Since there are four worker nodes, each with four cores, a total of four tasks can run in parallel.
Therefore, only one job will run in parallel in this scenario.
- Q10. What are the optimisation techniques you have used in your project ?
- Ans.
I have used techniques like indexing, query optimization, and parallel processing in my projects.
Indexing: Used to improve the speed of data retrieval by creating indexes on columns frequently used in queries.
Query optimization: Rewriting queries to improve efficiency and reduce execution time.
Parallel processing: Distributing tasks across multiple processors to speed up data processing.
Caching: Storing frequently acce...
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Jul 2024. There were 4 interview rounds.
(3 Questions)
- Q1. JavaScript concepts
- Q2. JavaScript coding
- Q3. Angular questions
(2 Questions)
- Q1. Angular questions
- Q2. Angular implementation explanation
- Ans.
Angular implementation explanation
Angular is a popular front-end framework for building web applications
Uses TypeScript for development
Components, services, modules, and directives are key concepts in Angular
Data binding, dependency injection, and routing are important features
Example: Creating a new component in Angular - ng generate component my-component
(1 Question)
- Q1. Casual questions and discussion
(1 Question)
- Q1. Salary discussion and casual discussion
Skills evaluated in this interview
(2 Questions)
- Q1. Multi module maven project
- Q2. Selenium project structure
- Ans.
Selenium project structure includes organizing test cases, page objects, utilities, and configuration files.
Test cases should be organized in a separate folder
Page objects should be stored in a separate package
Utilities like helper classes, constants, and drivers should be in a separate package
Configuration files like properties files should be stored in a separate folder
Follow a modular approach for easy maintenance a
(2 Questions)
- Q1. How will you create a test plan ?
- Ans.
A test plan is created by defining objectives, scope, resources, schedule, and approach for testing.
Define objectives and scope of testing
Identify resources needed for testing
Establish a schedule for testing activities
Outline the approach and methodologies for testing
Include risk assessment and mitigation strategies
Document test scenarios, test cases, and test data
Define roles and responsibilities of team members
- Q2. Scenario based questions
Skills evaluated in this interview
React Native Developer Interview Questions & Answers
Extended Web AppTech
Anonymous
posted on 13 Sep 2024
(2 Questions)
- Q1. React basic questions
- Q2. Javascript and api
Selected
I applied via campus placement at Jagan Institute of Management Studies (JIMS) and was interviewed in Feb 2024. There was 1 interview round.
(3 Questions)
- Q1. What is Ecommerce
- Ans.
Ecommerce is the buying and selling of goods and services over the internet.
Ecommerce involves online transactions between businesses and consumers
It includes online retail stores like Amazon and eBay
Ecommerce platforms facilitate the buying and selling process
Payment gateways ensure secure transactions
- Q2. Give advantage and disadvantage of E-commerce
- Ans.
Advantages and disadvantages of E-commerce
Advantage: Increased reach and accessibility to a global market
Advantage: Lower overhead costs compared to traditional brick-and-mortar stores
Advantage: Ability to personalize marketing and target specific customer segments
Disadvantage: Security concerns related to online transactions and data breaches
Disadvantage: Lack of physical interaction with products before purchase
Disad...
- Q3. What is H lookup and V lookup
- Ans.
H lookup and V lookup are functions in Excel used to search for a value in a table and return a corresponding value.
H lookup stands for horizontal lookup and searches for a value in the first row of a table and returns a value in the same column.
V lookup stands for vertical lookup and searches for a value in the first column of a table and returns a value in the same row.
Both functions are commonly used in Excel for da...
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Feb 2024. There were 3 interview rounds.
Basic aptitude test.
They’ll give you some situations related to sales and up selling and will ask you to make a videos on that scenario to check your selling skills.
(1 Question)
- Q1. Managerial round with their senior manager.
Interview Preparation Tips
Selected
I applied via Indeed and was interviewed in Aug 2023. There were 4 interview rounds.
(4 Questions)
- Q1. Questions on basic PixiJs stuff and stuff about OOP.
- Q2. What is the use of Loader?
- Ans.
Loader is used to load external assets such as images, sounds, and data into a game or application.
Load images, sounds, and data from external sources into the game or application
Improve loading times by preloading assets before they are needed
Handle loading errors and provide feedback to the user
Examples: loading character sprites, background music, level data
- Q3. What is the use of Interface in TypeScript?
- Ans.
Interfaces in TypeScript are used to define the structure of objects. They provide a way to enforce a certain shape on objects.
Interfaces allow us to define the structure of an object by specifying the properties and their types.
Interfaces can be used to enforce a certain shape on objects, ensuring that they have the required properties.
Interfaces can also be used for type checking and to provide better documentation f...
- Q4. What is object pooling?
- Ans.
Object pooling is a design pattern where a set of objects are created and reused instead of creating new instances.
Improves performance by reducing memory allocation and deallocation overhead
Objects are kept in a pool and reused when needed
Commonly used in game development for frequently created and destroyed objects
Asked about previous projects and given a task to make a simple circle and change its color to a random color on click using pixiJS .
(1 Question)
- Q1. HR round was basic discussion on my prvs work and what I know about gammastack and stuff.
System Analyst Interview Questions & Answers
Foiwe Info Global Solution
Anonymous
posted on 24 Apr 2024
Aptituide consists of 20 simple questions
GD round was done among 10 people in each grouup in any 1 topic of our choice
(2 Questions)
- Q1. Asked about my strengths and weakness, ability to relocate, anf some direct scenarios
- Q2. Strength and weakness
Interview Preparation Tips
Ethics Infotech Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Business Analyst Interview Questions
- Senior Associate Interview Questions
- Sales Executive Interview Questions
- Senior Engineer Interview Questions
- Consultant Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Java Developer Interview Questions
- Show more
Interview Questions from Similar Companies
Ethics Infotech Reviews and Ratings
based on 18 reviews
Rating in categories
|
Software Developer
8
salaries
|  ₹1.4 L/yr - ₹4.5 L/yr |
|
Software Engineer
4
salaries
| ₹3 L/yr - ₹7.4 L/yr |
|
Softwaretest Engineer
4
salaries
| ₹1.5 L/yr - ₹3.5 L/yr |
|
Software Tester
4
salaries
| ₹2.6 L/yr - ₹4.5 L/yr |
|
Admin & HR Executive
4
salaries
| ₹2.9 L/yr - ₹3 L/yr |
Infosys
TCS
Wipro
HCLTech
- Home >
- Interviews >
- Ethics Infotech Interview Questions
