Senior SSIS Developer || Locals 1st prefer

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

Database
Extract
Transform
Load
SQL
Microsoft SSIS
Stored Procedures
Reporting
Offshoring
Microsoft SQL Server
Management
Business Process
Data Analysis

Job Details

Role: Senior SSIS Developer

Location: Parsippany, NJ(Onsite)

Description:

POSITION GENERAL DUTIES AND TASKS :
SSIS Developer will need at least 5-7 years of experience in Microsoft SSIS integration Suite and possess an excellent understanding of report development concepts and SQL.
Day to Day Responsibilities:
Design and develop SQL server stored procedures, functions, views and triggers Designing and developing SSIS/ SQL ERTL solutions to acquire and prepare data from numerous upstream systems
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
Experience working with SSIS packages Knowledge of database structures, performance tuning, data analysis
Partner with leadership and internal stakeholders to understand business and end-user needs, gain subject matter expertise and assess key opportunities, then design and implement high quality data and reporting solutions.
Develops statements of problems and requirements, analyzes, designs systems and programs, and writes programs in computer language and tools as appropriate
Designs, codes, tests, debugs and documents reporting code according to established standards, policies, procedures, security and compliance requirements.
Understands and foresees implications of decisions. Understands the core business process and purpose of the functional area.
Works with minimal direction in virtual teams. Writes efficient, re-usable, optimal, and well documented code. Updates management on project/activity status as requested and escalates issues quickly.
Interacts with business users, IT, vendors and customers to define current and future application requirements. Simplifies difficult concepts for non-technical users.
Extends capabilities by working with senior staff/experts within and outside the internal organization.

Minimum Requirements:
8+ experience with SQL Server 2019, 20228+ years of Microsoft SSIS development
8+ years of experience with proficiency in SQL
Experience with SQL Server 2019, 2022 and SSIS
Experience with development of SQL/SSIS packages and stored procedures.
An ability to work with complex SQL queries, debugging of issues.
Knowledge of database structures, performance tuning, data analysis
5-8 years experience with SQL Server, SSIS
Good communicator
Ability to work in a team environment
Experience working in an onshore-offshore environment.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.