1.Excellent SQL scripting knowledge (procedures triggers indexes) along with query optimization techniques. 2. Handson experience in MS SQL Server (SSMS) SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS Optional). 3.Handson knowledge of ETL processes and implementing incremental data loads with SSIS or ADF is preferred. 4. Strong experience in TSQL and query optimization developing ETL strategies 5. Good understanding of Dataware house concepts and Data modelling 5. Developed mappings in SSIS to load the data from various sources SAP Hana Hadoop SQLServer Excel and Flat File into the Data warehouse by performing different transformations
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.