IT Sr App Dev Tech Lead
Alight Solutions LLC
Noida, IndiaPosted about 1 month agoDiscoveredMatch locked
7+ years expComputer and IT
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.
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.
.
Not included in the source posting: about the role, what you'll do, benefits.
Skills
artificial-intelligencesqlgenerative-aietlagileqa
Who can apply
The employer didn't state any visa, work authorization, citizenship or clearance requirements in this posting. Confirm with the employer before applying.
Read automatically from the employer's posting text. Always confirm with the employer — requirements can change after a job is published.