Filter interviews by
I applied via Naukri.com and was interviewed in Jan 2024. There were 3 interview rounds.
Find the numeric values from given strong column. For given input find inner join, left join, right join. Dynamic SQL and temp table scenario based question.
SQL code to find Nth maximum salary department wise.
Use the RANK() function to assign a rank to each salary within each department.
Filter the results to only include the rows where the rank is equal to N.
Group the results by department to get the Nth maximum salary department wise.
Merge is a SQL statement used to combine data from two tables, merge join is a join operation in SSIS, union all is used to combine the result sets of two or more SELECT statements. Recursive CTE is a common table expression that references itself, cross apply is used to apply a table-valued function to each row of a table.
Merge: combines data from two tables
Merge join: join operation in SSIS
Union all: combines result ...
I have used multiple functions in SSAS for various purposes.
Some commonly used functions in SSAS include SUM, AVG, COUNT, MIN, MAX, and DISTINCT.
Functions can be used in measures, calculated columns, and calculated tables.
Examples of functions used in SSAS include SUM([Sales Amount]), COUNT([Customer ID]), and AVG([Rating]).
I applied via Approached by Company
Top trending discussions
I applied via Campus Placement and was interviewed before Sep 2019. There were 5 interview rounds.
C is a programming language used to create software and operating systems.
C is a low-level language that allows direct access to computer hardware.
It is used to create efficient and fast programs.
C is the foundation for many other programming languages such as C++, Java, and Python.
Examples of C programs include operating systems, device drivers, and video games.
My hobbies include hiking, photography, and cooking.
Hiking: I enjoy exploring nature trails and challenging myself physically.
Photography: I love capturing beautiful moments and landscapes through my camera lens.
Cooking: I find joy in experimenting with new recipes and creating delicious meals for my friends and family.
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
They have an Online Aptitude cum coding test which contains some 20-30 Question to be done in 3Hrs.
20 Questions of Aptitude and 10 Questions of coding(Which includes Display output and correct the program Questions)
Easy Interview lasting about 30-45 Mins
They mostly ask questions based on projects and they like to see some certifications.
DSA questions were easy to medium.
I applied via Naukri.com and was interviewed before Aug 2023. There was 1 interview round.
Approach debugging by understanding the code flow, using debugging tools, isolating the issue, and testing solutions.
Start by understanding the code flow and identifying potential areas where the issue may be occurring.
Use debugging tools like breakpoints, logging, and stack traces to pinpoint the source of the problem.
Isolate the issue by reproducing it consistently and narrowing down the scope of the problem.
Test pot...
Refactored a legacy codebase to improve performance by optimizing database queries.
Identified bottlenecks in the codebase by profiling and analyzing performance metrics.
Rewrote complex and inefficient database queries to improve response times.
Implemented caching mechanisms to reduce redundant database calls.
Refactored code to follow best practices and improve maintainability.
Tested the changes thoroughly to ensure the
By prioritizing tasks, using efficient algorithms, and conducting code reviews.
Prioritize tasks based on impact and complexity to focus on critical components first.
Utilize efficient algorithms and data structures to optimize code performance.
Conduct code reviews with team members to identify potential bottlenecks and suggest improvements.
Example: Prioritize implementing a caching mechanism for frequently accessed data
I would approach the situation by respectfully discussing the pros and cons of both solutions and finding a compromise.
Listen to the senior team member or client's perspective and understand their reasoning
Present your preferred solution along with the reasons why you believe it is the best approach
Engage in a constructive discussion to find common ground or a compromise
Consider the impact of each solution on the proje...
I regularly attend tech conferences, read industry blogs, participate in online courses, and collaborate with colleagues to stay updated.
Attend tech conferences to learn about new technologies and trends
Read industry blogs and articles to stay informed
Participate in online courses and tutorials to expand knowledge
Collaborate with colleagues to share insights and learn from each other
I use package managers, regularly update dependencies, and conduct security audits.
Utilize package managers like npm, pip, or Maven to manage dependencies
Regularly update dependencies to ensure compatibility and security patches
Conduct security audits using tools like OWASP Dependency-Check or Snyk
Consider using dependency locking to ensure consistent builds
I implemented a new feature using React Native and had to learn the framework on the job.
Researched online resources and documentation to understand React Native
Experimented with small projects to practice using React Native
Sought help from colleagues or online communities when facing challenges
Identified and addressed a potential bottleneck in a system before it became a problem.
Monitored system performance regularly to identify any potential bottlenecks
Analyzed system logs and metrics to pinpoint the root cause of the bottleneck
Implemented optimizations such as caching, indexing, or code refactoring to address the bottleneck
Collaborated with team members to implement a long-term solution to prevent similar
I prioritize tasks based on deadlines, impact, and dependencies, and use tools like to-do lists and project management software.
Evaluate deadlines and prioritize tasks that are due soon
Consider the impact of each task on the overall project or team goals
Identify dependencies between tasks and prioritize accordingly
Use tools like to-do lists, project management software, or time-blocking techniques to stay organized
Regu
I use consistent naming conventions, inline comments, and thorough documentation to ensure clean and well-documented code.
Follow consistent naming conventions for variables, functions, and classes to make the code easier to understand.
Include inline comments to explain complex logic or algorithms within the code.
Write thorough documentation for each function, class, and module to provide context and usage instructions ...
Approach integrating new feature into existing system without disruption
Analyze the existing system to understand its architecture and dependencies
Identify the impact of the new feature on the current functionality
Implement the new feature in a separate branch or environment for testing
Conduct thorough testing to ensure the new feature works as expected and does not break existing functionality
Gradually integrate the n...
I applied via Campus Placement and was interviewed in Jul 2021. There was 1 interview round.
posted on 19 Oct 2022
I applied via Campus Placement and was interviewed before Oct 2021. There were 4 interview rounds.
It was an online test where you to solve two basic programming problems.
It was a GD where 21 other candidates were present alongside me. The interviewer asked basic questions which we had to answer after raising our hands. It was on fcfs basis. The questions were mostly about basics OOPs concepts, arrays, linkedlist, tree, sorting, searching and time-space complexities. The difficulty of GD round is nominal. All you have to response first and clearly.
I applied via Naukri.com and was interviewed in Mar 2023. There were 2 interview rounds.
OOPs concepts in Java include inheritance, polymorphism, encapsulation, and abstraction.
Inheritance allows a subclass to inherit properties and methods from a superclass.
Polymorphism allows objects to take on multiple forms and behave differently based on their context.
Encapsulation hides the implementation details of an object and only exposes necessary information.
Abstraction allows for the creation of abstract class...
Interfaces define contracts for behavior, while inheritance allows for code reuse and polymorphism.
Interfaces allow for loose coupling and abstraction, enabling multiple implementations of the same behavior.
Inheritance allows for code reuse and extension of existing classes, reducing code duplication.
Polymorphism allows objects of different classes to be treated as if they were of the same class, simplifying code and i
SQL query for joining tables
Use JOIN keyword to combine two or more tables based on a related column
Specify the columns to be selected using SELECT keyword
Use ON keyword to specify the condition for joining the tables
Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
Used Java concepts such as inheritance, polymorphism, and exception handling in my project.
Implemented inheritance to create a base class and derived classes with specific functionalities.
Utilized polymorphism to allow objects of different classes to be treated as if they were of the same class.
Implemented exception handling to handle errors and prevent program crashes.
Used interfaces to define a set of methods that a ...
Overloading is having multiple methods with the same name but different parameters. Overriding is having a method in a subclass with the same name and parameters as a method in the superclass.
Overloading is used to provide different ways to call a method with different parameters
Overriding is used to provide a specific implementation of a method in a subclass
Overloading is resolved at compile-time while overriding is r...
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Normal apptitude queations were asked in this round
I applied via Campus Placement and was interviewed in Aug 2023. There were 3 interview rounds.
It was good. We were given two situation for which we have to find the solutions.
In this round companies offical started asking about the happening around us and their reasons.
based on 1 interview
Interview experience
Software Developer
12
salaries
| ₹5.8 L/yr - ₹13.5 L/yr |
Senior Software Developer
7
salaries
| ₹10.2 L/yr - ₹26 L/yr |
DOT NET Developer
4
salaries
| ₹9 L/yr - ₹13 L/yr |
HR & Administration Executive
3
salaries
| ₹4 L/yr - ₹4.8 L/yr |
Northcorp Software
Apex CoVantage
Appsierra
Teleindia Networks