IT Sr App Dev Tech Lead

Alight Solutions; Dadri; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Alight Solutions is seeking a Senior SQL Server Developer to design, build, and optimize SQL Server solutions for data processing, reporting, and production components. The role emphasizes secure data handling and responsible use of AI tools to accelerate development while ensuring correctness and governance.

You will mentor junior developers and collaborate with cross-functional teams to deliver reliable data solutions, meeting release timelines and production readiness requirements.

Qualifications

• Strong SQL Server development skills incl. joins, aggregations, window functions, stored procedures, tuning.
• Experience with data validation, reconciliation, and root-cause analysis in complex data environments.
• Able to work in Agile delivery cycles and support defect resolution through releases.
• Knowledge of secure data handling and compliance with PI I/PHI data considerations.
• Experience using AI tools to accelerate SQL development, with proper validation and governance.

Responsibilities

• Design, develop, test, and support SQL Server database objects (stored procedures, views, jobs, triggers).
• Analyze requirements and translate into efficient SQL solutions aligned to data patterns and release processes.
• Troubleshoot production/non-production data issues and improve query performance.
• Review execution plans, indexes, joins, and data volumes for reliability and efficiency.
• Collaborate with product owners, QA, developers, architects, and support teams for production readiness.
• Document designs, deployment considerations, and support guidance.

Skills

SQL Server development

Data validation

Query tuning

Agile methodology

Security practices

AI-assisted development

Stakeholder communication

Tools

ChatGPT

Claude

Gemini

GitHub Copilot

Job description

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.

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

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.

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

• Experience using generative AI tools to improve SQL development productivity, such as ChatGPT, Claude, Gemini, Perplexity, GitHub Copilot, or similar tools.
• Ability to write clear prompts for SQL query generation, troubleshooting, query tuning, data validation, documentation, and testing support.
• Ability to evaluate and validate AI-generated SQL for correctness, security, data quality, and performance before implementation.
• Understands that confidential, proprietary, client, colleague, production, PII, or PHI data must not be entered into public AI tools.
• 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.