Description

Description:

  • Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
  • Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM
  • Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
  • Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
  • Design, implement and maintain database objects (tables, views, indexes, ) and database security
  • Experience working with SSIS packages
  • Proficient with ETL tools such as Microsoft SSIS
  • Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
  • Test and prepare ETL processes for deployment to production and non-production environments
  • Support system and acceptance testing including the development or refinement of test plans

Qualifications :

  • Relevant degree such as Bachelor's and Collage Degree in Computer Science, Education, Engineering, Technical, Business, Information Technology, Software Development, Technology, Financial Services, Information Systems

Skills :

·         TSQL

·         Data Modeling

·         SQL

·         SSIS Development

·         .Net/Java

·         Stored procedures

 

Education

Bachelor's degree