Senior .NET Developer for Insurance Project (5+ years)

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

We are looking for a Senior .NET Developer with 4+ years of experience to join our growing team. The ideal candidate should have deep expertise in C#, ASP.NET Core/.NET Framework and API development. You will play a crucial role in designing, developing, and optimizing robust applications while mentoring junior developers and ensuring best coding practices. 

Key Responsibilities: 

• Architect, design, develop, and maintain scalable .NET applications using C# and ASP.NET Core/.NET Framework. 
• Design and implement RESTful APIs to facilitate seamless data exchange. 
• Optimize database queries and work with SQL databases for high-performance applications. 
• Conduct code reviews, enforce best practices, and mentor junior developers. 
• Debug, troubleshoot, and enhance existing applications for improved efficiency. 
• Work closely with cross-functional teams to define requirements and deliver high-quality solutions. 
• Stay updated with emerging .NET technologies and contribute to process improvements. 

Required Skills & Qualifications: 

• 4+ years of hands-on experience in .NET development. 
• Expertise in C#, ASP.NET Core/.NET Framework, and API development. 
• Solid understanding of OOP principles, SOLID design patterns, and best coding practices. 
• Experience with SQL databases, query optimization, and stored procedures. 
• Proficiency in Git or other version control systems. 
• Strong problem-solving skills and ability to troubleshoot complex issues. 
• Exposure to Agile methodologies and DevOps practices. 

• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (Model-View-Controller (MVC)
• 5 years of development experience using C# .NET
• Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Strong attention to detail
• Excellent troubleshooting and communication skills
• Knowledge of REST and RPC APIs
• Able to work well in a team setting

Detailed JD

Requirements and Skills

• Actively participate in Agile ceremonies (Standups, Refinements, Retrospectives, Planning, and Requirement discussions)
• Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders
•  Provide innovative solutions to complex problems
• Design, develop and modify software applications/systems according to specifications
•  Develop technical documentation including services, object, and data model
• Create high-quality code and perform code reviews
•  Create unit and integration tests to ensure the code quality and functionality
•  Proactively learn and share knowledge of technology and compare the advantages and disadvantages of alternative solutions/technologies
• Help onboard new team members.

Salary ranges from 20 LPA onwards; negotiable based on experience

Mandatory Skills Required:

▪ ASP.NET & .NET Core, C#, NET 2.0 Web Services, OAuth 2.0 (JWT)

▪ Sitecore 9 and 10, Sitecore MVC, Sitecore JSS, Content Hub, Digital Asset Manager, Product Catalog Manager, Sitecore Experience Manager, Experience Platform, Customer Data Management

▪ Good working knowledge of CI/CD environments (preferably Azure DevOps), Git or similar confuration management software

Required Experience: 
▪ Bachelor's degree in Computer Science or Computer Engineering from an accredited university
▪ 5+ years of relevant industry experience
▪ Must have worked with industry leading Content Management systems; certification in Sitecore is a must
▪ Strong fundamentals in Software Architecture & Software Engineering - OOP, RESTful architectures, Design Patterns, Data Structures, Algorithms
▪ Experience with RESTful API development, Open API specification ▪ Experience with Microservices Development; working on Docker, Kubernetes
▪ Experience analyzing and tuning application performance

Primary responsibilities include : 
1. Leading a small team of software engineers and, also contributing individually to design, develop and test software for cloud, web and mobile
2. Design, develop, test and document quality software to user and functional requirements within specified timeframes and in accordance with CNHI coding standards
3. Design and implement complex real-time data visualization technologies
4. Generate rapid prototypes for feasibility testing
5. Generate all documentation relevant to software operation
6. Adhere to prescribed development systems, processes procedures and ensure efficient, effective,high quality delivery
7. Contribute to the improvement of development systems, processes, procedures
8. Contribute to growing team members, building a strong cohesive team; provide guidance, mentorship
9. Communicate effectively with all stakeholders
10. Perform tasks as specified by the Delivery Lead/Team Lead

• Experience in Asp .NET Core,EF Core, Asp .NET Core Blazor, ASP .NET MVC, C#
• Should have experience of all aspects of Software Development Life Cycle
• Excellent problem solver, able to assimilate formation quickly
• Excellent communication skills, oral and written
• Technical expertise: Demonstrates knowledge and experience in .net development
• Strong team player; work effectively in groups; and help others to get the job done
• Decision making: ability to analyze, integrate, evaluate and make decisions
• Motivation: Establish and communicate vision. Demonstrate enthusiasm and excitement
• toward achieving project goals
• High quality standards: accuracy, proficient and thoroughness in unit testing
• Time Management: Completes work in a timely manner to meet production deadlines
• Organizational skills: Ability to establish priorities for projects to meet goals
• 4+ years’ experience in .Net .

Responsibilities:

• Follow proper coding standards, application architecture guidelines and procedural guidelines
• Manage entire asp.net team and direct communication with client along with project manager

Apart from compensation, we are welcoming with:

• Unique Growth Opportunities.
• We will provide training based on Project Requirement
• You will learn directly from expert developers in the field.
• You will get an opportunity to work on the complete lifecycle of projects
• You will get an opportunity to work on multiple technologies.
• Discretionary Bonus.
• Work from Home, Flexible Timings, Paid Vacation and much more!
• Work Days: Monday to Friday.

 Immediate joiners preferred