Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SSIS T-SQL SQL Data Warehouse Data Modeling Table Design Business Requirements Devel
 
Requirement id 13972
Job title Developer
Job location in Des Moines, IA
Skills required SSIS, SQL 2005, T-SQL, SQL Data Warehouse Data Modeling Table D
Open Date 29-May-2013
Close Date
Job type Contract
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type Face to Face interview
   Email Recruiter: coolsoft
Job Description Developer: SSIS, SQL 2005, T-SQL, SQL Data Warehouse Data Modeling Table D

This position will be a member of a team but will need to work independently. They will report to a Senior Architect/DBA but will require self-direction. Job responsibilities will span ETL development, data transformation and modeling.

This position has the potential to extend for three 1- year extensions.

Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. The candidate will be responsible for taking the project through the entire SDLC, working with the business users to determine the business requirements and apply the business rules to the data.

This candidate should be an expert in creating, modifying and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend. Advanced skills in writing complex Structured Query Language (SQL) queries are required.

Experience working with a large variety of data, demographic, personal, numeric data and identify normal ranges, outlier data, typical and non-typical data results.

ETL developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems.
Proficient in development of SQL Server Integration Services (SSIS) packages.
Proficient using MS SQL 2005 or later and writing relational database queries and stored procedures using SQL.
Experience extracting data from a large variety of sources, transforming and loading to a SQL data warehouse
Evaluate and address data quality issues
Developing error checking and resolution routines
Experience in interacting with customers regarding application requirements.
Strong business writing and interpersonal skills necessary for customer contact..

Skill Required / Desired Amount of Experience
Develop, modify and optimize SSIS packages Required 5 Years
SQL 2005 Required 5 Years
SQL 2008 Required 3 Years
Experience building SSIS packages using built-in SSIS components Required 5 Years
Experience writing complex T-SQL Required 5 Years
Experience analyzing, profiling, manipulating data from a large variety of sources Required 5 Years
Experience loading data into a SQL Data Warehouse Required 5 Years
Troubleshoot abstract data, profile, analyze and optimize data Required 5 Years
Develop error checking and resolution routines Required 5 Years
Data modeling experience Required 5 Years
Analyze and optimize table design Required 5 Years
Ability to work with end users to extract business requirements Required 5 Years
Ability to analyze data and apply business rules and requirements Required 5 Years
Agile project experience Highly desired
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 13972 while calling.
 
Other jobs in IA: Des Moines (16), West Des Moines (2), West Desmoines (1),
SSIS job openings in Des Moines, IA
Jobs List

IA-DOM-DoED-TS3-.NET SQL Developer (721499)
Create date: 05-Oct-2023
Remote

start date :10/30/2023

End date :10/30/2024

submission deadline :10/10/2023

client info :ED: Education Department

Description :

The Iowa Department of Education needs a technical and functional development specialist to support .... (This job is for - SSIS JQuery Jobs in IA DesMoines Developer - (in Des Moines, IA))

IA-OCIO-TS2-SQL DBA (666872)
Create date: 01-Nov-2021
Start Date :11/1/2021
End Date :10/30/2022
Submison Deadline :11/5/2021

Client Info: OCIO: Office of the Chief Information Officer

Note :

* Agency Interview Type: In Person Only

Description :

Senior SQL Server DBA/SSIS Dev
The State of Iowa is looking.... (This job is for - SSIS SSRS Jobs in IA DesMoines Consultant - (in Des Moines, IA))

SQL Developer - 73512
Create date: 31-Mar-2021
Candidate must be our W2 Employee.

Job Description:

Responsible for the development, deployment and implementation of the Data Warehouse. This individual has responsibility to ensure assigned deliverables are achieved within required schedule and quality standards.

Responsibilities/Duties/Function/Tasks:

IT Experience SSIS Jobs in IA DesMoines Developer - (in Des Moines, IA))

Tableau Developer - 69128
Create date: 04-Nov-2020
Candidate must be our W2 Employee.

Job Description :

In search for a talented, senior-level Tableau Developer to act as an analytic consultant to develop, enhance, and implement data visualizations including but not limited to dashboards, reports, and other Microsoft visualizations using the SharePoint platform. This position.... (This job is for - T SQL SSIS Jobs in IA DesMoines Developer - (in Des Moines, IA))

ETL Developer - 63865
Create date: 04-Jun-2020
Note:

* Candidate must be your W2 Employee.

Job Description :

Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. The candidate will be responsible for taking the project through the entire SDLC, working with the business users to determine th.... (This job is for - SSISETL Jobs in IA DesMoines Developer - (in Des Moines, IA))
 
 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))

Database Architect III - 130607
Create date: 20-May-2024
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.
.... (This job is for - SSIS CDC Jobs in WI Madison Architect - (in Madison, WI))

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))
 
 SSIS job openings in IA
Jobs List

IA-ED-SDP5-SQL ETL Developer (603603)
Create date: 19-Nov-2019
Start Date :11/29/2019
End Date :11/11/2020
Submission Dead Line :11/25/2019
Client Info :ED: Education Department

Description :

This position will be an ETL developer in the Department of Education. The job will work with existing ETL developer to load data from source system.... (This job is for - SSIS Jobs in IA Desmoines Developer - (in Desmoines, IA))

Sr. SQL Report Developer - 44149
Create date: 01-Mar-2019
Candidate must be your W2 Employee.

We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen.


Job Description :

Requisition Number (to be provided by IM Contracting):


#2019 - 029

Desired Role & Level:

(Refer to attached doc for Standard Role definitions/ Indicate as.... (This job is for - SSRS SSIS Jobs in IA Johnston Developer - (in Johnston, IA))

Analytics Consultant - 35089
Create date: 29-May-2018
Job Description :
Analytic s Consultant

Requirements:

Mid-senior level experience in SQL and relational database concepts. The candidate should also be able to handle multiple projects in a fast paced environment.

Qualifications:

5-7 years experience in reporting or analytics

SQL Serv.... (This job is for - SSRS SSIS SAS Jobs in IA WestDesMoines Consultant - (in West Des Moines, IA))

.Net Developer - 30998
Create date: 12-Jan-2018
Candidate must be our own W2 Employee



5-7 yrs. experience developing applications in .NET
5+ years of C# and VB.NET - including back end/service processing experience
5+ years of SQL Server experience in 2008 R2 or later
5+ years of ASP.NET, including AJAX, JQuery, HTML and Bootstrap
SSIS.... (This job is for - SSIS SSRS Jobs in IA WestDesMoines Developer - (in West Des Moines, IA))

Sr SQL Dev - SDP6-402823
Create date: 25-Mar-2015
Description:

Partners with cross-disciplinary leadership to define complex functional and technical specifications to existing and new ETL processes working with SQL Server 2012 using SQL Server Management Studio tools against databases.
• Leads analysis and design of new ETL (Extract/Transform/Load programs) development across mult.... (This job is for - SSIS Jobs in IA IowaCity Developer - (in Iowa City, IA))
(Developer: SSIS, SQL 2005, T-SQL, SQL Data Warehouse Data Modeling Table D in Des Moines, IA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us