Ellicium Solutions Senior Software Engineer Interview Questions and Answers

Q1. Rpgle, SqlRpgle questions
Add your answer

Q1. Sql and debugging related questions
Add your answer

Q1. Asked about previous job experience and expectations from current job
Add your answer

Q1. Pagination in SQL
Ans. 
Pagination in SQL allows for displaying a subset of query results at a time.
• Use LIMIT and OFFSET clauses in SQL queries to implement pagination.

• LIMIT specifies the maximum number of rows to return.

• OFFSET specifies the number of rows to skip before starting to return rows.
Answered by AI
Add your answer
Q2. OOPS concepts.. SOILD design principles
Add your answer
Q3. Thread vs task in multiprocessing.. explain with examples
Ans. 
Threads and tasks are both used in multiprocessing, but have different characteristics and use cases.
• Threads are lightweight processes within a single process, sharing memory space. They are managed by the operating system.

• Tasks are units of work that can be executed asynchronously. They are typically managed by a task scheduler.

• Threads are suitable for parallel processing and improving performance, while tasks are use...read more
Answered by AI
Add your answer
Q4. ViewBag vs Tempdata in MVC
Ans. 
ViewBag is used to pass data from controller to view, while TempData is used to pass data between controller actions.
• ViewBag is a dynamic property that allows you to pass data from controller to view

• TempData is a dictionary object that allows you to pass data between controller actions

• ViewBag is not type-safe and requires typecasting, while TempData is type-safe

• ViewBag data is lost if redirection occurs, while TempData...read more
Answered by AI
Add your answer
Q5. Abstract vs Interface
Ans. 
Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.
• Abstract classes can have constructors, fields, and non-abstract methods.

• Interfaces can only have abstract methods and constants.

• A class can implement multiple interfaces but can only inherit from one abstract class.
Answered by AI
Add your answer

Q1. Tell me your project details
Ans. 
Developed a web application for online shopping with user authentication and payment gateway integration.
• Used React.js for front-end development

• Implemented user authentication using JWT tokens

• Integrated Stripe API for payment processing
Answered by AI
Add your answer

Q1. Oops concepts explained
Add your answer

Q1. Optimization Techniques
Ans. 
Optimization techniques are methods used to improve the efficiency and performance of software applications.
• Use of algorithms like dynamic programming and greedy algorithms

• Profiling and performance tuning to identify bottlenecks

• Code refactoring to improve readability and maintainability

• Utilizing caching and memoization for faster access to data

• Parallel processing and multi-threading for improved concurrency
Answered by AI
Add your answer

Competitive Programming

Q1. Java Basics, and related framework basics in depth
Add your answer

Q1. Design Patterns and Design Principles
Ans. 
Design patterns and principles are essential for creating maintainable and scalable software.
• Design patterns are reusable solutions to common software problems.

• Design principles are guidelines for creating software that is easy to maintain and extend.

• Examples of design patterns include Singleton, Factory, and Observer.

• Examples of design principles include SOLID, DRY, and KISS.
Answered by AI
Add your answer

Q1. How you make yourself up to date with latest technologies
Ans. 
I stay up to date with the latest technologies by attending conferences, reading tech blogs, and participating in online forums.
• Attending conferences and tech events

• Reading tech blogs and articles

• Participating in online forums and communities

• Taking online courses and tutorials

• Experimenting with new technologies in personal projects
Answered by AI
Add your answer

Q1. Java Spring Boot SQL
Add your answer

Q1. Java Spring Boot AWS SQL Jenkins Kafka Git
Add your answer

Q1. Why Morningstar, and what is your background
Add your answer

Q1. Java Spring Boot AWS SQL Jenkins Kafka Git
Add your answer

Q1. Why Morningstar, and what is your background
Add your answer

Q1. Arraylist find duplicate
Ans. 
Find duplicates in an ArrayList of strings.
• Iterate through the ArrayList and use a HashSet to keep track of seen elements.

• If an element is already in the HashSet, it is a duplicate.

• Store the duplicates in a separate ArrayList or print them directly.
Answered by AI
Add your answer

Hackathon Test with 2 medium level coding question.

Technical Video Interview- Java concepts mostly related to Java 8, 1 coding program and some db questions were asked.

Q1. Questions related to System Design.
Add your answer

Q1. Questions related to my projects . Some questions related to my current role and responsibilities.
Add your answer