Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
MPLS SSIS Excel ETL Developer
(Jobs in Minneapolis, MN)
 
Requirement id 88016
Job title Developer
Job location in Minneapolis, MN
Skills required Sql Developer, MPLS, SSIS, Excel ETL
Open Date 31-Jan-2019
Close Date
Job type Contract to Hire
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type Face to Face interview
   Email Recruiter: coolsoft
Job Description Developer: Sql Developer, MPLS, SSIS, Excel ETL

Candidate must be your W2 Employee.

Job Description :

Client: Wells Fargo

Role: SQL Developer

Location: MPLS – can work remote after proven themselves but need to be available to come onsite when needed


Notes from Conversation with Manager:

15M rows in excel – this is not possible so cutting it up into pieces
They are connected to MS Dynamics (payroll, HR, ent. internal data) and Salesforce (customer data). -- using SSIS to pull this data (EXTRACT), create copies, person will finish creating SSIS packages and then they test (“mock run of entire migration from start to finish”) 3-4x until they get it right and then they put the packages into production (this part is done by Andy and some of the systems resources). They have a template for the SSIS, no data modeling necessary. The person in this role is not responsible for reporting. They have another team for that. They need to understand data mapping (source to target).
Required:
Must have strong communication skills and be able to take direction
Advanced SQL skills + Stored procedures – 3-5 years of experience
SSIS experience – simple packages, nothing complex. They are given the design pattern
Source code control is used - foundational data
Data Mapping Skills
ETL
Testing experience will be needed – must be able to prove w/o doubt a job has been completed
Environment:
They use SQL Servers 2012 and 2017
Visual Studio 2015 and 2017
Daily scrums
BI experience is usually better than DBA for ETL purposes
Source code control is used - foundational data
No SSAS or SSRS Needed
Nice to have skills:
Migration experience, extracting data OUT of MS Dynamics and/or Salesforce and putting it into a centralized location (they are migrating to Salesforce Lightning)
Interview Process: 1 in-person interview to hire. He will consider Skype but he prefers onsite. He wants to see our top 2 candidates

Formal Job Description:

We are looking for mid-senior level SQL Database Developer who have in-depth experience with Microsoft SQL Server, specifically 2012-2017 to help with a Migration project.

The successful candidate will be an experienced Developer with enterprise background using MS SQL Server. The SQL Database Developer will be required to write advanced SQL queries, design and code complex stored procedures, and test data to ensure accuracy.

Project Details:

GIB Migration (Global Investment Banking)
Starting April 2019
They are extracting data from MS Dynamics and 2 Salesforce databases and moving them to a single instance of SF
This is under the Wholesale Umbrella encompassing Commercial (dealer finance, Regional Community Bank Officer, Securities, and GIB).



Responsibilities:

Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
Performance tuning the stored procedures and T-SQL.
Assist developers with complex query tuning and schema refinement.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
Tuning T-SQL queries to improve performance



Requirements:

3-7 yearsof experience in software development, using Microsoft SQL Server 2008 R2, T-SQL, and T-SQL language (queries, views, procedures), SQL Server Database Design, Stored Procedure Design and implementation. Must know SQL inside and out.
Experience coding complex stored procedure
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 88016 while calling.
 
Other jobs in MN: Coon Rapids (2), Duluth (6), Eagan (1), Edina (3), Little Falls (1), Maplewood (4), Mineapolis (1), Minneapolis (69), Minnesota (1), North Saint Paul (1), Plymouth (1), Roseville (2), Saint Cloud (3), Saint Paul (41), St Cloud (1), St Paul (5), Unknown (1),
Sql Developer job openings in Minneapolis, MN
Jobs List

SQL Developer X5 - 32928
Create date: 21-Mar-2018
Client Info : Wells Fargo Wholesale 2

Candidate must be our W2 Employee

Job Description :

The SQL Developer candidate is responsible for design and implementation of the data management environment.
Engages in data modeling, database architecture, data migration, metadata and repository creation, and enablemen.... (This job is for - job Jobs in MN Minneapolis Developer - (in Minneapolis, MN))

SQL Developer - J-10-689-121
Create date: 26-Jul-2012
[Note: Start Date : 07-30-2012
End Date : 12-31-2012]

Description:

SQL Developer
Minneapolis, MN
6 month +

MUST BE LOCAL TO MINNEAPOLIS

- Proven expert knowledge compiling and investigating SQL statements and procedures and writing stored procedures.

- Ability to apply me.... (This job is for - job Jobs in MN MINNEAPOLIS Developer - (in Minneapolis, MN))
 
 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))
 
 Sql Developer job openings in MN
Jobs List

SQL Developer - 50874
Create date: 06-Aug-2019
Notes :
subvending ok here

Description:
SQL Developer | Eagan, MN

Analyze & Remediate Production Data Quality Issues
Support Master Data Management & Data Integrations
Support Project Delivery Objectives


Background & Skillset

Database Knowledge - Strong SQL/Query .... (This job is for - SDLC Jobs in MN Eagan Developer - (in Eagan, MN))

RFO0237 COMS Modernization Database Administration -SP
Create date: 26-May-2017
Submission Deadline : 06/06/2017, 2:00PM

Client : Department of Corrections (DOC)

RFO Evaluation Process :
Mandatory Qualifications = 40%
Desired Skills = 30%
Cost = 30%

Description :

The Correctional Operations Management System (COMS) system includes over 70 modules which collect and .... (This job is for - job Jobs in MN StPaul Administrator - (in St Paul, MN))
(Developer: Sql Developer, MPLS, SSIS, Excel ETL in Minneapolis, MN)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us