.NET Developer (x4)

Direct Hire

$80k

Per internal recruiter: Apparently they have decided to combine the two into one description, but we have two .Net and one SQL Developer vacancies

·         Experience with ASP.NET, MVC, HTML5 CSS, Bootstrap & Java Script

·         Experience in Stored Procedure, TSQL (must)

·         Experience with basic ETL processes & SSIS

·         Ability to develop and interpret complex queries, understand database design as well as performance techniques related to data growth and scalability. Debugging of application exceptions and error conditions

·         Provide support thru engaging in incidents, on-watch calls, support of production releases, escalations from Operations

·         Must enjoy communicating with clients in a consistent, energetic and professional manner.

·         Excellent analytical, problem solving and troubleshooting abilities

·         Participate in triage calls and in-depth research and analysis of production incidents/tickets

·         Prior exposure to building or supporting solutions for Managed Medicare / Medicaid is a plus

·         Must have excellent written and oral skills

·         Collaborate with operations, product management, quality assurance and business teams.

·         Work well in a small group with a fast-paced environment.

Basic .Net and Sql Server Interview Questions

What are Session state modes in ASP.NET?

Answer: In-Process, StateServer, SQLServer, Custom

What Are action Filters in Asp.Net MVC

Answer: If we need to apply some specific logic before or after action methods, we use action filters. We can apply these action filters to a controller or a specific controller action. Action filters are basically custom classes that provide a mean for adding pre-action or post-action behavior to controller actions.

What is a ViewEngine in ASP.NET MVC?

Answer: View Engine in ASP.NET MVC is used to translate our views to HTML and then render to browser

What is the difference between constant and read only in c#?

Answer: Constant is known as “const” keyword in C# which is also known immutable values which are known at compile time and do not change their values at run time like in any function or constructor for the life of application till the application is running.

Readonly is known as “readonly” keyword in C# which is also known immutable values and are known at compile and run time and do not change their values at run time like in any function for the life of application till the application is running. You can assay their value by constructor when we call constructor with “new” keyword.

 

Can “this” be used within a static method?

Answer: No

What is IEnumerable<> in c#?

Answer:  IEnumerable is the parent interface for all non-generic collections in System.Collections namespace like ArrayList, HastTable etc. that can be enumerated. For the generic version of this interface as IEnumerable which a parent interface of all generic collections class in System.Collections.Generic namespace like List<> and more.

What is difference between truncate and delete?

DELETE
1. DELETE is a DML Command.
2. DELETE statement is executed using a row lock, each row in the table is locked for deletion.
3. We can specify filters in where clause
4. It deletes specified data if where condition exists.
5. Delete activates a trigger because the operation are logged individually.
6. Slower than truncate because, it keeps logs.
7. Rollback is possible.

TRUNCATE
1. TRUNCATE is a DDL command.
2. TRUNCATE TABLE always locks the table and page but not each row.
3. Cannot use Where Condition.
4. It Removes all the data.
5. TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions.
6. Faster in performance wise, because it doesn't keep any logs.
7. Rollback is not possible.

What is the difference between union and union all?

Answer: The difference between UNION and UNION ALL is that UNION will omit duplicate records whereas UNION ALL will include duplicate records.

What is the difference between ViewState and SessionState?

Answer:  ViewState’ is specific to a page in a session.

             ‘SessionState’ is specific to user specific data that can be accessed across all pages in the web application.

 

What are different Types of Constructors in c#.?

Answer:

1. Default Constructor

2. Parameterized Constructor

3. Copy Constructor

4. Static Constructor