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/Architecture
• Research 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 troubleshooting
• Experience 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

Education & 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.