Voya India | Senior Software Engineer SSIS | bangalore

About Voya India:Voya India (earlier VFISLK) started out as a joint venture between U.S. financial services company Voya Financial and SLK, a software services company and is head quartered at Bangalore. As of Aug 2023, we are a wholly owned subsidiary of Voya Financial. We are a dynamic technology & business process transformation company that provides world-class technology & business process management services, with an emphasis on quality, speed & optimization driven through automation. We support and deliver innovative solutions to Voya's Retirement, Employee Benefits, and Investment Management businesses. More information about us is available at: https://www.voyaindia.comPosition Overview:The purpose of the Senior Software Developer is to support and improve business processes by delivering IT solutions within Investment Management.The Senior Developer will use analytical skills to help develop complex solutions and code solutions in MS SQL Server.The Senior Developer will design business functions, applications, information, and infrastructure architectures.The Senior Developer will ensure coding, testing, debugging, and maintaining components of applications and data.Job Responsibilities:Code high-risk and/or high-complexity modules and establish patterns & practices for the team to follow.Collaborate with Architects, Product Owners, and Scrum master's to establish requirements and to implement overall project plan & solution design.Interact with business and technical stakeholders to understand requirements, challenges, and expectations.Ensure adherence to standards and guidelines and on-time delivery of team deliverables.Own Analysis and High-Level Design/ArchitectureResearch new frameworks, solutions, tools, techniques, and best practices to improve team productivity.Perform thorough design and code reviews and support code deployments/post go-live activities.Conduct root cause analysis & corrective measures on defects/issues identified.Provide technical direction and coaching to software developers in application development activities (2-4 people)Adhere to all organizational and IT policies and processes for software development and project management.Understand, apply, promote, and contribute to the delivery methodologies, standards, and tools.Explore innovative technology trends and apply them in appropriate scenarios to deliver value to Team, Customer and Organization.Contribute to Organizational knowledge base thus bringing in reusability and reducing operational cost.Requirements and Qualifications:7+ years of overall IT experience with hands-on experience in coding.7+ years of experience in MS SQL development solutions. Deep MS SQL with experience in Stored Procedure development. Relational database concepts for design and development.Strong knowledge of Pearl with 3+ years of working experience.5+ years of experience working in any job scheduler (preferable Tidal).5+ years of experience in ETL, experience with data load jobs creation.3+ years of experience with reporting tool like SQL Server Reporting Services.Advanced MS Excel and MS Access skills with ability to write and edit macros will be preferred.Expert understanding of Design patterns, practices, and concepts with ability to implement these the technology solutions.Hands on with coding, unit testing and production issue troubleshootingExperience with Visual Studio 2017/2019/2022 and TFS (Team Foundation Server)Experience working as a direct point of contact with the business and/or key stakeholders.Experience working in a fast-paced Agile environment.Excellent verbal & written communication skills with strong interpersonal & influencing skills and ability to effect change in a matrix managed organization.Must be able to prioritize and organize workload, drive to multiple deadlines, and focus on results.Experience in release management process utilizing CICD and DevSecOps concepts.Understanding Azure Cloud platform would be beneficial.C# or Python knowledge would be a plus.Working knowledge of GIT would be a plus.Proficiency in MS Project, Outlook, Word, Excel, SharePoint, Visio, and PowerPoint AGG