.Net Developer - SSIS

Job Description : - Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS. - Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting. - Create routines for importing data utilizing XML, CSV and comma delimitate files. - Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area. - Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service. - Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization. - Extract the data from XML and load it to dimensional model. - Maintain SQL scripts, indexes, complex queries for data analysis and extraction. - Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data. - Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy. - Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement. - Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements. - Develop T-SQL functions and store procedures to support complex business requirements. - Create and configure an OLTP replication database for disaster recovery purpose. - Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server. Skills : ASP.NET, C#, SSIS, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SSAS, XML, OLTP, OLAP, SQL, MS SharePoint and T-SQL (ref:hirist.tech)

Location: in, IN

Posted Date: 3/26/2025