*Please share your consultant profile at **[email protected] <[email protected]>*
*Job Details:* *Job Title : SQL Server Developer* *Location : Wethersfield, CT* *Duration : 7+ Months* *Phone and F2F Interview is Required* *Job Description:* The Judicial Branch is looking to engage the services of a Software Engineer. The scope of services required for the Software Engineer includes: - *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* *Minimum Qualifications:* The minimum skills and experience levels required for a candidate to be considered for this position include: - *Minimum nine (9) years of experience development coding 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 - 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 - 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* - Proven ability to work independently with minimal supervision - Ability to work well with a team of developers and business analysts *Thanks & Regards,* *Nilesh Awadhiya* *Sage Group Consulting, Inc.* *3400 Highway 35, Suite # 9, Hazlet, NJ 07730 * *Office: 732-767-0010 X 227* *Direct: 732-658-5828* *Fax: 732-658-5828* *Email : [email protected] <[email protected]>* *Website : www.sageci.com <http://www.sageci.com/>* *Gtalk: nilesh.awadhiya |Yahoo IM: n_awadhiya* -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" 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/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
