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.

We are looking for candidates with 0.5 - 2 years of work experience*

ByteAlly is a software consultancy based out of Chennai focusing heavily on the supply chain industry. Our solutions span Blockchain solutions, Food traceability, B2B integrations, and enterprise applications. We are looking for a Back End developer to join our force.

• Proficiency in C# - Experience using .NET Core.
• Experience in developing ASP.NET MVC / ASP.NET Core WEB API applications
• Extensive knowledge of Entity Framework/ EF Core
• Proficient knowledge of SQL Server
• Knowledge in React.JS preferred
• Extensive experience in performance tuning and code optimization

Please Note: We are also looking for candidates who are available to join immediately or with a notice period of maximum 30 days.

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

• 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

What we are scouting for

• BS/MS in computer science or equivalent work experience in IT
• 2+ years’ experience designing and developing applications using Java EE platforms
• A strong hands-on programming knowledge in Core Java including Java 8. To solve the problem given in optimized way.
• Strong knowledge on the Data structure and algorithm.
• Experience developing and designing API integrations using SOAP/RESTful
• Should be able to understand the time complexity of the existing algorithm. Able to compare different algorithms available.
• Expert understanding of the object-oriented design and programming concepts
• Know the fundamentals of Object-Oriented Programming using Java;
• Used SQL & NoSQL solutions
• Experience in GIT/SVN, build tools such as Ant/Maven/Gradle
• Experience in JUnit, Sonarqube, Mockito, Jacoco, Maven & Jenkins

Technical Competency – Nice to have

• Experience in Dependency Injection, Annotation, Validations, Auto Wiring
• Good knowledge in internal working on Memory Management, Transaction management
• Knowledge on DevOps pipeline tools like Jenkins, tools for Code quality scan, tools for security scan
• Spring boot
• Spring MVC
• Any Java Certification

Behavioural Competency

• Strong interpersonal communication skills
• Ability to lead self and team toward common goals
• Excellent oral and written communication, presentation, and analytical skills
• Excellence in technical communication with peers and non-technical cohorts

What you will be doing

• As a self-motivated and enthusiastic member of our team, you will work with extremely talented peers in a fun environment building performance efficient payment authorization services that are highly scalable, configurable and available
• You’ll work in an Agile environment with a focus on problem solving and engineering excellence.
• Worked independently and as a member of a team, determined to make active contributions to the assigned Team
• Flexible and adaptable approach to the roles assigned to you
• Ability to coordinate and prioritize tasks, and work in a fast paced and challenging environment
• Deliver on time under dynamics with a high level of integrity and flexibility, sense of urgency, attention to detail and quality standards
• Make a large impact on the design, architecture, and implementation of cutting edge products
• Work with other team members to investigate design approaches, prototype new technology

and evaluate technical feasibility

• Work in an Agile/Scrum environment to deliver high quality software
• Establish architectural principles, select design patterns and then mentor team members on their appropriate application

• 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

Striim (pronounced “stream” with two i’s for integration and intelligence) was founded in 2012 with a simple goal of helping companies make data useful the instant it’s born.

Striim’s enterprise-grade, streaming integration with intelligence platform makes it easy to build continuous, streaming data pipelines – including change data capture (CDC) – to power real-time cloud integration, log correlation, edge processing, and streaming analytics.

Strong Core Java / C++ experience

·       Excellent understanding of Logical ,Object-oriented design patterns, algorithms and data structures.

·       Sound knowledge of application access methods including authentication mechanisms, API quota limits, as well as different endpoint REST, Java etc

·       Strong exp in databases - not just a SQL Programmer but with knowledge of DB internals

·       Sound knowledge of Cloud database available as service is plus (RDS, CloudSQL, Google BigQuery, Snowflake )

·       Experience working in any cloud environment and microservices based architecture utilizing GCP, Kubernetes, Docker, CircleCI, Azure or similar technologies

·       Experience in Application verticals such as ERP, CRM, Sales with applications such as Salesforce, Workday, SAP  < Not Mandatory - added advantage >

·       Experience in building distributed systems  < Not Mandatory - added advantage >

·       Expertise on Data warehouse < Not Mandatory - added advantage >

·       Exp in developing & delivering product as SaaS i< Not Mandatory - added advantage