MSSQL-SSIS

Roles and Responsibilities:

• Work as part of RDS ETL dev team in the implementation of RDS Risk specific deliverables, loading data from specific source systems, transformation logic implementation
• Design, Development of various modules and models involved in the Market risk projects.
• Implement small enhancements align with upstream changes, liaise with teams with Risk Technology to load data to create consistent environments. Work with Business analysts to eliminate differences in environments - use some current applications (java based) to do ETL along with SSIS.
• Ownership of project work during difference phases from initiation, development, unit testing to QA, UAT, Staging and Production.
• Enhance existing ETL tool to make them compliant with windows 2022 and Nomura private cloud.
• Regional L3 coverage. Providing regional technical SME input to the production services / L2 team
  

Mind set:

• Working experience and strong technical knowledge of MS SQL Server Integration Services/ETL Developer, MS SQL Server
• Working Knowledge of Data warehousing, slowly changing dimension concepts & dimension modelling, Autosys job scheduling, Unix shell scripting, C#
• Able to troubleshoot problems in multiple environments in a stack with diverse technology.
• Strong technical and analytical skills.
• Knowledge and Working experience in DevOps tools such as Jenkins, Git, Ansible and SonarQube.
• Excellent communication skills, ability to multi-task, and work towards tight deadlines.
• Self-starter who will be able learn quickly and able to perform in flexibility working hours.
  

Skillset

• Expertise of MS SQL , MS SQL Server Integration Services , C# scripting applicable for SQL Server Integration Services - core skills
• Strong data investigation and problem-solving & debug skills