i
Saviant Consulting
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in May 2023. There were 3 interview rounds.
I am a DOT NET Developer with expertise in C#, ASP.NET, MVC, SQL Server, and Entity Framework.
Proficient in C# programming language
Experience with ASP.NET and MVC frameworks
Skilled in working with SQL Server and Entity Framework
Use recursion to print numbers from 100 to 1 without using loops.
Create a recursive function that prints the number and calls itself with the next number until reaching 1.
Base case should be when the number is 1, then stop recursion.
Example: void printNumbers(int n) { if(n == 0) return; print(n); printNumbers(n-1); }
Reverse words in a given string
Split the string into an array of words
Reverse each word in the array
Join the reversed words back into a string
LEFT Join example in LINQ and SQL
In LINQ, use the 'DefaultIfEmpty' method to perform a LEFT JOIN
In SQL, use the 'LEFT JOIN' keyword to combine rows from two tables based on a related column
Abstraction focuses on hiding complex implementation details, while encapsulation bundles data and methods into a single unit.
Abstraction allows us to focus on the essential features of an object while hiding unnecessary details. For example, a car can be abstracted as a vehicle with properties like speed and color.
Encapsulation involves bundling data and methods that operate on the data into a single unit. For example...
Filters in MVC are used to perform logic before or after an action method is executed.
Filters can be used for authentication, authorization, logging, exception handling, etc.
Examples include Authorize filter for restricting access to certain actions, HandleError filter for handling exceptions, etc.
There are multiple ways to send data from View to controller in ASP.NET MVC, including form submission, AJAX calls, query strings, and model binding.
Form submission using HTML forms
AJAX calls using jQuery or other JavaScript libraries
Query strings in the URL
Model binding in ASP.NET MVC
Clustered indexes physically reorder the data in the table, while non-clustered indexes create a separate structure.
Clustered indexes determine the physical order of data rows in a table.
Non-clustered indexes create a separate structure that contains a copy of the indexed columns and a pointer to the actual data rows.
Tables can have only one clustered index, but multiple non-clustered indexes.
Clustered indexes are fast...
ACID is a set of properties that guarantee database transactions are processed reliably.
ACID stands for Atomicity, Consistency, Isolation, Durability.
Atomicity ensures that all operations in a transaction are completed successfully or none at all.
Consistency ensures that the database remains in a consistent state before and after the transaction.
Isolation ensures that transactions are executed independently without int...
Implementing a new feature to automate data migration process
Developing a custom data migration tool using C# and SQL Server
Creating scripts to extract data from legacy system and load into new system
Testing the tool with sample data to ensure accuracy and efficiency
I test features after implementation by conducting unit tests, integration tests, regression tests, and user acceptance tests.
Conduct unit tests to ensure individual components work correctly
Perform integration tests to check interactions between components
Run regression tests to verify that new features do not break existing functionality
Conduct user acceptance tests to ensure the feature meets user requirements
I follow OOPS concepts by using inheritance, encapsulation, polymorphism, and abstraction in my code.
I use classes and objects to encapsulate data and behavior.
I utilize inheritance to create a hierarchy of classes with shared attributes and methods.
I implement polymorphism by overriding methods in derived classes.
I apply abstraction to hide complex implementation details from the user.
Database is connected using Entity Framework in current project. Yes, we can update multiple databases using DbSet.
Database is connected using Entity Framework which provides a data access layer for interacting with the database.
DbSet is a collection of entities that can be queried, updated, inserted, and deleted in the database.
By using DbSet, we can update multiple databases by specifying the database context for eac...
I applied via Company Website and was interviewed in May 2023. There were 5 interview rounds.
Saviant Consulting interview questions for popular designations
I applied via Approached by Company and was interviewed before Jan 2024. There were 4 interview rounds.
I was interviewed before May 2023.
I applied via Referral and was interviewed before Apr 2023. There was 1 interview round.
I applied via Naukri.com and was interviewed in Dec 2021. There was 1 interview round.
Top trending discussions
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
Some of the top questions asked at the Saviant Consulting interview -
based on 8 interviews
Interview experience
based on 38 reviews
Rating in categories
8-14 Yrs
Not Disclosed
4-8 Yrs
₹ 9-14.8 LPA
Solution Engineer
84
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Developer
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
14
salaries
| ₹0 L/yr - ₹0 L/yr |
Quality Analyst
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Technology Consultant
11
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech