IT Sr App Dev Tech Lead

Department Icon IT / Software Development & Related
Posted: 1 month ago
0-1 years
Noida, Uttar Pradesh
IT / Software Development & Related
work from office
Full Time
Closes 8 Nov 2026

Posted: 1 month ago
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Posted over 15 days ago, so the role may have closed. Confirm on the employer's page when you apply, or see similar jobs.

Job Description

Our Story

At Alight, we believe a companyu2019s success starts with its people. Alight embraces values that come directly from our people u2013 purposeful, human, united and growth-minded u2013 reflecting our inclusive culture and promise that our clients expect. We are passionate about connecting purpose with impact. Alight empowers clients to build a healthier and more financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, navigation, and absence management.

Our Benefits

With a comprehensive total rewards package, Alight offers programs and plans that support your mind, body, wallet, and life. Benefits include health, starting Day One. Additionally, Alight colleagues enjoy wellbeing programs, retirement plans, and career growth opportunities u2013 all within a thriving global organization.

Great Place to Work

Thanks to the work of every colleague, Alight has received multiple awards of recognition including u201CGreat Place to Worku201D for the past 7 years and Fortuneu2019s u201CBest Companies to Work For.u201D To learn more about our company culture and awards

We invite you to join our team! Learn more at .

Role Overview

The Senior SQL Server Developerwith hands-on experience in designs, builds, optimizes, and supports SQL Server solutions for CBA data processing, integrations, reporting, and production-ready database components. This role requires strong SQL engineering judgment, query optimization,ETL/data processing, performance awareness, secure data handling, and the ability to use AI tools responsibly as a productivity accelerator while independently reviewing,validating, and correcting all AI generated outputs.

AI capability requirement

Candidates must be able to demonstrate practical, responsible use of generative AI to accelerate SQL development, query troubleshooting, documentation, validation, and test support. AI-generated code or analysis must be reviewed, corrected, secured, and explained before use.

Primary Responsibilities

  • Design, develop, test, and support SQL Server database objects, including stored procedures, views, functions, jobs, triggersand data processing logic.

  • Analyze business and technical requirements and translate them into efficient, maintainable SQL solutions aligned to CBA data patterns and release processes.

  • Troubleshoot production and non-production data issues, including performance, correctness, data quality, and integration concerns.

  • Review execution plans, indexes, joins, filtering logic, transaction behavior, and data volumes to improve query performance and operational reliability.

  • Partner with product owners, QA/SQA, developers, architects, and support teams to validate requirements, support testing, and ensure production readiness.

  • Document technical designs, deployment considerations, operational dependencies, and support guidance for implemented solutions.

  • Use AI-assisted development tools to accelerate routine development and analysis tasks, while validating correctness, security, performance, and business fit before implementation.

  • Mentor junior and mid-level developers and contribute to technical best practices.

Required Skills and Experience

  • Strong SQL Server development skills, including joins, aggregations, window functions, stored procedures, query tuning, and execution plan analysis.

  • Experience with data validation, source-to-target checks, reconciliation, exception handling, and root-cause analysis for complex data issues.

  • Ability to work in Agile delivery cycles, provide meaningful estimates, participate in sprint planning, and support defect resolution through release.

  • Strong understanding of secure data handling practices, including preventing confidential, proprietary, client, colleague, production, PII, or PHI data from being entered into public AI tools.

  • Ability to explain technical decisions, risks, and validation outcomes to both technical and business stakeholders.

AI Required and Preferred Skills

Skill Area

Requirement / Posting Language

AI-assisted development

Experience using generative AI tools to improve SQL development productivity, such as ChatGPT, Claude, Gemini, Perplexity, GitHub Copilot, or similar tools.

Prompt engineering

Ability to write clear prompts for SQL query generation, troubleshooting, query tuning, data validation, documentation, and testing support.

AI output validation

Ability to evaluate and validate AI-generated SQL for correctness, security, data quality, and performance before implementation.

Secure data handling

Understands that confidential, proprietary, client, colleague, production, PII, or PHI data must not be entered into public AI tools.

Preferred AI usage

Experience using AI for ETL development, report logic, analytics support, documentation generation, test case creation, or troubleshooting.

Application and Interview

By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alightu2019s employment policies. Background checks may include some or all the following based on the nature of the position: Government ID validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position.

Alight requires all virtual interviews to be conducted on video. Please be aware that Alight is a camera-on culture and may require occasional travel to one of our physical office locations.

Our commitment to Inclusion

We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful.

SSN/SIN to be replaced with Government ID to get aligned with India context

Agree

We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

DISCLAIMER:

Nothing in this job description restricts managements right to assign or reassign duties and responsibilities of this job to other entities including but not limited to subsidiaries, partners, or purchasers of Alight business units.

.

Skills

Sql ServerTestingDeveloperSql

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

About Company

Alight Solutions is a global human capital and technology solutions provider.

Similar Jobs

View all
Loading...
Bag Logo
Jobaaj
Get jobs like this by email

New IT / Software Development & Related roles in Noida.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.