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.

🚀 Hiring: Java Developer at Deqode

⭐ Experience: 4+ Years

📍 Location: Indore, Pune, Mumbai, Nagpur, Noida, Kolkata, Bangalore,Chennai

⭐ Work Mode:- Hybrid

⏱️ Notice Period: Immediate Joiners

(Only immediate joiners & candidates serving notice period)

Requirements

✅ Strong proficiency in Java (Java 8/11/17)

✅ Experience with Spring / Spring Boot

✅ Knowledge of REST APIs, Microservices architecture

✅ Familiarity with SQL/NoSQL databases

✅ Understanding of Git, CI/CD pipelines

✅ Problem-solving skills and attention to detail

Profile: AWS Data Engineer

Mode- Hybrid

Experience- 5+7 years

Locations - Bengaluru, Pune, Chennai, Mumbai, Gurugram

Roles and Responsibilities

• Design and maintain ETL pipelines using AWS Glue and Python/PySpark
• Optimize SQL queries for Redshift and Athena
• Develop Lambda functions for serverless data processing
• Configure AWS DMS for database migration and replication
• Implement infrastructure as code with CloudFormation
• Build optimized data models for performance
• Manage RDS databases and AWS service integrations
• Troubleshoot and improve data processing efficiency
• Gather requirements from business stakeholders
• Implement data quality checks and validation
• Document data pipelines and architecture
• Monitor workflows and implement alerting
• Keep current with AWS services and best practices

Required Technical Expertise:

• Python/PySpark for data processing
• AWS Glue for ETL operations
• Redshift and Athena for data querying
• AWS Lambda and serverless architecture
• AWS DMS and RDS management
• CloudFormation for infrastructure
• SQL optimization and performance tuning

• 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

Oracle Functional

Job Description

Oracle EBS Techno Function with 4+ years' of experience

Excellent functional knowledge of Financial modules (Specially GL, FA)

Expertise in Oracle EBS Financial, Project, Purchasing module

Able to understand the accounting concepts

Few technical skills like PLSQL, personalization, XML reports

Worked on Oracle EBS 12.2+ implementation and support

Qualifications

Graduate specially with accounts

Additional information

Excellent verbal and written communication skills.

• 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

• Develop front end User Interface of our UKLB Experience Analysis (Biometrics) tool using SharePoint, PowerApps, Power Automate and Logic Apps 
• Connection of UI with back end SQL Database using Logic Apps - Advise solution design as a Logic Apps expert (specifically around UI)
•  Responsible for managing technology in projects and providing technical guidance or solutions for work completion

Skills and Experience

• Experience with Azure services like Azure App Services, Azure Active Directory, Azure SQL, Azure PostgreSQL, Key Vault, Azure DevOps, Application Insights, Azure Storage, Redis Cache
•  Microsoft Azure Developer Certification
• Experience with .Net SDK, integration tools, Application and Security frameworks
• C#, ASP.NET, Application development using .Net Framework
•   Preferred: Insurance or BFSI domain experience
• .Net
•  Azure/

Location: Chennai

Salary : 15-20 LPA