3+ Functional analysis Jobs in India

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.

Review Criteria:

Mandatory:

• Strong UAT / Functional Test Lead Profiles
• Must have minimum 7 years of overall testing experience, with at least 3 years of recent UAT experience, primarily in manual testing for large enterprise or government project
• Must have worked on minimum 2 national-level e-Governance, public sector, enterprise, or marketplace projects in a UAT lead or ownership role
• Must have 3+ years of team handling experience, leading 7–8 QA/UAT members, including task assignment, review, mentoring, and delivery ownership
• Must have complete ownership of UAT activities, including UAT planning, execution, acceptance sign-off, defect management, retesting, and regression cycles.
• Must have strong hands-on manual testing experience, with the ability to create test scenarios and test cases from BRDs, user stories, functional documents, and Figma/UI screens.
• Must be able to understand HLD/LLD documents and API specifications and perform manual API testing based on business logic.
• Must have BE/BTech/MTech/MBA (BSc/BCA alone is not acceptable; with Bsc/BCA candidates must have a relevant postgraduate degree MCA/MTech)

Preferred:

• ISTQB Advanced Test Manager or equivalent is preferred

Ideal Candidate:

• 8 + years’ experience in UAT, with at least 2 National-level e-Governance solutions / Enterprise platforms / Marketplace projects.
• Proficiency in test planning, execution oversight, acceptance criteria definition, defect triage, regression cycle management.
• Proficient in understanding business requirements by going through BRDs, User Stories, Figma screens to define test scenarios and test cases.
• Ability to analyze high level and low-level design documents, API specifications to identify the business logic developed and create test cases to test the APIs.
• Hands-on experience of defining high quality test scenarios, test cases with ability to review and guide the test team members in doing the same.
• Education/Certifications: B.E./ B.Tech. / MTech/ MCA/ MS (Computer Science/IT)/ISTQB Advanced Test Manager or equivalent required.

CRM Functional Consultant

Country: Malaysia

Cities: Kuala Lumpur

Area of expertise: Customer Relationship Management (CRM)

Job Description

As a CRM Business Analysis Consultant, you are responsible for identifying, developing, and deploying end-user solutions in Customer Relationship Management (CRM) system. Through your deep functional knowledge and familiarity with the application, you ensure business requirements are adequately met and provide a variety of advisory services around project management, business process development, implementation support and end-user training as required. You also contribute to project planning, implementation, and requirements gathering efforts across CRM projects.

Responsibilities:

Translate business requirements into CRM business solutions

Identify key stakeholders for requirements gathering; elicits and documents requirements and validates against scope

Contribute to requirements management, including approval, communication, traceability, and re-use

Contribute to transfer of functional requirements to development and test team members- Leverage CRM workflow technology to automate business processes

Determine, in collaboration with business and IT stakeholders, patches and upgrades needed to the CRM system in order to meet evolving business requirements

Stay informed on updates and new releases in CRM technologies

Educates end users on CRM functionality, as needed

Skills:

You are excited about working with a global technology leader to solve business-critical problems for some of the top companies in the world. You are a fast learner, self-starter, and creative thinker. You are passionate about software and its potential to move organizations forward through innovation.  You’re proud of your positive and lasting client relationships and the customizations and strategies you’ve built to tackle their business challenges.

Requirements:

At least 3 years of relevant work experience including CRM

Strong knowledge of CRM Systems and business solution implementation

Demonstrable experience in Business Process Reengineering (BRP)

Strong knowledge of CRM issue diagnosing and troubleshooting

Working with Microsoft Dynamics 365 Customer Engagement as a Functional Consultant

Hands on experience deploying with Microsoft Power Platform solutions for customers in a variety of industries

Experience consulting with external clients on complex projects

Experience working with global teams on CRM technology implementation and maintenance projects

Experience working with offshore teams to facilitate project work

Demonstrated excellence in communicating and presenting complex information to technical and non-technical stakeholders, both verbally and in written form