Senior Technical Consultant – Application & Data Engineering

Cognizant is seeking a highly experienced Senior Application Developer with expertise in .NET technologies and enterprise-scale database development. The role involves designing and enhancing application interfaces, maintaining backend services, and ensuring high-quality deliverables while collaborating with cross-functional teams.

Responsibilities:

• Design, develop, and enhance application front‑end interfaces using Angular 6+ or other modern UI frameworks
• Build and maintain backend services using C#, .NET Framework 4+, .NET Core, ASP.NET, WebAPI, and related technologies
• Develop and optimize database components including PL/SQL procedures, functions, triggers, and SQL Server objects
• Apply strong knowledge of design patterns and engineering best practices to create scalable, maintainable solutions
• Debug, analyze, and enhance existing application extensions and propose effective design improvements
• Review and update detailed design documents, ensuring alignment with business and technical requirements
• Create, update, and review unit test cases to ensure high‑quality, defect‑free deliverables
• Analyze and resolve defects raised in JIRA, ensuring timely closure and root‑cause analysis
• Ensure 100% adherence to engineering processes and deliverables
• Collaborate with onshore/offshore teams and contribute to Agile ceremonies
• Support data integration, ETL processes, and reporting needs using SSIS, SSRS, Power BI, and related tools
• Provide technical leadership, including mentoring and guiding offshore team members

Requirements:

• 12+ years of experience in application development and solution design
• Strong hands‑on experience with: C#, .NET 8+, .NET Core, ASP.NET, WebAPI, Entity Framework / EF Core, Angular 6+, Vue.js, React, or similar UI frameworks, SQL Server and Oracle PL/SQL
• Experience with Azure DevOps, CI/CD pipelines, Agile/Scrum methodology
• Strong understanding of design patterns, architectural principles, and debugging complex systems
• Experience with logging frameworks such as ELMAH
• Experience with background job schedulers like Hangfire
• Strong analytical, communication, and problem‑solving skills
• Ability to interpret requirements, translate them into technical designs, and deliver high‑quality solutions
• 15+ years of combined experience across SQL Server development, database architecture, and enterprise application engineering
• 5+ years as a SQL Database Administrator, including migration, DR, performance tuning, and security assessments
• Experience incorporating AI tools / copilots into development workflows
• Proven ability to build and manage offshore teams of up to 8 members
• Deep expertise in RDBMS concepts: normalization, indexing strategies, stored procedures, triggers, query optimization, and execution plan analysis
• Strong ETL experience using SSIS, including C# script components, event handlers, and error‑handling frameworks
• Experience creating enterprise reports using SSRS and Power BI
• Hands‑on experience migrating legacy DTS/SSIS packages and SQL Server versions
• Experience with OLAP cubes, data source views, named queries, and Analysis Services deployments
• Proficiency with tools such as Jira, Confluent, MS Project, Visio, and other productivity applications
• Healthcare domain knowledge is a plus