Analysis Skills, Business Intelligence, Data Warehousing, Database Triggers, Detail Oriented, Documentation, Identify Issues, Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Query Analysis, SQL Server Integration Services (SSIS), Stored Procedures, Team Player, United States Department of Energy (DOE)
Job Title: SSIS Developer
Location: Cincinnati OH
Duration: Contract
Rate: DOE
Primary responsibilities:
Experience writing packages, stored procedures, triggers, ad-hoc queries, and process documentation.
Troubleshoot and optimize the performance of packages and stored procedures.
Must be detail-oriented to succeed in this role.
Required Skills:
Must have extensive experience with SQL Server Integration Services.
Strong Design Skills
Expertise in Data Mappings
Excellent knowledge of databases, data warehouse/modeling concepts, and understanding of business intelligence.
Strong knowledge of creating SSIS packages using transformation.
Must have extensive experience with Stored Procedures, Triggers, Views, and Functions.
Experience building complex reports using Query/Report.
Query performance analysis and tuning.
Excellent problem-solving and critical-thinking skills.
Excellent analytical skills, documentation, and ability to work in teams.