Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SSIS CDC SQL Server Technical Applications Architect
(Jobs in Madison, WI)
 
Requirement id 147441
Job title Architect
Job location in Madison, WI
Skills required SSIS, CDC, DB2 (SQL), SQL Server Technical Applications
Open Date 20-May-2024
Close Date
Job type Contract
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Architect: SSIS, CDC, DB2 (SQL), SQL Server Technical Applications

Bid Limit Per Vendor : 1

Start date : 07/01/2024

End Date : 06/30/2025

Submission deadline :5/22 at 4:00 PM CST.

Client Info : DCF

Note :

INTERVIEW NOTES:
• Phone and web based interviews will be acceptable.
• However, an in--person interview may be required.
• Interviews will be set up shortly after the posting close date.
• MUST provide three (3) business references for the interview. (One reference must be a supervisory level.)

IMPORTANT NOTES:
• Candidate MUST be physically located in the United States. International candidates/phone numbers will not be accepted.
• Candidate must follow ALL DCF work rules
• Candidate must be available to perform all work during the Central Standard Time (CST) business hours 9:00 am – 3 pm (or CST hours as defined by the hiring manager)
• Candidate will be required to provide their own equipment for this position (See job description for required specifications.)

Duration: 6/30/2025, with the potential to extend for an additional term(s)

This position is currently remote. However, position status is subject to change.

Hybrid/On Site positions: Local candidates or willing to relocate at the candidates expense. No designated work-space will be assigned however, selected candidate must be available to work at our location as needed. DCF work location is 201 W. Washington Ave., Madison, WI 53703. DCF does not pay for travel time or reimburse for travel expenses.

Description :
------------------------------------------------------
The recruitment is seeking an experienced application database architect who will work closely with an application development team and project manager in the Enterprise section to design, code, test, and migrate existing DB2 data into SQL Server as new web applications are developed and released. The individual in this position will:
• Work on and analyze two different database, DB2 and SQL Server
• Create SSIS packages to support CDC
• Perform ETL from CDC tables to history tables without loss of data
• Collaborate with business analyst, project manager, and program area stakeholders to define requirements for data migration
• Plan and execute migration of high-profile modernization projects
• Document database and migration processes
• Develop .NET and SSIS packages
• Create data flow diagrams
• Develop strategies for data acquisitions and archive recovery
• Clean and maintain database by removing and deleting old data
• Adhere to consistent data migration processes
• Develop, implement, and optimize in-application SQL statements, stored procedures and functions
• Have strong proficiency with SQL and experience with Visual Studio, C#, CDC and SSIS
• Create database triggers for use in automation
• Have experience and expertise in leading large and complex data migration projects
The database architect is expected to work with minimal supervision, have strong communication and leadership skills, and be a team player. They are expected to demonstrate exceptional judgement based on experience to plan and accomplish data migration goals. Hands on technical expertise and development is required.

Prior experience building and supporting Collection-focused web applications, such as Benefits Recovery Investigation Tracking System (BRITS), and experience with the referral/investigation lifecycle and claims processing is required.

List any special qualifications & years of experience:(List any specific skills, software, or requirements the position will require. Optional format below)
Optional format: (Add as many lines as needed.)
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 147441 while calling.
 
Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2),
SSIS job openings in Madison, WI
Jobs List

Data Warehouse Developer III - 119696 - SP
Create date: 03-Jul-2023
start date : 07/31/2023

End date : 06/30/2024

submission deadline : 7/12/2023 4:00PM CST.

client info : DPI

Note :

* Interview Process: Microsoft Team, 1 round, with audio and video on, also be prepared to share your screen.

* Duration: Until June 30, 2024 with possibility of ext.... (This job is for - SSIS Agile Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III - 118176 - SP
Create date: 24-May-2023
start date : 07/01/2023

End date : 06/30/2024

submission deadline : 5/26/2023 4:00PM CST.

client info : DPI

Note :

* Interview Process: Microsoft Team, 1 round, with audio and video on, also be prepared to share your screen.

* Duration: Until June 30, 2024 with possibility of exte.... (This job is for - SSIS Agile Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III-109335-SP
Create date: 28-Sep-2022
Start date :10/24/2022

End Date : 06/30/2023

Submission deadline :9/30/2022 4:00PM CST

Client Info : DPI

Description :

This position is responsible for providing technical expertise and services regarding the extract, transfer, and load of data for the Department, including creating SSIS packa.... (This job is for - SSIS Agile Jobs in WI Madison Developer - (in Madison, WI))

Business Intelligence Data Warehouse Developer II
Create date: 15-Aug-2019
Start Date : 09/16/2019
Submission Dead Line : 8/21/2019

Description :

The College is seeking one (1) highly motivated and capable person to help with the effort to convert existing ETLs to SQL Server Integration Services (SSIS). Requirements include performing data analysis, solution development in the form o.... (This job is for - SSIS ETL Jobs in WI Madison Developer - (in Madison, WI))

Software Engineer3 - WISCJP00016143
Create date: 05-Aug-2019
Start Date : 08/26/2019
End Date : 06/30/2020
Submission Dead Line : 08/06/2019
Client Info : DOA – Division of Enterprise Technology (DET)

Description:

We are seeking an enthusiastic and motivated candidate who thrives in a fast-paced environment to join our team as a .NET develop.... (This job is for - SSIS Jobs in WI Madison Engineer - (in Madison, WI))
 
 SSIS job openings in other states
Jobs List

NCDEQ - Data Analyst /Architect-Xpert (746252)
Create date: 05-Sep-2024
No of Submissions : 2

Start date : 09/16/2024

End Date : 08/18/2025

Submission deadline : 09/11/2024

Client Info : NCDEQ-ITS

Note:

* Agency Interview Type : Either Webcam Interview or In Person

* Remote

* Equipment can be shipped to the candidate.

De.... (This job is for - SSIS Jobs in NC Raleigh Architect - (in Raleigh, NC))

NCDEQ - Data Project Manager (740337)
Create date: 24-Jun-2024
* Remote

No of Submissions : 2

Start date :06/17/2024

End Date :06/15/2025

Submission deadline :06/28/2024

Client Info :NCDEQ-ITS

Note:

* Either Webcam Interview or In Person

* Equipment can be shipped to the candidate.

Description :

Curre.... (This job is for - SSIS Jobs in NC Raleigh Manager - (in Raleigh, NC))

NCDEQ - Data Analyst /Architect-Xpert (740356)
Create date: 24-Jun-2024
* Remote

No of Submissions : 2

Start date :06/24/2024

End Date :06/24/2025

Submission deadline :06/28/2024

Client Info :NCDEQ-ITS

Note:

* Either Webcam Interview or In Person

* Equipment can be shipped to the candidate.

Description :

Curren.... (This job is for - SSIS Technology Jobs in NC Raleigh Architect - (in Raleigh, NC))

Chesterfield County Data Warehouse Architect 4 (730461)
Create date: 29-Feb-2024
Hybrid

Start date :03/18/2024

End Date : 10/14/2025

Submission deadline : 3/5/2024

Client Info : Chesterfield County

Description :
------------------------------------------------------
*Local Richmond area candidates or those willing to relocate to the Richmond area during this engag.... (This job is for - SSIS Sql Server 2000 Jobs in VA Chesterfield Architect - (in Chesterfield, VA))

Database Administrator 3 -123972
Create date: 31-Oct-2023
Start date : 11/20/2023

End date : 04/26/2024

Submission deadline : November 6, 2023, 10 AM CST.

Client info :DESE

Note:

* Interview Process: Remote/WebEx interviews will be scheduled.

* Duration of the Contract: 7 months, with potential to extend.

* Onsite or Remote? .... (This job is for - SQL SSIS ETL Jobs in MO JeffersonCity Administrator - (in Jefferson City, MO))
 
 SSIS job openings in WI
Jobs List

ETL Developer - 73042
Create date: 17-Mar-2021
Note: Must have EXCELLENT communication.

Job Description:

Seeking multiple ETL Developers for a REMOTE contract opportunity in the Greater Milwaukee area.

MUST HAVE: Strong ETL, SSIS, Informatica a plus. This is not an SSIS REPORT WRITER, THIS IS AN SSIS/ETL DEVELOPER

Responsibilities:

Will b.... (This job is for - ETL SSIS Jobs in WI WestBend Developer - (in West Bend, WI))

Microsoft ETL Developer - 66712
Create date: 15-Sep-2020
Job Description :

Responsibilities:

Will be fetching data from Mainframe into SQL/EDW. Much of the work is in SSIS (90%; 10% Informatica)

Skillset:

SSIS

SQL Server

T-SQL

Entity Model

Able to identify and test cases (not just developer)
.... (This job is for - SSIS SQL T SQL Jobs in WI WestBend Developer - (in West Bend, WI))

Microsoft ETL Developer X3 - 65677
Create date: 07-Aug-2020
Note :100% remote even after Covid subsides - likely to be long term

Job Description : Responsibilities:

Will be fetching data from Mainframe into SQL/EDW. Much of the work is in SSIS (90%; 10% Informatica)

Skillset:

SSIS

SQL Server

T-SQL

Entity Model
.... (This job is for - SSIS SQL T SQL Jobs in WI WestBend Developer - (in West Bend, WI))

Microsoft Business Intelligence Developer - 44988
Create date: 20-Mar-2019
Candidate must be your W2 Employee.
We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen.


Job Description :


Description:

This role is vital for designing our Quality Metrics Data Warehouse and the various integrations required to provide executive leadership with an accurate picture of heal.... (This job is for - SSIS SSRS Jobs in WI Milwaukee Developer - (in Milwaukee, WI))

SSIS Developer - 214
Create date: 25-Apr-2016
Start Date :02/15/2016
End Date :01/31/2017
Submission Deadline :04/29/2016
Description :

SSIS Developers will be creating SSIS packages, maintaining existing SSIS code, and running SSIS batch jobs to meet client requirements for federally mandated financial risk analysis reporting.
SSIS Jobs in WI Milwaukee Developer - (in Milwaukee, WI))
(Architect: SSIS, CDC, DB2 (SQL), SQL Server Technical Applications in Madison, WI)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us