Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
T-SQL SQL SSIS MS Access Developer
(Jobs in Harrisburg, PA)
 
Requirement id 8653
Job title Developer
Job location in Harrisburg, PA
Skills required T-SQL, SQL Server, SSIS, MS Access
Open Date 23-Feb-2012
Close Date
Job type Contract
Duration 4 Months
Compensation DOE
Status requirement ---
Job interview type Face to Face interview
   Email Recruiter: coolsoft
Job Description Developer: T-SQL, SQL Server, SSIS, MS Access

[Note: Start Date : 02/22/2012
End Date : 06/30/2012]

Description:

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 Departments new Vendor supported DAVE system. This resource will report to the General Government Teams Applications Developer Administrator (ADA).

Responsibilities:

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

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

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

Required Skills:

* Transact SQL
* SQL Server – Data Transformation Services (DTS)
* SQL Server Integration Services (SSIS) 2005
* MS Access
* MS Excel
* Production Database Tuning
* Excellent Verbal Communication Skills
* Excellent Written Communication Skills
* Create Documentation
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 8653 while calling.
 
Other jobs in PA: Dauphin (1), Dauphin County (3), Downingtown (2), Glen Milla (1), Harribsurg (1), Harrisburg (47), Horsham (6), Malvern (2), Pennsylvania (13), Phila (2), Philadelphia (16), Pittsburgh (1), Radnor (2), Reading (1), Sharon (3), WAYNE (1), West Cheste (1), West Chester (33),
T-SQL job openings in Harrisburg, PA
Jobs List

246584-PDE EdFacts-SQL Analyst/Developer
Create date: 23-Mar-2011
Short Description:
Responsible for analysis, SQL Procedure, coding, testing, and implementation in support of PDEs EdFacts effort.
Complete Description:
"PR 3 -Years of Relevant Experience: 5 plus years
Preferred Education: 4 year college degree or equivalent technical study

Role Description:
Analyze, design, and.... (This job is for - T SQL Jobs in PA Harrisburg Developer - (in Harrisburg, PA))
 
 T-SQL job openings in other states
Jobs List

Senior Application Developer - 125949
Create date: 08-Mar-2024
Start date : 03-11-2024

Submission deadline : 3/15/2024

Client info : The Commonwealth of Massachusetts

Note :

* hybrid in quincy ma

Description :

The Massachusetts Executive Office of Health and Human Services (EOHHS) is the largest sec.... (This job is for - T SQL PowerShell Jobs in MA Quincy Developer - (in Quincy, MA))

Programmer Analyst 6 - 122951 - SP
Create date: 02-Oct-2023
start date : 10/23/2023

End date : 1 Years from projected start date

submission deadline :10/10 at 10am EST.

client info :DOC

Note:

* Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discourage.... (This job is for - T SQL Jobs in MI Lansing Analyst - (in Lansing, MI))

T-SQL Developer - SME - 119468 - SP
Create date: 22-Jun-2023
start date : 7/10/2023

End date : 09/30/2024

submission deadline : 6/30/2023 3:00:00 PM

client info : MDEK12

Note :

* Off-site

Description :

This position will require qualified T-SQL Developers to take the lead in the fol.... (This job is for - T SQL Jobs in MS Jackson Developer - (in Jackson, MS))

System Analyst 5 - 116409 - SP
Create date: 20-Apr-2023
start date : 05/01/2023

End date : 04/30/2024

submission deadline : 4/28/2023 at 10 am EST.

client info : MDOS

Note :

* Interviews: MS TEAMS Video with camera on and integrated audio used.

* Duration: 1 year; extension likely

* Local and Non-Local candidates may apply.... (This job is for - T SQL Jobs in MI Lansing Analyst - (in Lansing, MI))

Software Test Analyst 3 - 116410 - SP
Create date: 20-Apr-2023
start date : 05/01/2023

End date : 04/30/2024

submission deadline : 4/27/2023 at 10 am EST.

client info : MDOS

Note ;

* Interviews: MS TEAMS Video with camera on and integrated audio used.

* Duration: 1 year; extension likely

* Local and Non-Local candidates may apply.... (This job is for - T SQL Jobs in MI Lansing Analyst - (in Lansing, MI))
 
 T-SQL job openings in PA
Jobs List

Senior Data Engineer - 71479
Create date: 02-Feb-2021
Note: 100% REMOTE MUST BE EST TIME ZONE

Candidate must be our W2 Employee.

Job Description:

We have a 3 month contract need for the following position. This would be an on-shore full time consultant to help with a project in our direct to consumer and retail departments. They would be working with SAP, Mas500, and O.... (This job is for - SSIS T SQL EDI Jobs in PA FortWashington Engineer - (in Fort Washington, PA))

Senior SQL Developer - 64502
Create date: 26-Jun-2020
Note: Long Term Contract

Candidate must be our W2 Employee.

Job Description : Client: SEI Investments

Location: Oaks, PA (initially remote but will eventually go on-site)

Title: Senior SQL Server Developer

Interview Process: Coderbyte SQL Assessment - 30 Phone I/V with SEI - 1 hour Phone I/V wi.... (This job is for - SQL T SQL Reporting Jobs in PA Oaks Developer - (in Oaks, PA))
(Developer: T-SQL, SQL Server, SSIS, MS Access in Harrisburg, PA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us