Job Title: MSBI Developer
Remote
Job Details:
Skills:
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Azure Data Warehouse.
• Used C# code in Script Task and Script Component for custom data source (I.e., JSON, REST API).
• Developed, deployed, and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database
• Database performance tuning and Index Optimization
• Database Security Control and Auditing and server activity Monitoring.