Sr. Developer – SSIS & SQL

Key Skills: MS SQL development, SSIS, SSRS, ETL, Stored Procedure development, Job Scheduler, Advanced MS Excel and MS Access, Domain: Insurance or Banking or Financial Services.Job Description:This role provides direct support for portfolio managers, operations, performance management and compliance teams.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/201+/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 PowerPointEducation & Certifications:Engineering Graduate or BSc in Computer Science/Information Science or Equivalent.5+ years of experience in Insurance or Banking or Financial Services.Agile certifications would be a plus.