11+ Functional analysis Jobs in Chennai | Functional analysis Job openings in Chennai

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.

• Job Description:      

• Team Leading experience upto 2 years

• Extensive experience in Appian BPM application development
• Knowledge of Appian architecture and its objects best practices
• Participate in analysis, design, and new development of Appian based applications
• Mandatory Team leadership and provide technical leadership to Scrum teams Certification Mandatory- L1, L2 or L3
• Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced by team
• Build applications: interfaces, process flows, expressions, data types, sites, integrations,
• Proficient with SQL queries and with accessing data present in DB tables and views
• Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart services, integration services and web services
• Experience working with different Appian Object types, query rules, constant rules and expression rules

Qualifications

• At least 6 years of experience in Implementing BPM solutions using Appian 19.x or higher
• Over 8 years in Implementing IT solutions using BPM or integration technologies
• Experience in Scrum/Agile methodologies with Enterprise level application development projects
• Good understanding of database concepts and strong working knowledge any one of the major databases e g Oracle SQL Server MySQL

• Appian BPM application development on version 19.x or higher
• Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
• Good leadership skills and the ability to lead a team of software engineers technically
• Experience working in Agile Scrum teams
• Good Communication skills

Level of skills and experience:

5 years of hands-on experience in using Python, Spark,Sql.

Experienced in AWS Cloud usage and management.

Experience with Databricks (Lakehouse, ML, Unity Catalog, MLflow).

Experience using various ML models and frameworks such as XGBoost, Lightgbm, Torch.

Experience with orchestrators such as Airflow and Kubeflow.

Familiarity with containerization and orchestration technologies (e.g., Docker, Kubernetes).

Fundamental understanding of Parquet, Delta Lake and other data file formats.

Proficiency on an IaC tool such as Terraform, CDK or CloudFormation.

Strong written and verbal English communication skill and proficient in communication with non-technical stakeholderst

Job Description for Drools developer -

• Hands on experience in design and development in Drools rule engine (minimum 1.5 years) and Core Java
• Exceptional ability to communicate with both technical and non-technical people
• Expertise in object oriented programming
• Experience in Deploying and supporting core and advanced features
• Good exposure to SQL and/or Oracle/ MySQL,
• Candidate should be well verse with Agile processes
• Strong ability to work collaboratively across diverse groups of business and technical stakeholders is required.

Job Description:

• Resource should be proficient in analyzing, designing and developing applications based on the requirements provided by business counterparts
• Developing and maintaining applications developed in Java, J2EE, Struts and Spring and possessing 3-layer architecture
• Good knowledge in Spring Boot, Hibernate, Angular JS, Docker, VUE JS and AWS
• Applications development or maintenance using ORM tools such as Hibernate
• Database management which includes DB design and maintenance, mostly related to 2016 and Oracle 19c, DB2
• Should have knowledge in Unix / Linux OS.
• Should have good knowledge in Shell scripting language
• Strictly adhere to the internal SDLC process quality standards set but the organization and providing the drive to the team to achieve the KPI and SLA targets
• Flexible to work in extended time
• Candidate should have good experience on Java / J2EE, Springboot, Hibernate / JPA, Oracle query, Web Services and Rabbit MQ.
• Should have minimum of 3 to 5 years of experience. Should be able to work on enhancement, maintenance and production support.
• Good to have hands-on experience on DEVOPS & API development.

Responsibilities

• Participate in requirements analysis
• Collaborate with internal teams to produce software design and architecture
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Develop documentation throughout the software development life cycle (SDLC)
• Serve as an expert on applications and provide technical support

Requirements

• Proven experience as a .NET Developer or https://resources.workable.com/application-developer-job-description">Application Developer
• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
• 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

Responsibilities:

• Thorough understanding of Reconciliation and hands on development experience on Intellimatch 9.2.7 or higher version
• Comprehensive understanding of SDLC in developing new Reconciliations in IntelliMatch. Involvement across all stages of Software Development life cycle (SDLC) including business requirement analysis, data mapping, validate data against requirement, build, unit testing, peer reviews, systems integration and user acceptance testing.
• Analyze & develop Test Strategies, design Test Plans, & generate and execute Test Cases.
• Should be able to perform enhancements, whereby need to analyze existing set-up and understand the requirement by performing proper impact analysis, provide estimate and deliver quality code.
• Independent player should be able to liaise with different team to re-solve/get dependencies on time. Should be able to for-see issue/risk and intimate the same to team lead / project manager.
• Should be able to guide support team.
• Deep knowledge on IntelliMatch Database linkage and functionalities is necessary for timely resolution of user queries.
• Propose improvements related to the development and support activity.
• Develop stored procedures to build reports for the end users using SQL 2016