Location NJ-New Jersey/ Wayne Duration 12 month
Least 10 Years of experience in SQL Server & SSIS. Hands on Experience in MS SQL Server Integration Services 2005/2008/2012 (SSIS) Functional requirements gathering, analysis, designing data model and SSIS packages etc Significant development experience in SSIS is preferred. Experience in database-related performance tuning. Working knowledge in data modeling. Experience in SQL Server T-SQL database development (data modeling, stored procedures, functions and query optimization). Experience in ETL Processing using the MS SSIS packages, the transactional data processing in various formats like flat files, excel files, direct db pull etc. Experience in the data extraction, cleansing, transformation, lookups etc using SSIS packages the data then pushed into the data marts or central DB. Experience in designing Source & Fact tables. Design and development of job control mechanism to control the execution of the packages in sequence. Design and creation of the audit and event mechanism. Additional responsibilities include tuning the ETL processes, creation of the technical and system specification documents necessary to support ETL processes and participate in development and execution of unit and system test plans. Installation and configuration of SQL Server 2005, 2008 (Standalone & Cluster Environment) and ensuring all aspect of database maintenances Perform Full and Differential backup of database using query DB tuning using various tools available in SQL Server. Backup and Recovery of the database and restoration of the databases. Analysis of locks, isolation levels and index maintenance. Hands on experience on Log Shipping, Mirroring Replication & Failover Clustering Hands on Experience in SP Upgrade and SQL Upgrade MCITP/MCSE certification is an added advantage. -- ----- Please send the resumes to ke...@questinfosoft.com ) Regards, Kevin | Questinfosoft | Direct : 512-553-7942 | ke...@questinfosoft.com | www.questinfosoft.com -- -- To unsubscribe from this group, send email to cbe-software-engineer-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/CBE-Software-Engineer?hl=en --- You received this message because you are subscribed to the Google Groups "CBE Software Engineer" group. To unsubscribe from this group and stop receiving emails from it, send an email to cbe-software-engineer+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
