877_Consultant - Software Engineer(Dot Net)

JOB INFORMATION

Job Title Name:

Consultant Software Engineer

HCA India Grade / Level:

Consultant

JOB PURPOSE

As a Backend Developer, your primary responsibility will be to contribute to the development, maintenance, and optimization of server-side applications that power our digital solutions. You will play a vital role in shaping the core functionality of our systems, ensuring seamless data flow, and collaborating with cross-functional teams to deliver high-quality software.

This role offers a unique opportunity to gain hands-on experience in backend development, work on diverse projects, and cultivate a strong foundation in server-side programming.

MAJOR RESPONSIBILITIES AND ACCOUNTABILITIES

Collaboration

• Work closely with cross-functional teams, including product managers, designers, engineers, and third-party partners, to ensure backend development aligns with overall project goals.
  
• Participate in discussions and planning sessions to understand project requirements and contribute to the design and architecture of server-side applications.
  

Development

• Design, develop, and maintain SQL Server database objects (Stored Procedures, Functions, Views, Triggers).
  
• Develop, enhance, and support SSIS packages for ETL and data integration.
  
• Migrate SSIS workloads to Azure (SSIS in Azure Data Factory / SQL Managed Instance).
  
• Develop and support.NET applications using C#, ASP.NET, and ASP.NET Core.
  
• Perform Lift & Shift migrations of SQL Server databases from on-premises to Azure SQL Managed Instance.
  
• Analyze .NET, SQL, and SSIS workloads for Azure compatibility.
  
• Resolve migration issues related to performance, data consistency, and connectivity.
  
• Perform SQL and SSIS performance tuning.
  
• Design, develop, and maintain robust.NET Core applications and services, ensuring they meet performance and reliability standards.
  
• Develop and maintain RESTful APIs for seamless integration with front-end applications, adhering to industry standards and best practices.
  
• Implement data exchange formats such as JSON and XML to ensure compatibility and smooth communication between server-side and client-side components.
  

Coding

• Write clean, efficient, and well-documented code for server-side applications, following coding standards and best practices.
  
• Ensure code quality through regular code reviews and adherence to coding guidelines.
  
• Utilize programming languages such as.NET for backend development.
  

Agile Practices

• Participate in Agile development processes, including Scrum practices, to ensure efficient and iterative development.
  
• Engage in regular code reviews, automated unit testing, end-to-end testing, continuous integration, and deployment to maintain high-quality code and rapid delivery.
  

Optimization

• Identify and resolve technical issues, bugs, and performance bottlenecks to enhance overall system performance.
  
• Debug and optimize backend code to ensure maximum efficiency and reliability.
  

Integration

• Collaborate with front-end developers to integrate user-facing elements seamlessly with server-side logic, ensuring a cohesive end-to-end application experience.
  
• Ensure backend functionality aligns with front-end requirements and provides a smooth user experience.
  

Technical Skills

• Apply strong object-oriented design and analysis skills, leveraging design patterns to create scalable and maintainable code.
  
• Utilize knowledge of Microsoft operating systems and application servers to enhance backend development.
  
• Draw on experience across the entire software development life cycle to ensure backend development aligns with industry standards and best practices.
  

Database Management

• Design and maintain databases, ensuring optimal performance, reliability, and data integrity for backend systems.
  
• Write efficient and optimized database queries for data retrieval and manipulation, contributing to overall application performance.
  

Requirements

JOB SPECIFICATIONS

Qualification

• Bachelor’s degree in Information Technology, Computer Science, or related fields
  

Years of Experience

10–14 years of relevant work experience, including:

• 10+ years of engineering experience delivering and supporting production software products (required)
  
• 10+ years of experience with.NET Core using C# (required)
  
• 10+ years of extensive experience designing, developing, and maintaining SQL Server database objects (Stored Procedures, Functions, Views, Triggers) and SSIS packages for ETL and data integration (required)
  

SKILLS AND CAPABILITIES

People Management Skills

• Exceptional stakeholder service skills in a team-oriented, collaborative environment
  
• Exceptional interpersonal skills to interface with all levels of the organization
  
• Strong verbal and written communication skills with the ability to work with staff and business stakeholders (required)
  

Technical Skills

• Experience with ASP.NET, .NET Core, Entity Framework, and C# (required)
  
• Strong knowledge of database design and development preferred – SQL/NoSQL databases
  
• Design, develop, and maintain SQL Server database objects (Stored Procedures, Functions, Views, Triggers)
  
• Develop, enhance, and support SSIS packages for ETL and data integration
  
• Perform SQL and SSIS performance tuning
  
• Experience with Google Cloud and Microsoft Azure (preferred)
  
• Experience with version control systems (GIT) preferred
  
• Experience in designing RESTful API microservices
  
• Hands-on experience with Apache Airflow for workflow orchestration and Kafka for real-time data streaming
  
• Experience with CI/CD pipelines using Jenkins, Argo CD, and similar tools
  

Other Skills

• Strong focus on delivering value to stakeholders (required)
  
• Excellent troubleshooting, analysis, and problem-solving abilities (required)
  
• Willingness to learn the business domain (required)
  
• Experience with continuous integration and continuous deployment (preferred)
  
• Strong analytical and problem-solving skills
  
• Ability to troubleshoot and debug complex issues
  
• Proactive attitude toward learning new technologies and industry best practices
  
• Ability to work collaboratively in a team environment
  
• Willingness to contribute to a positive and inclusive team culture