SQL Server Developer - Omaha, United States - Ender-IT

Description

SQL Server Developer (SSIS/ETL Developer)

Onsite in Omaha, NE

Full time position

This person will have SQL development background and SSIS/ETL development experience. The ideal candidate has experience in SQL development, SSRS, SSIS, ETL, Power BI, and Azure Data Factory.

Core Responsibilities:

• Designs, builds and implements relational databases.
• Reviews T-SQL code and performances optimization.
• Works closely with other members of the business analyst, database administrator and software development, and database development teams, sharing knowledge and making recommendations as needed.
• Works with offshore development teams and reports.
• Completes documentation on all assigned systems and databases, including business rules, logic, and processes.

Functional Responsibilities

• Implement a viable system that can survive and adapt changes demonstrated through delivered projects.
• Ability to use critical thinking to solve issues that arise.
• Ability to troubleshoot database performance issues.
• Ability to deliver successfully tasks and projects independently and be a consultant for others.
• Ability to do performance tuning: query optimization (avoid coding loop and correlated subqueries), applying indexes and partition functions.
• Ability to write, debug and test stored procedures, functions, triggers.

Technical Skills:

• 3+ years' experience with Extraction, Transformation and Loading (ETL) process using DTS/SSIS application tools.
• 3+ years' experience with MS SQL Server 2008/2012/2017 including SQL Server Management, Integration Services, Analysis Services, and Reporting Services.
• Hands on experienced in data modeling in all phases (conceptual, logical, and physical).
• Hands on experienced in Transact-SQL (advanced queries, complex joins, indexes, pagination in SQL Server, TRY-CATCH blocks, CASE & PIVOT, etc.).
• Hands on experienced in MS SQL Server database design and coding techniques work with NoSQL datatype (JSON).
• Advanced knowledge of SSIS and Data Extraction and Transformations.
• Hands on experienced in performing database unit tests to ensure code quality using SSDT
• Things that will separate you from the rest
• Practical knowledge of API and Web development.
• Well grasp of how to connect different applications and systems together demonstrated through delivered projects.
• Hands on experience with Power BI.
• Knowledge of Azure Data Factory.

Education or Certifications

Bachelor's degree in Computer Science, Computer Information Systems or equivalent degree.

Eligibility Requirements:

• Must be willing to submit to a background investigation and drug test as part of the selection process.