Senior Developer - IT

Company Description

WNS, part of Capgemini, is an Agentic AI-powered leader in intelligent operations and transformation, serving more than 700 clients across 10 industries, including Banking and Financial Services, Healthcare, Insurance, Shipping and Logistics, and Travel and Hospitality. We bring together deep domain excellence - WNS’ core differentiator - with AI-powered platforms and analytics to help businesses innovate, scale, adapt and build resilience in a world defined by disruption.Our purpose is clear: to enable lasting business value by designing intelligent, human-led solutions that deliver sustainable outcomes and a differentiated impact. With three global headquarters across four continents, operations in 13 countries, 65 delivery centers and more than 66,000 employees, WNS combines scale, expertise and execution to create meaningful, measurable impact.

Job Description

Position Summary 

Seeking a senior-level SQL Server and ETL developer with deep expertise in SQL Server 2022/2025, advanced T-SQL, SSIS, data integration, and analytics. The role owns client data onboarding, master data management, ETL development, production support, and data quality. Candidates with practical AI skills to automate data ingestion, validation, monitoring, and accelerate data analysis and insight generation will be highly preferred. 

Detailed Responsibilities 

• Lead client onboarding and implementation projects. 

• Design, develop, maintain and support SSIS packages. 

• Manage daily, weekly, monthly, quarterly and ad hoc data loads. 

• Receive, validate, transform and reconcile client source files. 

• Support master data integration and maintenance activities. 

• Investigate and resolve data load failures, mapping issues, and data quality concerns. 

• Develop SQL-based reports, extracts, and analytical datasets. 

• Support Power BI and Tableau reporting initiatives. 

• Create monitoring and operational support processes. 

• Participate in production deployments, implementation activities, and after-hours support as required. 

Qualifications

Required Qualifications 

• 6+ years Microsoft SQL Server experience, particularly with Microsoft SQL Server 2019 or later

• 5+ years hands-on SSIS development. 

• Advanced T-SQL skills including stored procedures, views, functions, reconciliation and data analysis. 

• Experience supporting enterprise ETL and operational data environments. 

• Strong problem-solving, communication, documentation and analytical skills. 

• Must be authorized to work in the United States on a full-time basis for any employer
• Bachelor's degree in computer science engineering, mathematics, information technology, Business Administration required Or master’s degree in computer science, computer application or Business Administration required

Technology Stack (must-have)

• SQL Server 2022/2025 

• SSIS 

• Power BI / Tableau 

• SSRS/SSAS (nice-to-have)

• On-Prem Microsoft Data Platform 

Preferred Qualifications 

• Healthcare, payer, claims, eligibility, provider or membership data experience. 

• Power BI and Tableau experience. 

• Advanced T-SQL and SSIS experience. 

• Data warehouse and master data management concepts. 

AI & Innovation

• Current AI usage: data summarization, intelligent fax processing, automated task creation, software development productivity. 

• Drive expansion of AI-enabled data operations. 

• Identify ETL automation opportunities. 

• Implement AI-assisted validation, reconciliation, monitoring, onboarding and analytics. 

• Leverage Microsoft Copilot, GitHub Copilot, Cursor AI, Claude AI, ChatGPT/OpenAI and related platforms. 

AI & Automation Expectations 

• Recommend measurable AI initiatives. 

• Reduce manual effort through automation. 

• Accelerate analytics and business insight generation. 

• Improve data quality and operational efficiency using AI-assisted workflows. 

Additional Information

Compensation Disclosure

The base salary range for this position is $120,000 - $135,000 annually. This represents the base pay range that we reasonably expect to offer for this position.

Final compensation will be determined based on a variety of factors, including but not limited to the