the smart solution for Minneapolis jobs

SQL Developer

Company: Apex Systems
Location: Minneapolis
Posted on: February 15, 2019

Job Description:

Client: Wells FargoRole: SQL DeveloperLocation: MPLS ? can work remote after proven themselves but need to be available to come onsite when neededDuration: 24 monthsBill rate:?$80.50 - no FlexVMS Job ID: Andy is sending this.Manager:?Andy LoechlerCompetition: SignatureStart Date: March 4thNotes 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 candidatesFormal 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 performanceRequirements:
              • 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 procedures (using T-SQL).
              • Experience with developing SSIS packages
              • Proven analytical problem solving and debugging skills
              • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc
              • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
              • Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments
              • Monitoring performance and managing parameters to provide fast query responses to front-end users
              • Familiarity with BI technologies
              • Excellent English communications skills (written and verbal).

                Keywords: Apex Systems, Minneapolis , SQL Developer, IT / Software / Systems , Minneapolis, Minnesota

                Click here to apply!

                Didn't find what you're looking for? Search again!

                I'm looking for
                in category

Other IT / Software / Systems Jobs

ETL Tester
Description: Plans, designs, executes testing for Data Warehouse projects to certify that they meet business and technical requirements with minimum supervision in Agile environment: Responsibilities: ul li Analyze (more...)
Company: InnoCore Solutions, Inc.
Location: Minneapolis
Posted on: 02/20/2019

Senior IOS Developer
Description: We are in Critical need of Senior IOS Developer for Full-time Hire in Minneapolis, MN .Role : Senior IOS DeveloperLocation
Company: IDC Technologies
Location: Minneapolis
Posted on: 02/20/2019

Senior Java Developer
Description: Looking for more than just another assignment We're looking for you This isn't just another assignment, but a real opportunity and a challenge for the right person. LRS Consulting Services is seeking (more...)
Company: Levi, Ray & Shoup, Inc.
Location: Saint Paul
Posted on: 02/20/2019

Linux Systems Engineer Contract Minneapolis, MN
Description: Linux Systems EngineerThis role will be responsible for engineering and automation across multiple Linux platforms including Red Hat Enterprise Linux and Amazon Linux. This role will work closely with (more...)
Company: iTech Solutions
Location: Minneapolis
Posted on: 02/20/2019

Java Kotlin Developer
Description: Looking for a solid mid-level developer who is interested in joining a start-up environment, and who wants to get in on the ground floor of a cool software product. Would like to see the following
Company: True Source IT, LLC
Location: Minneapolis
Posted on: 02/20/2019

Technical Quality Assurance Field Technician I
Description: JOB SUMMARY br Under limited supervision, verify that the premise wiring services meet all company installation service specifications for residential SMB customers. Perform basic to complex installation, (more...)
Company: Spectrum
Location: Waite Park
Posted on: 02/20/2019

Junior Software Engineer - Burnsville
Description: br Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. br Our Software Engineers design, analyze (more...)
Company: Revature
Location: Burnsville
Posted on: 02/20/2019

Sales Consultant, Technology
Description: TriNet is a leading provider of comprehensive human resources solutions for small to midsize businesses SMBs . We enhance business productivity by enabling our clients to outsource their HR function (more...)
Company: TriNet Group
Location: Minneapolis
Posted on: 02/20/2019

Lead RPA Developer (UIPath)
Description: Title: RPA UI Path Developer Senior/Lead level Location: Minneapolis, MNDuration: 6 Months Skype Interviews
Company: Group Nine
Location: Minneapolis
Posted on: 02/20/2019

SAP QA Analyst and Software Engineer II
Description: SAP QA Analyst and Software Engineer II sought by Patterson
Location: Saint Paul
Posted on: 02/20/2019

Log In or Create An Account

Get the latest Minnesota jobs by following @recnetMN on Twitter!

Minneapolis RSS job feeds