Stored Procedures Triggers T SQL SSIS SSAS SSRS Requirements Analysis SQL Queries   Requirement id 12800 Job title Developer Job location in Frankfort, KY Skills required Sql Developer, MS SQL 2008, Integration Test Experience, Stored Procedures Triggers T SQL SSIS SS Open Date 18-Mar-2013 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Sql Developer, MS SQL 2008, Integration Test Experience, Stored Procedures Triggers T SQL SSIS SS The SQL Applications Developers role is to perform duties to assist with the on-going development and maintenance of the P-20 Data Collaborative s data warehouse. The individual will be responsible for creating stored procedures, working with ETL to move data into the system, creating some tables and limited data modeling tasks for bringing data from new sources into the system. The P-20 Data Collaborative s data warehouse will be composed of data that has been extracted from other state agency databases incrementally and will be merged together into a separate P-20 data warehouse to create a longitudinal database for analyses. The individual must be experienced working in the Microsoft SQL Server platform. This individual must be flexible to perform varying related tasks as the project develops and be able to operate as part of a team. Necessary Skills: · Three to five years of SQL development in MS SQL Server 2005/2008. · Experience with table creation and design. · Experience with integration testing in the SQL environment · Three to five years of experience writing and debugging Stored Procedures and triggers. · Experience using Advanced T-SQL. · The ability to create or further flesh out data models based on the available data feeds or to enhance an existing model with new data sources. · Experience transforming data from one server to other servers using tools like Integration Services (SSIS) Analysis Services (SSAS) and Reporting Services (SSRS). · Excellent communication and collaboration skills required. · Experience with MS Reporting Services and/or Business Office preferred. · Ability to analyze requirements and produce relevant reporting. · Ability to write and modify complex SQL queries. · Drive relentlessly to remove risks and ensure solutions are fit for purpose. · Self-starter. · Ensure that we have the right balance between business speed and the associated risks. · Understanding of Data Warehousing. Education · Computer Science degree or equivalent experience (specifically around Microsoft SQL products). Technical Competence · Microsoft SQL Server 2005/8 · SSIS 2005/8 · T-SQL · .Net · Crystal Reports Experience with the following is desirable: · SAP BusinessObjects Roles & Responsibilities: · Work closely with the Project Manager, Lead Systems analyst and the Technical Development Lead to understand the requirements. · Develop stored procedures to create “edit reports” and basic profile testing of data files as they are imported into the system. · Create and populate tables within the data system with data from external sources. · Document procedure development and assist others with the collection of Meta data for use in data dictionaries and other documentation for data system users. · Create reports using SAP Business Objects Web Intelligence and Crystal Reports · Functionality Testing and bug fixes /issue resolution during the various quality assurance testing cycles · Other duties as needed   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 12800 while calling.   Other jobs in KY: Cynthiana (1), Louisville (4), Remote (2), Unknown (17),    Sql Developer job openings in other states Jobs List NC FAST- Senior Applications DBA (711027) Create date: 20-Jun-2023 Hybrid Start date :06/19/2023 End Date :06/14/2024 Submission deadline :06/26/2023 Client Info :NCDHHS-NCFAST Description : ------------------------------------------------------ The Department of Health and Human Services (DHHS) requires a Senior Applications DBA to support migration.... (This job is for - job Jobs in NC Raleigh DBA - (in Raleigh, NC)) GA DHS - SQL Business Analyst (710741) Create date: 17-May-2023 Remote Start date :06/05/2023 End Date :06/28/2024 Submission deadline :05/16/2023 Client Info :DHS Description : ------------------------------------------------------ The Business Analyst will work within the Office of Information Technology and will be responsible for interfacing w.... (This job is for - T SQL Jobs in GA Atlanta Analyst - (in Atlanta, GA)) Database Architect V -116593 Create date: 27-Apr-2023 Start date : 07/03/2023 End Date : 06/30/2024 Submission deadline :May 8 at 4:00PM 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 .... (This job is for - SQL Jobs in WI Madison Architect - (in Madison, WI)) NJDHS-DFD Database Manager/Administrator 4 (704224) Create date: 23-Mar-2023 Hybrid Start date :04/10/2023 End Date :06/30/2023 Submission deadline :3/28/2023 Client Info :DHS - Division Of Family Development Description : ------------------------------------------------------ Please note that this is a hybrid role that requires an in person interview. Positi.... (This job is for - job Jobs in NJ Trenton Administrator - (in Trenton, NJ)) Application Developer III - FR99560 Create date: 01-Feb-2023 start date:2/13/2023 End date:06/30/2023 submission deadline:02/06/2023 client info : OIT Note: * Position Location: Remote. * Candidate Must Be Local Description: Full-time professional work experience in the development and support of Information Technology a.... (This job is for - job Jobs in CO Denver Developer - (in Denver, CO))     (Developer: Sql Developer, MS SQL 2008, Integration Test Experience, Stored Procedures Triggers T SQL SSIS SS in Frankfort, KY)

Featured Jobs Data Manager (Jobs in Columbus, Ohio) Business Analyst (Jobs in Columbus, Ohio) Cross Manager (Jobs in Des Moines, Iowa) TOMCAT Consultant (Jobs in Columbia, South Carolina) - Consultant (Jobs in Knoxville, Tennessee) .Net Engineer (Jobs in Columbus, Ohio) ASP.Net NIST Architect (Jobs in Richmond, Virginia) - TechLead (Jobs in Chattanoogatn, Tennessee) - Consultant (Jobs in Trenton, New Jersey) Visio Manager (Jobs in Columbus, Ohio)