Hello,
“We are a preferred supplier, we pay Top Rates to Consultants and subcontractors. To apply click on the link: http://hireitpeople.com/jobs/357 Please send resumes to syed (at) hireitpeople.com” SQL Data Transformation Consultant Engagement Type: Contract Location: Harrisburg, PA Duration: 6 Months *Short Description:* The Programmer will provide experience and expertise in the conversion of legacy Birth and Death records into the new (Database Application Vital Events) DAVE Birth and Death record system. *Complete Description:* The Department of Health, Bureau of Information Technology seeks a highly skilled resource in SQL Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) to perform the conversion of Birth and Death records from the existing mainframe and client based systems to the Department’s new Vendor supported DAVE system. This resource will report to the General Government Team’s Applications Developer Administrator (ADA). The primary duties for this resource will be: 1. Data Conversion • Execute processes to identify and reprocess any records that were recently updated after the record was converted into DAVE • Verify all records were applied into DAVE system • Clean and process any outstanding records • Execute processes to clean and split out mailing address information for record import into DAVE • Correct any issues found during new record process testing • Create MS Access Form(s) for Bureau of Health Statistics and Research (BHSR) staff to view information before the DAVE system goes live • Create automated jobs to apply records into source tables and upload into DAVE on a nightly basis 2. Reporting database • Create data extract processes that will be used as inputs and integration points into both internal and external systems • Populate information into database 3. Operations • Create/Populate Disaster Recovery environment and database mirroring • Create documentation on all processes using Bureau of Information Technology (BIT) templates. • Test nightly jobs • Schedule nightly jobs within DAVE at Go-Live This engagement will consist of 40-hour work weeks. Skills: Skills Required/Desired Transact SQL Required 5 Years SQL Server- Data Transformation Service (DTS) Required 5 Years SQL Server Integration Services (SSIS) 2005 Required 5 Years MS Access Required 5 Years MS Excel Required 5 Years Production Database Tuning Required 5 Years Excellent Verbal Communication Skills Required 5 Years Excellent Written Communication Skills Required Create Documentation Required 3 Years Questions: Question 1: Client requires an in person interview for this position in Harrisburg. Please confirm the resource is available for this. -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-workflow?hl=en.
