datawarehouse Azure Environment SQL Queries MS SQL Server Unit Testing SQL Perform   Requirement id 117271 Job title Developer Job location in Lincoln, NE Skills required Software Development Experience, SQL Experience, Server Integration Service Scripting, datawarehouse Azure Environment SQL Quer Open Date 10-Jun-2021 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Software Development Experience, SQL Experience, Server Integration Service Scripting, datawarehouse Azure Environment SQL Quer start date:6/1/2021 End date:05/31/2022 submission deadline:06/18/2021 client info : NeEDU Note: * Candidate must be local or willing to commute or relocate Description: Bachelors degree in computer science or a related field or related experience. Minimum of four years of experience related to the essential functions of the position. Any equivalent education and\or work experience may be substituted in order to meet the minimum qualifications of the position. PREFERRED QUALIFICATIONS: Experience with ETL framework and concepts, Data warehousing concepts, IBM DataStage (mandatory),Azure Data factory, Synapse analytics, SSRS, database programming, complex SQL Server PL/SQL, Stored Procedures, Python scripting, SQL performance tuning, data modeling, ETL job scheduling, Windows batch scripting, execution of data warehousing projects. Experience with Azure devops/Microsoft team foundation server is required. Experience in Microsoft Azure cloud data services is mandatory. Knowledge and Abilities: KNOWLEDGE: · The entire software development lifecycle. · Writes advanced SQL including some query tuning. · Experience in the identification of data quality. · Experience designing and building complete ETL using IBM Datastage processes moving and transforming data for ODS, Staging, and Data Warehousing. · Utilize ad-hoc techniques to perform on-the-fly analysis of data. · Proficient in debugging data related production issues and deploying fixed code in production environment. · Design, build and deploy effective IBM Datastage jobs. · Implement stored procedures and effectively query a database. · Identify and test for bugs and bottlenecks in the ETL solution. · Ensure the best possible performance and quality in the ETL packages. · Provide support and fix issues in the IBM Datastage ETL jobs. · Author and execute unit test scripts. · Established policies, procedures, practices of the Nebraska Department of Education. · Familiar with Azure Devops methodologies and have implemented at least one project using Azure Devops/or Microsoft TFS. · Working experience in cloud migration of data and implement services for data related processes using Microsoft Azure. ABILITIES: · Optimize database systems for performance efficiency. · Have regular interaction with business team to understand the functional requirements and translate them into technical specification document and subsequently perform the coding of database and ETL artifacts. · Create ETL packages/jobs as per the technical requirements within strict timelines. · Troubleshoot datastage jobs and fixes the code issues as needed. · Analyze the required ETL packages for performance tuning and come up with solutions to improve the runtime. · Prepare design specifications and functional documentation for assigned database projects. · Analyze legacy and current systems and create technical documentation and source to target mapping document. · Perform space management and capacity planning for database systems. · Develop database tables and dictionaries. · Troubleshoot database related issues in a timely fashion. · Ensure data quality and integrity in databases. · Identify any issues related to database performance and provide corrective measures. · Create complex functions, scripts, stored procedures and triggers to support application development. . Eagerness to learn new tool/technologies quickly and start working immediately.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 117271 while calling.   Other jobs in NE: Lincoln (21), Software Development Experience job openings in Lincoln, NE Jobs List IT Applications Developer SeniorC And .NET .NET Core - 57376 Create date: 01-Jul-2022 start date:7/11/2022 End date:07/11/2023 submission deadline:07/07/2022 client info : NeEDU Note: * Position Location: Remote Description: NDE/IT Applications Developer Senior - C#, and .NET/.NET Core Project: INSTRUCTION.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) IT Applications Developer Senior - 57099 Create date: 06-May-2022 start date:6/1/2022 End date:09/30/2023 submission deadline:05/16/2022 client info : NeEDU Description: NDE/IT Applications Developer Senior - C#, Angular/.NET Core/NECPRS Phase II Brief Summary: This position will be tasked with Co.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) IT Applications Developer Senior - PHP - 56878 Create date: 14-Feb-2022 start date:3/1/2022 End date:02/28/2023 submission deadline:02/24/2022 client info : NeEDU Description: To coordinate planning, creation, implementation, and maintenance of (NDE) owned websites and intranet content management system in compliance.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) Project Manager - 56829 Create date: 26-Jan-2022 start date:3/1/2022 End date:03/01/2023 submission deadline:02/18/2022 client info : NeTRANS (formerly ROADS) Description: Under general direction, this position would be responsible for planning, directing and coordinating project management activ.... (This job is for - job Jobs in NE Lincoln Manager - (in Lincoln, NE)) IT Applications Developer Senior .Net - 56783 Create date: 29-Dec-2021 start date:1/10/2022 End date:12/31/2023 submission deadline:01/07/2022 client info : NeEDU Description: The goal of this project is to execute the end-to-end implementation of the perceptual survey initiative, including the generation of unique survey l.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE))    Software Development Experience job openings in other states Jobs List NCDOT - Developer/Programmer- Senior (721479) Create date: 03-Oct-2023 Remote start date :11/06/2023 End date :12/05/2024 submission deadline :10/09/2023 client info :NCDOT Description : ***The candidate will be allowed to work remotely until all staff return to site. At that point the candidate will be r.... (This job is for - Powerbuilder Jobs in NC Charlotte Developer - (in Charlotte, NC)) Systems Software Programmer - Advanced - 10872-1 Create date: 16-Jun-2023 Start date :17 JULY 2023 End Date :--12+MONTHS Submission deadline :6/23/2023 Client Info : Department of Revenue Note: * INTERVIEW PROCESS (phone, video, or in-person, how many rounds of i/vs, etc.)? * 1, 2, possibly 3 interviews via phone and/or video. Local candidates can be.... (This job is for - Analytics Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) GA DOR - Java Developer (Full Stack) (709075) Create date: 17-Apr-2023 Start date :05/15/2023 End Date :06/30/2024 Submission deadline :04/26/2023 Client Info :DOR - IT Note: * Hybrid Description : *Candidate MUST be local to Metro Atlanta* *Tax Clearance Letter, due at the time of submission* (pls review compliance tab for instruction on how .... (This job is for - JavaScript Jobs in GA Atlanta Developer - (in Atlanta, GA)) Programmer/Analyst III (Senior) - 20230120111253 Create date: 20-Jan-2023 start date:2/13/2023 End date:6+months from start date submission deadline:1/27/2023 Note: * Job Site: Remote Description: JOB DESCRIPTION Senior Java developer to work in our Mobile Application team focused on building servicing layer for the Huntington Mobile app. job Jobs in OH Columbus Analyst - (in Columbus, OH)) Programmer/Analyst III (Senior) - 20221121052839 Create date: 22-Nov-2022 start date:12/12/2022 End date:7+months from start date submission deadline:11/28/2022 client info : Huntington Bank Description: In this role, the successful candidate will design, develop, integrate, and support applications for multiple business seg.... (This job is for - NET FRAMEWORK Jobs in OH Columbus Analyst - (in Columbus, OH))     (Developer: Software Development Experience, SQL Experience, Server Integration Service Scripting, datawarehouse Azure Environment SQL Quer in Lincoln, NE)

Featured Jobs ASP.Net Government Developer (Jobs in Madison, Wisconsin) Manual Consultant (Jobs in Columbus, Ohio) IT Specialist (Jobs in Columbus, Ohio) Batch CMDB Management System Administrator (Jobs in Glen Allen, Virginia) - Architect (Jobs in Richmond, Virginia) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) - Consultant (Jobs in Bismarck, North Dakota)