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.

Requirements:

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

1. Proven hands-on Software Development experience

2. Proven working experience in Java development

3. Hands on experience in developing applications using Java EE platforms

4. Profound insight of Java and JEE internals (Classloading, Memory Management, Transaction management etc)

5. Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)

6. Experience in the Spring Framework

Must have,

- Fundamental of Python(Data types in python, scope of variable, asynchronous programming)
- Should be able to code in Python

- Basic Understanding of Database

- API designing

- Problem Solving skills

- Fundamentals of storage, caching

Good to have,

- AWS Knowledge,

- Python Framework(Django, Flask)

- Knowledge on Message Broker, Caching

- SQL and no-SQL database

The ideal candidate would be a person having a strong technical know-how of Drupal application development & CMS concepts, backed with an equally strong hands-on experience. He / She should be fluent with the design concepts using Drupal 8 and above(Must) as well as be well versed with the best practices in the development, testing & deployment phases.

Experience : 5 – 9 years

Contract duration : 6 months

Major Accountability

• Demonstrate expertise in authoring & customizing Drupal modules as well as have experience in working with views, panels and features.
• Carry-out impact analysis & estimation for given set of requirements.
• Develop code by adhering to the Drupal, security and accessibility standards.
• Act as liaison with the client for troubleshooting: investigate, analyze, and solve software problems.
• Work self-directed and independently.

Essential Skills & Experience

• Have overall 4-8 years of IT experience on Drupal 8 platforms.
• Have expertise in developing complex websites based on Drupal 8 platforms and framework-based web applications.
• Have expertise in LAMP environment.
• Have working knowledge of web servers like Apache, Nginx etc.
• Have strong experience with source/version control systems.
• Have excellent communication, analytical & presentation skills.

Education

• Minimum education: B.E., BTech, MCA
• Languages: English written & spoken

• Implement best practices for the engineering team across code hygiene, overall architecture design, testing, and deployment activities
• Drive technical decisions for building data pipelines, data lakes, and analyst access.
• Act as a leader within the engineering team, providing support and mentorship for teammates across functions
• Bachelor’s Degree in Computer Science or equivalent job experience
• Experienced developer in large data environments
• Experience using Git productively in a team environment
• Experience with Docker
• Experience with Amazon Web Services
• Ability to sit with business or technical SMEs to listen, learn and propose technical solutions to business problems

·       Experience using and adapting to new technologies

·       Take and understand business requirements and goals

·       Work collaboratively with project managers and stakeholders to make sure that all aspects of the project are delivered as planned

·       Strong SQL skills with MySQL or PostgreSQL

• Experience with non-relational databases and their role in web architectures desired

 Knowledge and Experience:

• Good experience with Elixir and functional programming a plus

• Several years of python experience
• Excellent analytical and problem-solving skills
• Excellent organizational skills

Proven verbal and written cross-department and customer communication skills