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]).
Top trending discussions
I applied via Campus Placement and was interviewed in Jul 2021. There was 1 interview round.
First round is online test of 3 virtual rounds consist of aptitude , and coding
A singly linked list is a data structure where each element points to the next element in the list.
Each node in the list contains data and a reference to the next node
Traversal starts from the head node and follows the next pointers until the end
Insertion and deletion can be done efficiently at the beginning or end of the list
I applied via LinkedIn and was interviewed before Dec 2023. There were 2 interview rounds.
They just gave me an assessment with a few questions to test my subject knowledge
I was interviewed in Nov 2024.
The aptitude test evaluates problem-solving, coding skills, and logical reasoning, offering a fair challenge to showcase technical expertise.
I address conflicts in team projects by promoting open communication, active listening, and seeking compromise.
Encourage open communication among team members to address conflicts early on
Practice active listening to understand all perspectives and concerns
Seek compromise and find common ground to resolve conflicts effectively
Interface is a contract that defines the methods a class must implement, while an abstract class can have both implemented and abstract methods.
Interface can only have abstract methods and cannot have any implementation, while abstract class can have both abstract and implemented methods.
A class can implement multiple interfaces but can only inherit from one abstract class.
Interfaces are used to achieve multiple inheri...
posted on 11 Mar 2023
I applied via Campus Placement and was interviewed in Feb 2023. There were 2 interview rounds.
The test was very weird one.
They did have planned anything for the test, They came and given a link on bit.ly and given an another link that is in google form for the answers.
And they selection of people for second round is not sensible.
This round was also be a weird.
They give each candidates with different questions.
They told us to write logic on the paper and you can use internet for your reference.
But after this round they announced the results but that is not in genuine one.
posted on 18 Jun 2024
Medium level problem,
posted on 26 Jun 2024
I applied via Campus Placement and was interviewed in May 2024. There were 2 interview rounds.
45 min apps and technical question
45 min coding round you can refer net for first 15 min
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
Aptitude was to the point. Was Easy
Then there was an assignment where have to create a web project.
based on 1 interview
Interview experience
Software Developer
9
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Developer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
DOT NET Developer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
HR & Administration Executive
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Northcorp Software
Appsierra
Apex CoVantage
Avontix