Epicareer Might not Working Properly
Learn More

DB/SSIS Developer

Salary undisclosed

Checking job availability...

Original
Simplified
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 / project managers to provide consultancy advice, inputs, and effort estimates to projects/CRs.
  • Technical document preparation, technical feasibility assessment and coordination with internal team member 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.
QualificationsQualifications
  • 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 modelling, tables/views, stored procedures, cursor, trigger, 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 practice and tools is a plus.
  • Knowledge and experience with Banking business is a plus.
  • Knowledge and experience in Python are 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.
  • Able to work in fast-paced environment.
  • Possesses a professional demeanor.