*Please send me profile on my id vsaras...@tekshapers.com <vsaras...@tekshapers.com>*
*Position: SQL Developer * *Location: Camp Hill, PA* *Duration: 6 Months* *MOI:- Telephonic + Skype* *Required:* · SSIS Expertise · *BizTalk Expertise* · Dot Net Expertise · SQL/Stored Procedure Expertise *Responsibilities:* · Working with business user, Business analysts and application team to understand the business and application requirements. · Develop an understanding of the legacy data what it is, what are the SSIS Sources can be used to extract legacy data, what is the destination, where it comes from, where it is going and what SSIS Transformations are being done to it before loading into SQL Server 2012. · Develop an understanding of the old system (DB2 System) and how all the pieces work together after Integration in SQL Server 2012 Database. · Review data models for data warehousing and Need to design the SSIS Packages using SQL Server 2012 Data tools (SSIS). · Need to create ETL pipelines that are highly optimized, datasets; need to create SSIS packages using new features available in 2012 data tools and working knowledge of dynamic SQL Performance in expressions and in control flow tasks. · Need to develop Parameterized, Sub Report, Pie Chart, Bar charts, Gauge report, Drill Down, Drill Through, and Linked Report using SSRS Data tool. *Skills / Experience:* · Expert in Data Conversion, Data Fix, Data Mapping, Data reconciliation using SSIS control flow, data flow tasks and Script Task. · Working knowledge of SQL Server 2012 in writing stored procedures, functions, Views, complex SQL queries etc. · Experience with Infosphere CDC, Data De-Duplication and Data Cleansing using SQL server integration services. · Gain in-depth knowledge of reports using SSRS, Project and package deployment, Integration service catalog. · Practical experience in building web and windows applications in .Net framework. · Experience in creating ETL transformations and SSIS Control flow using BIDS designer and provided proper Logging, Configuration, Package level error handling and Data Level error handling. Vijay Saraswat Talent Acquisition Executive Tekshapers Inc. |1441 E Maple Rd,Suit#301,Troy,Michigan, USA 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> * 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 "Oracle Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to oradev+unsubscr...@googlegroups.com. To post to this group, send email to oradev@googlegroups.com. Visit this group at http://groups.google.com/group/oradev. For more options, visit https://groups.google.com/d/optout.