*Hi Associates,* *Please check the below requirement and send profiles to [email protected] <[email protected]>*
*Face to Face After Telephonic* *Locals are Preferred* *Rate: $50/Hr on C2C* *Title: Sr SQL Server Developer * *Location: Wethersfield, CT* *Duration: 6-12 months, with possible extension* *Description:* · Develop and code applications using SQL Server · Analyze and define source structure (structure of data in the legacy system) · Analyze and define target structure (structure of data in the new system) · Perform field mapping (mapping between the source and target structure with data cleansing, if necessary) · Define the migration process (automated and manual) · Develop data extractors and loaders · Manage the data conversion process and data push process to the various development/production environments · Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data · Design and creation of tables including the use of appropriate data types, indexes and foreign key, default constraints, etc. · Design and creation of XML schema · XML knowledge is required since legacy data may have to be converted into XML defined columns. · Performance tuning techniques · Create and maintain technical documentation · Provide management level statistics and reports to monitor data migration progress · Investigate, analyze and document reported defects · Investigate and rectify technical issues within the ETL process · Work well with a team of developers and business analysts *Experience and Skills:* · *9 years SQL Server* experience, must include *SQL Server, 2005 through 2012* · Significant experience of *T-SQL including Triggers, Stored Procedures, and functions* · Must demonstrate knowledge of *ETL (Extract-Transform-Load) concepts* · Has good knowledge / technical approaches in data extraction, validation and cleansing processes / methodology · Knowledge and experience in the design and creation of tables including the use of appropriate data types, indexes and foreign key, default constraints, etc. · Knowledge and experience in the design and creation of *XML schema* · XML knowledge is required since legacy data may have to be converted into *XML defined columns.* · Knowledge and experience in performance tuning techniques · Ability to effectively manage time, prioritize tasks, and have a basic understanding of project management · Verbal communication skills to explain and transfer knowledge both informally and at design and code review meetings. · Written communication skills to prepare regular periodic status reports. · Knowledge and experience of *Microsoft Office Tools* · Solid analytical skills · Excellent verbal and written communication skills · Special consideration will be given to candidates who have working knowledge and experience with developing smart client application using Microsoft Visual Studio with *VB.NET <http://VB.NET>* language or working knowledge of the *Windows Communication Foundation (WCF) framework* Thanks & Regards, *Paul **SVK Systems Inc* 11465, Johns Creek Parkway, Suite #180, Johns Creek, GA - 30097 Contact: 678-824-7757 | Fax: 404-601-9507 Email: [email protected] | Gmail: [email protected] Website: www.svksystems.com [image: Description: Description: Description: Inc.500|5000 Logo] [image: Description: Description: Description: cid:[email protected]][image: Description: Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcSQsCTiUiVCUIlXuZilZE964QZGU0mixwsOAsuJRxcUzIIa6rlVRKKhTw] [image: Description: Description: Description: http://t1.gstatic.com/images?q=tbn:ANd9GcRQFqqr5LzMAumX3JTxImVUvRAUWAULRPdx3k2_neWeGv9jMnH_sJbboeo][image: Description: Description: Description: Description: Description: Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcTzWHC3crnfdWlRitTOkW4JO_g6sndCgqKJs7hRRCKBTS1sG__j] -- You received this message because you are subscribed to the Google Groups "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.
