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)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)