*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 -- 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.
