IT Sr App Dev Tech Lead

IN-UP-Noida-Candor TechSpace Tower 1

Full time

R-38019

Our Story

At Alight, we believe a company’s success starts with its people. Alight embraces values that come directly from our people – purposeful, human, united and growth-minded – 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 – 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 “Great Place to Work” for the past 7 years and Fortune’s “Best Companies to Work For.” To learn more about our company culture and awards Click Here. (http://www.alight.com/about)

We invite you to join our team! Learn more at careers.alight.com (https://careers.alight.com/us/en) .

Role Overview

The Senior SQL Server Developer with 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, triggers and 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.

Re quired 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 Alight’s 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 management's 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.

.

About Alight Solutions

Alight is a leading benefits administration provider of health, wealth, leave and point solutions for many of the world’s largest organizations and over 30 million people. Through the administration of employee benefits, Alight helps clients gain a benefits advantage while building a healthy and financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, absence management and navigation. Our Alight Worklife® platform empowers employers to gain a deeper understanding of their workforce and engage them throughout life’s most important moments with personalized benefits management and data-driven insights, leading to increased employee wellbeing, engagement and productivity. Learn more at alight.com.

Our values are the essence of who we are:

Agility. Move with purpose. Learn fast. Adapt quickly.

Leadership. Lead by example. Own the outcome. Serve others.

Integrity. Do the right thing - even when it is difficult or unseen.

Growth Mindset Stay curious. Keep learning. Never stop improving.

High-Quality. Do it thoughtfully. Do it completely. Do it well.

Trust. Trust is earned through consistency, authenticity, and credibility.

Our Colleague ExperienceAt Alight Solutions, we are reimagining how people and organizations thrive. To deliver on this purpose, we do things differently. From company leaders to our newest colleagues, we all play a role in bringing our values to life. Every colleague shapes how Alight can become better, stronger and brighter – together. With technology as our catalyst and humanity at our core, we advance each day toward a better future in work and life.

We understand the powerful human connections that create success for organizations. We bring an industry leader's expertise and a true partner's commitment to our benefits and administration solutions around health, wealth, HR, finance and consumer experience.

Are you interested in helping us shape the future of work and life for organizations, people and their families? If so, you've come to the right place.

Help us reimagine how people and organizations thrive!

Our story starts with a simple, universal truth: Every business is a people business. We are Alight Solutions. Reimagining how people and organizations thrive. @AlightSolutions