3 Ado .Net Jobs

5 + years of experience in Microsoft .NET , Framework 4.0 OR above, C#, ASP.NET, ADO.NET, Web services/WCF, MS SQL. Design and develop Conceptual, Logical and Physical Data Model using Microsoft .NET Technologies such as C# , ASP.NET, ADO.NET, WEB SERVICES/WCF, MS SQL . Experience in front-end technology - Angular and jQuery.

In this role, you will: Lead moderately complex initiatives and deliverables within technical domain environments Contribute to large scale planning of strategies Design, code, test, debug, and document for projects and programs associated with technology domain, including upgrades and deployments Review moderately complex technical challenges that require an in-depth evaluation of technologies and procedures Resolve moderately complex issues and lead a team to meet existing client needs or potential new clients needs while leveraging solid understanding of the function, policies, procedures, or compliance requirements Collaborate and consult with peers, colleagues, and mid-level managers to resolve technical challenges and achieve goals Lead projects and act as an escalation point, provide guidance and direction to less experienced staff Required Qualifications: 4+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education Desired Qualifications: Knowledge on C# . NET, .NET Core, Microservices, ADO .NET, Entity Framework. Knowledge on AutoSys scheduling and troubleshooting, T-SQL, Macros, Excel. Knowledge on UI development, Jquery, SQL, MySQL, Azure, Jenkiens, Udeploy, PCF. Ability to assess issues, make quick decisions, implement solutions, and influence change Advanced Microsoft Office software, hardware, operating system knowledge. Experience working in a large enterprise environment Demonstrated ability to interact effectively with a variety of contacts including mid-level managers Project management/coordination experience. Responsible to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Excellent verbal, written, and interpersonal communication skills. Ability to assess issues, make quick decisions, implement solutions, and influence change. Ability to mentor team members to help them achieve maximum productivity. Design, develop and maintain new and existing code using C# ASP.NET Core MVC 5, Web API, ADO.NET, Entity Framework & LINQ to SQL for data retrieval. Strong development knowledge on .NET Core. Strong SQL development, stored procedures, views & function with experience ranging from Architecture to design and maintenance. Job Expectations: Assimilate information security requirements from product owners, understand relevant impacts and translate them into technical designs. Participate in scrum team meetings and ceremonies and provide daily documented updates in support of the team. Perform code and design reviews for peers within the organization. Develop unit testing scripts for deliverables. Provide change and incident support as required outside of normal business hours. Analytical thinker able to resolve ongoing issues or defects. Responsible to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Review all daily activities and ensure completion of shift duties and proper handover.

Job Description: We are seeking a skilled .NET Developer with expertise in C# language and experience working with MSSQL/POSTGRESQL databases. The ideal candidate will have additional knowledge of Entity Framework and ADO.NET, as well as proficiency in Git version control system. Experience working with .NET framework 6 and 7 is preferred. Responsibilities: Develop and maintain high-quality software applications using .NET technology stack. Design, code, test, and debug according to technical specifications. Collaborate with cross-functional teams to define, design, and ship new features. Participate in code reviews and provide constructive feedback to peers. Troubleshoot, debug, and resolve software defects as needed. Utilize Git for version control, including branching, merging, and repository management. Stay updated with emerging technologies and best practices in .NET development. Requirements: Bachelor's degree in Computer Science, Engineering, or related field. Proven experience as a .NET Developer or Software Engineer. Proficiency in C# language and working knowledge of MSSQL/POSTGRESQL databases. Excellent Debugging skills. Familiarity with Entity Framework and ADO.NET. Experience working with .NET framework versions 6 and 7. Strong problem-solving skills and attention to detail. Excellent communication and collaboration abilities. Experience working on Windows Forms, Web Forms, and APIs. SQL Questions What are DML, DDL queries? (Easy) DML (Data Manipulation Language) queries are used to manage data within schema objects, including SELECT, INSERT, UPDATE, DELETE. DDL (Data Definition Language) queries are used to define or modify database structures, including CREATE, ALTER, DROP. How many types of JOINS are there in SQL? (Easy) There are mainly four types of JOINs: INNER JOIN, LEFT JOIN (or LEFT OUTER JOIN), RIGHT JOIN (or RIGHT OUTER JOIN), FULL JOIN (or FULL OUTER JOIN). Difference between Tables, Views, Temp Tables, and CTE? (Hard) Tables : Store data permanently. Views : Virtual tables based on the result-set of an SQL query. Temp Tables : Temporary storage for data within the scope of a session or transaction. CTEs (Common Table Expressions) : Temporary result sets defined within the execution scope of a single SELECT, INSERT, UPDATE, or DELETE statement. What are stored procedures and SQL functions? (Medium) Stored Procedures : Precompiled collections of SQL statements and optional control-of-flow statements, which are stored under a name and processed as a unit. SQL Functions : Functions that perform calculations or actions and return a single value or table. C# Questions What is the first class called in C# at the time of execution? (Easy) The entry point is typically the Main method within a class, often named Program. What does the startup.cs class do? (Medium) Startup.cs configures services and the app's request pipeline in ASP.NET Core applications. What is type casting and what are the methods to do that in C#? (Easy) Type casting converts a variable from one type to another. Methods include explicit casting using parentheses, as keyword, and Convert class. What is a partial class? (Easy) Partial classes allow the definition of a class to be split across multiple files, enabling multiple developers to work on the same class simultaneously. What are static methods in C#? (Easy) Static methods belong to the class itself rather than to any specific object instance, meaning they can be called on the class itself without creating an instance. What are enums? (Easy) Enums (enumerations) are a distinct type that consists of a set of named constants called the enumerator list. Other Technical Questions What are APIs? (Very Easy) APIs (Application Programming Interfaces) allow different software systems to communicate with each other by defining a set of rules and protocols. What are different types of API methods and what are the differences? (Easy) Common API methods include GET, POST, PUT, DELETE, PATCH. GET retrieves data, POST submits data, PUT/PATCH updates data, and DELETE removes data. What is app.config and web.config? (Medium) app.config is used for application configuration settings in desktop apps, while web.config is used for web application settings in ASP.NET. How to write a Connection String? (Medium) A connection string typically includes the data source (server name/IP), database name, user ID, and password, e.g., "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;". What is RSA encryption technique? (Very Hard) RSA (Rivest-Shamir-Adleman) is an asymmetric encryption technique using a pair of public and private keys for secure data transmission. What is AES encryption technique? (Very Hard) AES (Advanced Encryption Standard) is a symmetric encryption technique that uses the same key for both encryption and decryption of data. What is the difference between date time data type and date time offset data type? (Medium) datetime stores date and time without time zone awareness, whereas datetimeoffset includes time zone information along with the date and time. What is type casting and what are the methods to do that in C#? (Easy) Type casting converts a variable from one type to another. Methods include explicit casting using parentheses, as keyword, and Convert class. What are different types of OOPS concepts? (Easy) Encapsulation : Bundling data with methods that operate on that data. Abstraction : Hiding complex implementation details and showing only the necessary features. Inheritance : Allowing a new class to take on properties and methods of an existing class. Polymorphism : Allowing methods to do different things based on the object it is acting upon, typically through method overriding and overloading.