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.

ROLE SUMMARY

The Senior Python Developer designs, builds, and improves Python and Django applications. The role includes developing end‑to‑end integrations using REST and SOAP services and delivering reliable, scalable solutions through hands‑on coding and data transformation work. The developer works closely with Business Analysts, architects, and other teams to ensure technical solutions support business needs. Key responsibilities also include improving SQL performance, taking part in code reviews, supporting DevOps workflows with Git and Azure DevOps, and helping integrate GenAI features—such as GPT models, embeddings, and agent‑based tools—into enterprise applications.

ROLE RESPONSIBILITIES

• Design and develop Python and Django applications that are scalable, secure, and maintainable.
• Implement UI components using CSS, Bootstrap, jQuery, or similar technologies as needed.
• Develop integrations with internal and external systems using REST, SOAP, and WSDL‑based services.
• Create and optimize SQL queries, database structures, and data access logic to support application features.
• Work with Business Analysts and stakeholders to translate functional requirements into technical specifications and solutions.
• Implement accurate data mappings and transformations in accordance with business and technical requirements.
• Contribute to code reviews, follow established coding standards, and ensure high‑quality deliverables.
• Support the implementation and maintenance of DevOps pipelines using Git and Azure DevOps.
• Contribute to the integration of GenAI capabilities—including GPT models, embeddings, and agent‑based components—into enterprise applications.
• Troubleshoot issues across the application stack and collaborate closely with peers to resolve technical challenges.

TECHNICAL QUALIFICATIONS

• 7+ years of hands‑on experience with Python and Django, including complex application development.
• 5+ years of experience with SQL development, optimization, and database design.
• At least 1-2 years of applied experience with GenAI technologies (GPT models, embeddings, agents, etc.).
• Deep expertise in application architecture, system integration, and service‑oriented design.
• Strong experience with DevOps tools and practices, including Git, Azure DevOps, CI/CD pipelines, and automated deployments.
• Advanced understanding of REST, SOAP, WSDL, and large‑scale service integrations.

GENERAL QUALIFICATIONS

• Exceptional verbal and written communication skills.
• Strong analytical, problem‑solving, and architectural reasoning abilities.
• Demonstrated leadership experience with the ability to guide and mentor technical teams.
• Proven ability to work effectively in fast‑paced, collaborative environments.

EDUCATION REQUIREMENTS

• Bachelor’s degree in Computer Science, MIS, or a related field.
• Advanced certifications in Python, cloud technologies, or GenAI are preferred but not required.

Role Overview

We’re hiring a Senior Backend Engineer who can build high-performance backend systems using Node.js. You’ll work on complex engineering problems, optimize for scale, and own features end-to-end.

Key Responsibilities

● Develop backend services, APIs, and microservices using Node.js frameworks (Express, Nest.js).

● Own modules end-to-end: design → implementation → testing → deployment.

● Write high-quality, testable, maintainable code.

● Optimize performance, scalability, and reliability across systems.

● Troubleshoot production issues, perform RCA, and improve stability. ● Work with databases (SQL & NoSQL), caching, and async processing.

● Collaborate with DevOps for CI/CD, deployments, and automation.

● Contribute to improving engineering standards, documentation, and processes

What we’re looking for:

● 4 to 7 years of hands-on backend development experience. ● Strong in Node.js, async patterns, TypeScript (preferred), and REST APIs. ● Solid understanding of: Data modeling Queues & background jobs Caching (Redis) API optimization ● Experience with relational DBs (PostgreSQL/MySQL) and NoSQL (DynamoDB/MongoDB/ Redis). ● Experience with messaging/queues: Kafka, RabbitMQ, SQS, or equivalent. ● Familiarity with Docker, Git, and CI/CD pipelines. ● Exposure to AWS or cloud infrastructure. ● Strong debugging and performance tuning skills. ● Ability to work in a fast-paced, startup-like environment.

Here are answers to some questions you may have

Where is your office?

Chennai (Velachery)

Work Model Work from Office – because great stories are built in person!

Do you have an online presence?

https://amura.ai (we are @AmuraHealth on all social media)

For better insights: https://drive.google.com/file/d/11UHgXqYc7XSJ3IAdFyEm-EurgOzqsmzA/view?usp=sharing

Roles & Responsibilities

• Data Engineering Excellence: Design and implement data pipelines using formats like JSON, Parquet, CSV, and ORC, utilizing batch and streaming ingestion.
• Cloud Data Migration Leadership: Lead cloud migration projects, developing scalable Spark pipelines.
• Medallion Architecture: Implement Bronze, Silver, and gold tables for scalable data systems.
• Spark Code Optimization: Optimize Spark code to ensure efficient cloud migration.
• Data Modeling: Develop and maintain data models with strong governance practices.
• Data Cataloging & Quality: Implement cataloging strategies with Unity Catalog to maintain high-quality data.
• Delta Live Table Leadership: Lead the design and implementation of Delta Live Tables (DLT) pipelines for secure, tamper-resistant data management.
• Customer Collaboration: Collaborate with clients to optimize cloud migrations and ensure best practices in design and governance.

Educational Qualifications

• Experience: Minimum 5 years of hands-on experience in data engineering, with a proven track record in complex pipeline development and cloud-based data migration projects.
• Education: Bachelor’s or higher degree in Computer Science, Data Engineering, or a related field.
• Skills
• Must-have: Proficiency in Spark, SQL, Python, and other relevant data processing technologies. Strong knowledge of Databricks and its components, including Delta Live Table (DLT) pipeline implementations. Expertise in on-premises to cloud Spark code optimization and Medallion Architecture.

Good to Have

• Familiarity with AWS services (experience with additional cloud platforms like GCP or Azure is a plus).

Soft Skills

• Excellent communication and collaboration skills, with the ability to work effectively with clients and internal teams.
• Certifications
• AWS/GCP/Azure Data Engineer Certification.

Java back end developer

Chennai  

3+yrs

3 to 5 years Java,

Sprint Boot, Hibernate,

REST API Design Patterns SQL,

Oracle,

Table design

Responsibilities include:

• Coordinate and clarify the requirements and technical issues (including client interaction)
• Support creation of high and low level design
• Development and maintenance of automation code
• Build reusable Business objects as required
• Review the automation implemented code
• Deploy the code to multiple environments phase wise
• Provides regular status updates to clients and management
• Participates in research/design/implementation of appropriate automation tools
• Develop .net libraries using C# /.Net
• Design and develop SQL scripts – Stored procedures, queries, and functions
• Perform unit testing, support systems integration testing and UAT testing
• Raise ticket and co-ordinate with IT team and CS team
• Analyze, estimate and implement special projects
• Effectively manage multiple priorities / assist with various projects as they arise.
• Accurately track, monitor, and report progress and obstacles
• Travel requirements will be modest, working hours must be flexible to deal with international time zone and key process owners located throughout the world.

Education, Experience, & Required Skills:

• Bachelor degree in Computer Science, Computer Engineering or equivalent is required
• 7+ years of overall IT experience
• 2+ years of overall development experience with leading RPA tool.
• Certified RPA Tool (UiPath, UiPath X, Blue Prism, Automation Anywhere) as developer
• Programming experience in Java, .Net, C, C#, .Net, Python
• Sufficient knowledge of RDBMS like ORACLE / MS SQL Server and SQL tools
• Knowledge in developing & understanding excel macros codes.
• Knowledge in Power BI, Excel Macro, web forms, mobile applications are preferable.
• Knowledge of service oriented architecture is preferable.
• Knowledge in Finance & Accounting domain is preferable.
• Strong written and verbal communication skills
• Excellent organization and communication skills.
• Effectively interact with various levels of management.
• Ability to multitask.

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

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.

• 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.