*Please send me profile on my id vsaras...@tekshapers.com <vsaras...@tekshapers.com>*
*Position:- MSBI Developer* *Location:- Bridgewater, NJ* *Duration:- 6+ Months* *MOI:- Telephonic + Skype* *Development team is looking for a strong technical candidate with the following work experience and skill sets:* - Strong experience in MS SQL Server 2000/2005/2008 with BI in SSIS - Extensive knowledge of Relational Database Management Systems. - Excellent backend skills in creating SQL Data Objects. Strong background and knowledge of T-SQL – DML, DDL, Transactions, Stored Procedures, - Triggers and Functions to facilitate efficient data manipulation and data consistency. - Proven ability in Performance Tuning, Query Optimization and running Database. - Expert in understanding business-data relationships, modeling data and creating data mappings. - Strong database design skills – Normalization, Keys, Indexes, Joins, and Partitions. - Experience in extraction & migration of data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS, and BCP & Bulk Insert utilities. Optimized queries using SQL - Profiler and Database engine tuning advisor. - Extensive experience in creating ETL packages using SQL Server 2005/2008 Integration - Services (SSIS) and scheduling packages, cleaning bad data, validating data using SSIS wizard. - Knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake - Modeling, FACT and Dimensions Tables using Analysis Services and experience working with Normalization and - De-Normalization techniques for both OLTP and OLAP systems. - Experience in using multiple transformations provided by SSIS such as script component, - Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension. - May require a bachelor's degree. - Requires 5 - 7years of experience in the field or in a related area. - Familiar with a variety of the field's concepts, practices, and procedures - Relies on experience and judgment to plan and accomplish goals - Performs a variety of complicated tasks - May lead and direct the work of others - Experience working within a matrix project team - A wide degree of creativity and latitude is expected. *Soft Skills Requirements:* - Excellent communication, interpersonal and professional client interaction skills - Excellent team player, quick learner , detail oriented and responsible - Strong analytical, management, organizational and problem solving skills - Ability to adapt quickly to fast pace and changing environment along with new technological innovations - Able to communicate and get along well with other coworkers Regards, Vijay Saraswat(Sr Technical Recruiter) [image: cid:image001.png@01D01011.0B0A3090] Tel Off: 248.565.4747 | Ext. 108| F: 248.254.7211 | Email Id: vsaras...@tekshapers.com <hgul...@tekshapers.com> | W: www.tekshapers.com GTalk: vsaras...@tekshapers.com <ras...@tekshapers.com>/*vijay.rgtalent* Tekshapers Inc. |1441 E Maple Rd,Suit#301,Troy,Michigan, USA [image: Copy of EVerify1.JPG]*[image: cid:image002.jpg@01CE219B.4EAC8660][image: cid:image003.jpg@01CE219B.4EAC8660]* *[image: cid:image002.jpg@01CDF7C5.FA039850] Please consider the environment before printing this email. Go Green!**!!!* *Disclaimer:* If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@tekshapers.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "mainframe" group. To unsubscribe from this group and stop receiving emails from it, send an email to mainframe+unsubscr...@googlegroups.com. To post to this group, send email to mainframe@googlegroups.com. Visit this group at http://groups.google.com/group/mainframe. For more options, visit https://groups.google.com/d/optout.