T-SQL SQL Server 2005 ETL Data Warehouse Kimball SDLC Problem Solving Skills Develop   Requirement id 46502 Job title Developer Job location in Charlotte, NC Skills required T-SQL, Data Integration, SQL Server 2005, ETL Data Warehouse Kimball SDLC Problem Open Date 11-Jun-2015 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: T-SQL, Data Integration, SQL Server 2005, ETL Data Warehouse Kimball SDLC Problem NOTE : START DATE : 06/23/2015 SUBMISSION DEADLINE : 06/17/2015 CLIENT INFO : TEK SYSTEMS DESCRIPTION : Responsibilities: The SQL Developer will work as part of a data integration (ETL) development team in the Financial Systems & Technology (FS&T) group to support the Financial Accounting Control System (FACS) platform. The successful candidate must be a client-focused senior developer able to assist with the development and delivery a technology solution that meets the needs of the end users while maintaining compliance with Wells Fargo change management processes and procedures. This role involves frequent interaction with end user business analysts so excellent communication skills and a pleasant personality is required. FACS is a data warehouse with complex transformation logic. After extracts are loaded into the database via Informatica, all transformations and loads are performed via SQL and Stored Procedures. Informatica is used only to load the raw data and coordinate the batch. This role is to use T-SQL to develop the transformation logic, which is where all the business logic and complexity of the system resides. While a little Informatica would be nice to have to monitor and kick of jobs, this role will not involve Informatica development. With the merger of Wells Fargo and Wachovia, there are many new systems to be integrated into FACS. This role is to support those new integrations. This will be primarily a development role. Support responsibilities are expected to be less than 10%. Required Skills: Extremely strong T-SQL skills. Ability to write queries that execute quickly and efficiently even when dealing with millions of rows. This is the single most important skill. Experience with SSIS is not a replacement for this skill. 5+ years data integration development experience. 3+ years of ETL / Data Warehouse experience. Knowledge of Kimball methodologies; star schema with Fact tables and Type-2 Dimensions. SQL Server 2005 and/or SQL Server 2008 experience, including experience with large-scale relational databases (> terabyte) Experience in data warehouse system ETL processes using Stored Procedures and SQL. Understanding of database maintenance processes (pertaining to Statistics, Indexes, Performance Analysis) Strong communication and problem solving skills, a positive attitude and the ability to work with business users required. The ability to work in a multi-tasking team environment. The users often change their minds or have many small enhancement requests interspersed with projects. Candidate needs to be able to switch tasks as needed and juggle multiple assignments while still meeting deadlines. Some people do not like this. This role will not be working on one single thing for weeks/months at a time. There will be constant interruptions. Make sure candidates are OK with this. Ability to analyze and document system recommendations and changes SDLC knowledgeable Ability and desire to interact with business counterparts. Nice to Have Skills: Accounting and/or financial industry experience is desirable. Excel, MS Access. MS Certifications Autosys UNIX Some light Informatica experience. No full Informatica developers as they will not be happy in this role.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 46502 while calling.   Other jobs in NC: Chapel Hill (2), Charlotte (58), Dix Campus (1), Greensboro (3), Morrisville (2), North Charlotte (2), Raleigh (96), St Raleigh (2), Winston Salem (3), T-SQL job openings in Charlotte, NC Jobs List SQL Developer - 62397 Create date: 17-Apr-2020 Candidate must be our W2 Employee. Job Description : · 10+ years of experience with Microsoft SQL Server and T-SQL · 8+ years of SQL design and development experience with Microsoft SQL Server, versions 2008 through 2016 required, SQL Server 2017 experience a plus · 6+ years of experience with Microsof.... (This job is for - T SQL SSIS Jobs in NC Charlotte Developer - (in Charlotte, NC)) Oracle Developer - 41721 Create date: 03-Jan-2019 Candidate must be our own W2 Employee Job Description : Requirements: 5+ years Oracle Database Development T-SQL Stored Procedures .NET/UI Front End Looking for a senior level Oracle Database Developer with experience performance tuning database routines within .... (This job is for - T SQL UI Jobs in NC Charlotte Developer - (in Charlotte, NC)) SQL Dev - 38923 Create date: 27-Sep-2018 Candidate must be our own W2 Employee Job Description : Position: SQL Developer DESCRIPTION: SQL Development for CRM application processing, would be working with basics of pivot function, dynamic pivot creation, hierarchy, recursive CTE. Indexing, best practice design are always important. Looking.... (This job is for - T SQL SSIS Jobs in NC Charlotte Developer - (in Charlotte, NC)) SQL Developer - 33372 Create date: 04-Apr-2018 Candidate must be our own W2 Employee We should take signed RTR form from candidate (Candidates RTR form should be only on the name of APEX Systems)" We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens) Client : Wells Fargo - Charlotte Highly proficient in SQ.... (This job is for - T SQL Jobs in NC Charlotte Developer - (in Charlotte, NC)) SQL/Hadoop Developer - 33207 Create date: 29-Mar-2018 Client Info : Wells Fargo Candidate must be our W2 Employee Candidates RTR form should be only on the name of APEX Systems Job Description : Seeking a SQL/Hadoop Developer to help with a large project Primary job will be SQL related – rewriting reports in SQL for the contact centers web r.... (This job is for - T SQL SSRS ETL Jobs in NC Charlotte Developer - (in Charlotte, NC))    T-SQL job openings in other states Jobs List Programmer Analyst 5 -134955 Create date: 13-Sep-2024 Bid Limit Per Vendor : 1 Start date : 10/14/2024 End Date : 09/30/2025 Submission deadline : 9/20/2024 at 10am EST. Client Info : DOC Note : * Interview Process: Virtual Interview via MS Teams video. There is potential for a 2nd round interview which may be held in-person. T SQLDatabase Admin Jobs in MI Lansing Analyst - (in Lansing, MI)) VDH T-SQL Programmer Analyst (742187) Create date: 17-Jul-2024 No of Submissions :2 Start date :7/22/2024 End Date :06/30/2025 Submission deadline :7/22/2024 Client Info :VDH Note: * Hybrid * Agency Interview Type:Web Cam Interview Only Description : *local candidates strongly preferred *remote work is available now bu.... (This job is for - T SQL Jobs in VA Richmond Analyst - (in Richmond, VA)) Programmer Analyst 3 -132204 Create date: 01-Jul-2024 Bid Limit Per Vendor : 1 Start date : 07/29/2024 End Date : 1 Years from projected start date Submission deadline : 7/8/2024 @ 10am EST Client Info : DOC Note : * Interview Process: Interviews will be held via MS Teams. Please use laptop and be prepared to share screen if asked. .... (This job is for - T SQL Powerbuilder Jobs in MI Lansing Analyst - (in Lansing, MI)) RHAPSODY DEVELOPER-Consultant - 11216-1 Create date: 28-May-2024 No of submissions : 2 Start date : 6/17/2024 Submission deadline : 6/4/2024 Client info : Health & Environmental Control Department (DHEC) Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? - An interview panel will conduct one initial.... (This job is for - T SQL ETL Sql Server 2000 Jobs in SC COLUMBIA Developer - (in Columbia, SC)) Senior Application Developer - 125949 Create date: 08-Mar-2024 Start date : 03-11-2024 Submission deadline : 3/15/2024 Client info : The Commonwealth of Massachusetts Note : * hybrid in quincy ma Description : The Massachusetts Executive Office of Health and Human Services (EOHHS) is the largest sec.... (This job is for - T SQL PowerShell Jobs in MA Quincy Developer - (in Quincy, MA))    T-SQL job openings in NC Jobs List NCDHHS- Technical Architect (677876) Create date: 24-Mar-2022 Start Date :03/28/2022 End Date :03/27/2023 Submission Deadline: :03/29/2022 Client Info: NCDHHS-AM Note : * Agency Interview Type: Webcam Interview Only Description: The NC Department of Health and Human Services is seeking a Technical Architect/Sof.... (This job is for - T SQLCSS Jobs in NC Raleigh Architect - (in Raleigh, NC)) Data Engineer - 71933 Create date: 12-Feb-2021 Job Description: 12 Month+ rolling contract with a potential to go PERM. Top Requirements: • Azure Data Factory • Azure Data Bricks • SQL • Hive Priorities: • Python • T-SQL / U-SQL • Azure • Big Data Delhaize Charlotte, NC 6 month + contract Data Eng.... (This job is for - T SQL Java Python Jobs in NC Salisbury Engineer - (in Salisbury, NC)) Sr Software Engineer - 59653 Create date: 18-Feb-2020 Job Description : Senior Software Engineer Description: • Designs, analyzes, programs, debugs, and maintains system/web enhancements and/or new products. Designs, develops, implements and updates software systems in accordance with the needs of the organization. Evaluates, schedules, and resources development projec.... (This job is for - T SQL Jobs in NC Morrisville Engineer - (in Morrisville, NC)) (Developer: T-SQL, Data Integration, SQL Server 2005, ETL Data Warehouse Kimball SDLC Problem in Charlotte, NC)

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) 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)