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.

🚀 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

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.

Job Description:

We are seeking an experienced developer to design and build cross-platform mobile applications integrated with enterprise backend systems. The role involves working on both mobile (Android & iOS) using Kotlin Multiplatform and backend services using Java / Spring Boot.

Key Responsibilities:

• Develop mobile applications for Android and iOS using Kotlin Multiplatform (KMP)
• Design and implement reusable shared modules across platforms
• Develop and maintain backend services using Java / Spring Boot
• Build and consume REST APIs
• Integrate authentication and security mechanisms
• Perform testing, debugging, and performance optimization

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

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.

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!

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