Consultant - Software Engineer

Consultant Software Engineer 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 the 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 MI) · Develop and support .NET applications using C#, / Core · Perform Lift & Shift migrations of SQL Server databases from on-prem to Azure SQL Managed Instance · Analyze .NET + SQL + 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 that 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 with the entire software development life cycle to ensure that backend development processes align 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 the overall performance of the applications. R EPORTING STRUCTURE Does this position formally supervise employees? (Y / N) No JOB SPECIFICATIONS Qualification Bachelor’s degree in information technology, computer science or related fields Y ears of E xperience 10 - 14 Years of relevant work experience including : · 10+ year(s) of engineering, delivering and supporting production software products (required) · 10+ year(s) experience with .Net Core in C# (required) 10 + years(s) extensive experience with design, develop, and maintain SQL Server database objects (Stored Procedures, Functions, Views, Triggers, SSIS packages for ETL and data integration ) (required) Skills and Capabilities Details 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 with the ability to work with staff and business required Technical Skills · E xperience with , .Net Core , Entity Framework and C# required · Strong knowledge with database design and development preferred – SQL/NoSQL DB · 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 versioning control (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 stakeholders value required · Excellent troubleshooting, analysis, and problem–solving abilities required · Willingness to learn our 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