DB/SSIS Developer

Job Description - DB/SSIS Developer (25000074)

The position entails designing and driving the implementation of development best practices, while playing a crucial role in spearheading technical analysis, design, development, and system testing around the bank’s specific technology streams and its sub-system.

Responsibilities

• Act as the SME, responsible for the architecture design, roadmap, and implementation of all change initiatives on the platform.
• Ensure timely delivery, perform inspections to ensure quality of the relevant documentation, artifact and work packages in accordance with the Bank’s SDLC and Agile processes.
• Work with the solution architects, solution managers, and project managers to provide consultancy advice, inputs, and effort estimates to projects/CRs.
• Technical document preparation, technical feasibility assessment, and coordination with internal team members to accomplish the task.
• Collaborate with the Run-the-Bank organization to provide 3rd level support, engaging them to gather input on operational, non-functional requirements to ensure resilience, scalability, and high performance.
• Utilize programming methodologies and languages and adhere to coding standards, procedures, and techniques while contributing to the technical code documentation.
• Participate in project planning sessions with project managers, business analysts, and team members to analyze business requirements and outline the proposed IT solution.
• Participate in design reviews and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow and understand and comply with Project Life Cycle Methodology in all planning steps.
• Document the detailed application specifications, translate technical requirements into programmed application modules, and develop/enhance software application modules.
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation.

Qualifications

• 12 - 14 years of hands-on experience with MS SQL Server, SSIS, and MS Visual C#.
• Deep knowledge of SQL language with common database platforms such as SQL Server and Oracle.
• Deep knowledge of SQL language concepts like database modeling, tables/views, stored procedures, cursors, triggers, functions, indexes, and complex queries.
• Expertise in solving SQL Server performance issues.
• Knowledge and experience in complex SSIS packages development to perform ETL operations from various data sources.
• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.
• Expertise in SSIS deployment and troubleshooting.
• Knowledge and experience with Control M Scheduler is a plus.
• Knowledge and experience with DevOps practices and tools is a plus.
• Knowledge and experience with Banking business is a plus.
• Knowledge and experience in Python are a plus.
• Bachelor’s degree in computer science, Management Information Systems, Engineering, or a related field.

Skills and Abilities

• Motivated and demonstrates initiative.
• Able to critically think and be solution-oriented.
• Strong interpersonal skills and able to work easily with project members.
• Works well independently and within a team.
• Great organizational, time management, and problem-solving skills.