.NET with Logic Apps

Senior Software Engineer – SQL Server / T-SQL

Chennai | IIT Madras Research Park | Full-Time

About Novacis Digital

Novacis Digital is a product-first technology company building AI-driven platforms and large-scale data systems. Our products process complex, high-volume data to power real-time analytics and GenAI-driven experiences.

We don’t see SQL as “just a database layer” - we treat it as a core compute engine. If you love writing efficient SQL and solving performance problems, this is the role for you.

What You Will Do

·      Design and build complex T-SQL stored procedures involving Dynamic SQL, along with views, functions, and triggers

·      Implement flexible, metadata-driven query frameworks using sp_executesql and parameterized Dynamic SQL

·      Engineer high-performance, set-based queries using CTEs, window functions, temp tables and table variables

·      Optimize queries using execution plans, statistics and DMVs

·      Refactor inefficient queries and redesign schemas for performance and scalability

·      Solve real-world challenges related to locks, blocking, deadlocks and transaction isolation

·      Collaborate with application engineers to build reliable, high-performance data access layers

What We’re Looking For

We’re looking for true SQL engineers — people who think in execution flow, logic and data behavior rather than just syntax.

You should have:

·      4+ years of deep hands-on experience with Microsoft SQL Server & T-SQL

·      Strong expertise in:

o  Stored Procedures (with Dynamic SQL)

o  Views

o  Functions

o  Triggers

·      Strong experience with:

o  Dynamic SQL best practices and secure execution patterns

o  Indexing strategies and query plan optimization

o  Handling parameter sniffing and plan instability

·      Strong knowledge of:

o  Temp tables vs table variables

o  Cardinality estimation

o  Cost-based optimization concepts

Nice to Have

·      Exposure to GenAI data pipelines or analytical architectures

·      Exposure to Graph, Vector and No SQL Databases

How We Work

·      We write production-grade T-SQL

·      We value performance, clarity, and correctness

·      We invest heavily in query readability and maintainability

·      Engineering quality is non-negotiable

Apply Now

If you enjoy designing complex Dynamic SQL-powered stored procedures and tuning systems at scale, we’d like to talk.

Integration Developer

ROLE TITLE

Integration Developer

ROLE LOCATION(S)

Bangalore/Hyderabad/Chennai/Coimbatore/Noida/Kolkata/Pune/Indore

ROLE SUMMARY

The Integration Developer is a key member of the operations team, responsible for ensuring the smooth integration and functioning of various systems and software within the organization. This role involves technical support, system troubleshooting, performance monitoring, and assisting with the implementation of integration solutions.

ROLE RESPONSIBILITIES

·       Design, develop, and maintain integration solutions using Spring Framework, Apache Camel, and other integration patterns such as RESTful APIs, SOAP services, file-based FTP/SFTP, and OAuth authentication.

·       Collaborate with architects and cross-functional teams to design integration solutions that are scalable, secure, and aligned with business requirements.

·       Resolve complex integration issues, performance bottlenecks, and data discrepancies across multiple systems. Support Production issues and fixes.

·       Document integration processes, technical designs, APIs, and workflows to ensure clarity and ease of use.

·       Participate in on-call rotation to provide 24/7 support for critical production issues.

·       Develop source code / version control management experience in a collaborative work environment.

TECHNICAL QUALIFICATIONS

·       5+ years of experience in Java development with strong expertise in Spring Framework and Apache Camel for building enterprise-grade integrations.

·       Proficient with Azure DevOps (ADO) for version control, CI/CD pipeline implementation, and project management.

·       Hands-on experience with RESTful APIs, SOAP services, and file-based integrations using FTP and SFTP protocols.

·       Strong analytical and troubleshooting skills for resolving complex integration and system issues.

·       Experience in Azure Services, including Azure Service Bus, Azure Kubernetes Service (AKS), Azure Container Apps, and ideally Azure API Management (APIM) is a plus.

·       Good understanding of containerization and cloud-native development, with experience in using Docker, Kubernetes, and Azure AKS.

·       Experience with OAuth for secure authentication and authorization in integration solutions.

·       Strong experience level using GitHub Source Control application.

·       Strong background in SQL databases (e.g., T-SQL, Stored Procedures) and working with data in an integration context.

·       Skilled with Azure DevOps (ADO) for version control, CI/CD pipeline implementation, and project management.

·       Experience in Azure Services, including Azure Service Bus, Azure Kubernetes Service (AKS), Azure Container Apps, and ideally Azure API Management (APIM) is a plus.

GENERAL QUALIFICATIONS

·       Excellent analytical and problem-solving skills, with a keen attention to detail.

·       Effective communication skills, with the ability to collaborate with technical and non-technical stakeholders.

·       Experience working in a fast paced, production support environment with a focus on incident management and resolution.

·       Experience in the insurance domain is considered a plus.

EDUCATION REQUIREMENTS

·       Bachelor’s degree in Computer Science, Information Technology, or related field.

Responsibilities 

> Contribute to code and solutions based on your previous training and referencing help, manuals, or other resources on your own 

> Demonstrate excellent communication skills and effective collaboration in a team-oriented environment 

> Stay updated with new technologies and concepts 

> Exhibit excellent time management skills and ability to prioritize 

> Translate customer and business needs to technical solutions 

Required skills 

> Excellent coding and debugging skills in C# 

> Basic knowledge in ASP.NET, Windows Service, and Web API 

> Familiarity with UI development using WPF 

> Understanding of Design patterns and object-oriented programming 

> Good understanding of relational databases and SQL queries 

> Familiarity with version control software like Git 

> Have development experience in Windows-based environment

Must have 5 to 6 years of experience with team leadership experience. Salary range will be as per their last drawn CTC.

 Good to have skills 

> Modern C++, Templates, v11 new features etc

Exp -5+Yrs

ASP DOT NET CORE DEVELOPER

Job Location- Vikhroli

We are looking for a passionate .NET Core Web Application Developer with a strong fundamental hands-on experience of C#, .Net Core and SQL.

Technical skills:

Experience in building multi-user .NET web applications using n-tier Architecture.

Expertise in Object oriented development experience (OOPS, Design Patterns, SOLID Principals) is a must.

At least 2 years in Web API, OData, Web Services and Entity Framework.

Good experience in ASP.NET, C#, Web Services and OOD concepts.

Strong javascript, jquery and css experience.

Good design skills using n-tier architectures (scalability, multithreading, caching, business & data layers) or SOA based application.

Should possess excellent MS SQL database skills, ability to write stored procedures, functions, triggers, SQL jobs, etc.

Excellent Debugging skills

Qualification: Bachelor Degree.

Key Responsibilities:

Understand existing Web applications & develop and maintain .NET Web applications.

Deliver within specified timelines and up to expected quality standards.

Enhance Web applications as per requests.

Perform root cause analysis to address issues reported.

Liaise with peers, if required, and coordinate with other teams (DB, Testing, Front-end) to ensure timely and qualitative delivery.

Microsoft Azure Data Integration Engineer

Job Description: 

Microsoft Azure Data Integration Developer who will design and build cutting-edge user experiences for our client’s consumer-facing desktop application. The Senior Software Developer will work closely with product owners, UX designers, front-end, and back-end developers to help build the next-generation platform. 

Key Skills:

• 3+ years of experience in an enterprise or consumer software development environment using C# and designing and supporting Azure environments
• Expert level programming skills in creating MVC and Microservices architecture
• Experience with modern frameworks and design patterns like .Net core
• Strong knowledge of C# language
• Hands-on experience using the Azure administration portal and iPaaS
• Demonstrable experience deploying enterprise workloads to Azure
• Hands-on experience in Azure function apps, app service, logic apps and storage, Azure Key vault integration, and Azure Sql database.
• Solid understanding of object-oriented programming.
• Experience developing user interfaces and customizing UI controls/components

·      Microsoft Azure Certification, Business Continuity, or Disaster Recovery planning experience is a plus

Responsibilities:

• Architect, design & build a modern web application for consumers
• Explore configuring hybrid connectivity between on-premises environments and Azure, and how to monitor network performance to comply with service-level agreements.
• Collaborate with UI/UX teams to deliver high-performing and easy-to-use applications
• Participate in code reviews with staff as necessary to ensure a high-quality, performant product
• Develop a deep understanding of client goals and objectives, and articulate how your solutions address their needs
• Unit testing/test-driven development
• Integration testing
• Deploying Azure VMs (Windows Server) in a highly available environment
• Regularly reviewing existing systems and making recommendations for improvements.
• Maintenance
• Post-deployment production support and troubleshooting

Technical Expertise and Familiarity:

• Cloud Technologies: Azure, iPaaS
• Microsoft: .NET Core, ASP.NET, MVC, C#
• Frameworks/Technologies: MVC, Microservices, Web Services, REST API, Java Script, JQuery, CSS, Testing Frameworks
• IDEs: Visual Studio, VS Code
• Databases: MS SQL Server, Azure SQL
• Familiarity with Agile software development methodologies.
• Advanced knowledge of using Git source control system.
• Azure, AWS, and GCP certifications preferred.

We are looking for a Java Developer with experience in building high-performing, scalable, enterprise-grade applications.

You will be part of a talented software team that works on mission-critical applications. Java developer roles and responsibilities include managing Java application development while providing expertise in the full software development lifecycle, from concept and design to testing.

Java developer responsibilities include designing, developing and delivering high-volume, low-latency applications for mission-critical systems.

Experience : 2+ years

Location : Mumbai (WFO only) Initial few months work from home

Notice Period : 0 to 30 days ( Immediate joiners are preferred)

Roles & Responsibilities :

(This role encompassing both API engineering using Java stack and web development

Experience in designing, developing, testing and successfully deploying critical and complex projects.)

• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review

· Build reusable code and libraries for future use

Required Skill set :

· Java background with a minimum of 3+ years experience in Java technologies.

· Experience in designing and developing application backend using frameworks like Spring Boot, Spring MVC, Jersey, JPA, Hibernate, SQL, Linux, JSON, XML, OAuth etc.

· Well & good if has Experience with frontend technologies

· Experience with both SQL and NoSQL database systems and writing SQL queries

· Strong experience building, designing, and consuming Restful web services.

· Exposure of Cloud Infrastructure - AWS and Alibaba Cloud

· Excellent understanding of ORM and Database concepts

· Experience with developing unit test code using JUNIT, Power Mock/EasyMock/Mockito etc.

· Experience with Git, Maven and CI/CD pipelines to deploy on Cloud applications

· Experience & knowledge on Micro services Architecture and API development using Java, spring, Spring Boot

· Experienced in roles conducting requirements gathering, writing user stories, creating application design and using design patterns

· Good knowledge on credentials/secrets management and data encryption techniques

· Good knowledge on coding standards, design patterns, unit testing.

· Good hands-on BitBucket/Github is preferred.

Key Responsibilities :

- Take on development of key modules in the application
- You will be responsible for day-to-day development tasks across the Software Development Life Cycle assigned to your team.
- Development of application framework components
- Allocation of development tasks to the team
- Code review on a regular basis and ensuring code quality and adherence to company coding standards.

Required Technical Skills :

Angular :

- Modules, components basic architecture
- Typescript in depth
- Reactive forms
- CRUD operations in paged tabular listing
- Validation and error handling in Angular
- Security concepts like JWT based authentication, oAuth with social platforms, route guards, role driven menu
- Server-side rendering (SSR) with Angular Universal
- PDF making and email sending using SSR
- Localization and internationalization

ASP.Net C# Web API :

- Controllers
- Models with validation attributes, custom validations
- Asynchronous programming
- Error handling and logging
- Server side UI table operations - sorting, searching, paging, page sizing
- Entity framework with database first approach, edmx designer 
-React JS, Angular JS

SQL Server :

- Tables, views, stored procedures, functions
- Optimizations - keys, indexes, partitions
- Working with XML/JSON data

HTML/CSS :

- JavaScript/jQuery, CSS 3.0/Less/SCSS,
- Bootstrap
- Responsive design

Company profile

We are the pioneering player in the FinTech industry in India in the institutional credit space. We have created a one of a kind online marketplace for institutional credit ‘CredAvenue’, bringing together issuers and lenders, while also participating in the marketplace through their own balance sheet. Within a short span of two years, CredAvenue has gained immense traction and boasts of multiple clients across sectors, 120+ investors across multiple segments and a high volume of credit deal closures. To read about the latest numbers we have clocked, please visit http://www.credavenue.com">www.credavenue.com.

We are backed by two of the leading global Private Equity firms and have also been successful in attracting high quality talent from some of the leading companies and universities globally. With the fundamentals in place, we are now gearing up for our next phase of high growth, and we are further building up our team to take the company to the next level.

Primary Responsibilities

• Responsible for full software life-cycle, system design and development of front-end & back-end systems
• Writing high-quality code, participating in code reviews, designing/architecting systems of varying complexity and scope
• Identify libraries and technologies worth experimentation
• Build innovative solutions from scratch and liaise with architects and engineers to build solutions
• Mentoring other team members

Required Skill

•  Degree in Computer Science or relevant experience
•  2-7 years of relevant hands-on software engineering experience doing software design and development
•  Proven experience of working on back-end web frameworks like RoR (preferable) or Python/Django or Node.js
•  Good command over at least one JavaScript frameworks like React.js, Vue.js or Angular
•  Excellent understanding of relational database structures, having knowledge of unstructured databases (NoSQL) will be an  added advantage
•  Expertise in object-oriented design, unit testing, integration testing, data structures, algorithms, scalable APIs, etc.
•  Knowledge of working on cloud technologies and exposure of AWS services (EC2, RDS, S3, etc)
•  Work in a fast-paced environment and make pragmatic engineering decisions in a short amount of time
•  Experience with Agile Development and Scrum methodologies.

Work Environment Details

• An opportunity to play a formative role in an ambitious financial services marketplace spanning investment banking, debt capital markets, institutional finance, retail lending and asset management
• A journey that will challenge and reward you in a manner few others will