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.

Shift timings : Afternoon

Job Summary

We are seeking an experienced Senior Java Developer with strong expertise in legacy system migration, server management, and deployment. The candidate will be responsible for maintaining, enhancing, and migrating an existing Java/JSF (PrimeFaces), EJB, REST API, and SQL Server-based application to a modern Spring Boot architecture. The role involves ensuring smooth production deployments, troubleshooting server issues, and optimizing the existing infrastructure.

Key Responsibilities

● Maintain & Enhance the existing Java, JSF (PrimeFaces), EJB, REST API, andSQL Server application.

● Migrate the legacy system to Spring Boot while ensuring minimal downtime.

● Manage deployments using Ansible, GlassFish/Payara, and deployer.sh scripts.

● Optimize and troubleshoot server performance (Apache, Payara, GlassFish).

● Handle XML file generation, email integrations, and REST API maintenance.

● Database management (SQL Server) including query optimization and schema updates.

● Collaborate with teams to ensure smooth transitions during migration.

● Automate CI/CD pipelines using Maven, Ansible, and shell scripts.

● Document migration steps, deployment processes, and system architecture.

Required Skills & Qualifications

● 8+ years of hands-on experience with Java, JSF (PrimeFaces), EJB, and REST APIs.

● Strong expertise in Spring Boot (migration experience from legacy Java is a must).

● Experience with Payara/GlassFish server management and deployment.

● Proficient in Apache, Ansible, and shell scripting (deployer.sh).

● Solid knowledge of SQL Server (queries, stored procedures, optimization).

● Familiarity with XML processing, email integrations, and Maven builds.

● Experience in production deployments, server troubleshooting, and performance tuning.

● Ability to work independently and lead migration efforts.

Preferred Skills

● Knowledge of microservices architecture (helpful for modernization).

● Familiarity with cloud platforms (AWS/Azure) is a plus.

• Design and Develop: Architect, design, and implement high-performance Java-based backend services and applications.
• Code Quality: Write clean, efficient, and well-documented code following industry best practices and coding standards.
• Technical Leadership: Provide technical guidance and mentorship to junior developers, promoting best practices and fostering a collaborative environment.
• Collaboration: Work closely with frontend developers, product managers, and other stakeholders to understand requirements and deliver robust solutions.
• Performance Optimization: Identify and resolve performance bottlenecks and scalability issues.
• Testing: Implement comprehensive testing strategies, including unit tests, integration tests, and end-to-end tests.
• Continuous Improvement: Stay current with the latest industry trends, technologies, and best practices in Java/Golang development, and continuously improve our development processes.

#HiringAlert

We are looking ".Net Architect" for Reputed Client @ Permanent Role

Experience: 10+ Years

Skills :

•Good understanding of the cross cutting architectural elements like Security (Authentication, Authorization, Distributed logging, tracing and Audit, Infra as Code, Database Design (SQL Server and MongoDB)

•Deep understanding of architectural concepts, issues and trends

•Expert knowledge in Object Oriented Principles and Design Patterns

•Expertise in n-tiered web architectures, SOA and related technologies (XML, SignalR , WCF, SOAP, REST, JSON, etc.)

•Strong technical expertise in the Relational Databases, No SQL DB (Ex: SQL Server, MongoDB), Web development and object-oriented methodologies.

•Must be a Team player able to work effectively at all levels of an organization with the ability to influence others to move toward consensus.

•Should review design and implementation of junior designers and developers on the quality of technical deliverables and adherence to quality process

•Excellent verbal and written communication skills.

Location : Chennai & WFO

• Experience in designing & developing systems/software for large business environments (Java, J2EE).
• Strong design and coding skills in Enterprise Java, REST & SOAP web services, ORM (JPA/Hibernate), Spring, Maven, JMS (ActiveMQ), Caching, XML, JSON.
• Experience with multiple integration technologies / frameworks.
• Must have good experience in Unix/Oracle/SQL.
• Experience in Agile Development, Scrum, and Iterative approaches.
• Experience and exposure to AWS Cloud Services and DevOps mindset and expertise is a plus Experience with Mule or any ESB (Enterprise Service Bus) is a plus.

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.

iSolve Technologies is looking for Team Lead Dot Net Developers with 3+ years of experience.

Key Skills:

• C#, ASP.NET, MVC, WEBAPI, SQL

• Meeting with client managers to determine the application and website requirements
• Ability to manage projects on your own
• Analyzing system requirements and delegating development tasks to the fellow teammates
• Designing and Developing technical specifications
• Drafting software and application operating procedures
• Deploying functional websites, programs, and applications
• Upgrading existing .NET websites and applications
• Writing scalable code for .NET software applications
• Reviewing and debugging .NET applications of the teammates
• Providing support for junior developers
• Training junior staff
• Code and resource management
• Performance Optimisation
• Travelling for Client meetings/visits

• Ability to work with tight deadlines
• Team-player with strong communication & collaboration skills
• Exceptional project management skills
• Prior experience in leading development teams is a plus
• Excellent problem-solving skills

• Graduates and postgraduates (BE/B.Tech/BCA/MCA preferred)
• Experience: 3-12 years
• Looking for Immediate Joiners

About Us:

iSolve Technologies is a Business Transformation company. We partner with our customers, understand their business, hypothesize and analyze process gaps, build strategy and bring 100% visibility to every step of the operation with innovative technology.

Customers typically come to us for our in-depth understanding of businesses and stay with us for our service excellence!

We are looking for an enthusiastic Dot Net professional to lead our project development teams with a focus on on-time deliveries. You will be responsible for leading, planning and delivering projects, guiding your team to deliver high-quality outcomes.

We are proud to foster a culture of diversity – be it gender, age, experience, perspective, or background!

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.

• MSSQL, SSIS, Performance Tuning, Data modeling.
• Experience in No SQL tools is must
• Candidate should have exposure to write scripts in Python/Node JS/MongoDB or any other tool
• Maria DB/MYSQL, Mongo DB, Github, Jira
• Understand Requirements from client and on-site team.
• Participate in preparing design and data modelling.
• Comfortable with SQL Stored procedures and queries development.
• Comfortable with SQL Stored procedures and queries development.
• Manage SQL Server through multiple product lifecycle / environments, from development to critical production systems.
• Apply best in industry standard techniques for data modeling to ensure performance, integrate and requirement.
• Ability to analyze independently problems and resolve them on time.

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