Senior SSIS Developer

Overview

On Site
Depends on Experience
Contract - W2
Contract - Independent

Skills

Business Process
Data Analysis
Database
Debugging
Extract
Transform
Load
Leadership
Management
Microsoft SQL Server
Microsoft SSIS
Offshoring
Performance Tuning
Regulatory Compliance
Reporting
SQL
Stored Procedures
Virtual Team
SSIS
ETL

Job Details

Role: Senior SSIS Developer

Location : Parsippany, NJ (Onsite)

Client : NTT DATA/UPS

Must Have: SQL Server 2019, 2022 and Microsoft SSIS development

Job Description:

SITION 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.

Minimum Requirements:
 8+ experience with SQL Server 2019, 2022

8+ 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

Day to Day Responsibilities:
Design and develop SQL server stored procedures, functions, views and triggersDesigning 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 packagesKnowledge 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.

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.