Previous Job
SSRS/SSIS Developer
Ref No.: 18-03684
Location: Brooklyn, New York
Position Type:Contract
Top Tier Investment Bank is seeking an experienced Software Engineer, your mission is to help lead our team of innovators and technologists toward creating next-level solutions that improve the way our business is run. Your deep knowledge of design, analytics, development, coding, testing and application programming will help your team raise their game, meeting your standards, as well as satisfying both business and functional requirements. Your expertise in various technology domains will be counted on to set strategic direction and solve complex and mission critical problems, internally and externally. Your quest to embracing leading-edge technologies and methodologies inspires your team to follow suit. And best of all, you'll be able to harness massive amounts of brainpower through our global network of technologists from around the world.

This role requires a wide variety of strengths and capabilities, including:
• Expertise in application, data and infrastructure architecture disciplines

• Advanced knowledge of architecture, design and business processes
• Keen understanding of financial control and budget management
• Ability to work collaboratively in teams and develop meaningful relationships to achieve common goals

• Strong T-SQL development: Stored Procedures/views/Triggers/Functions
• SSIS (2012) : Visual Studio Data Tools, Data Flow tasks, Package configuration , ETL heterogeneous data sources setup, Deployment models, SSIS Data Catalog management, Environment setup
• SQL Server Agent (Jobs handling)

• SQL Server DBA (junior-level) functions: Backups/Restore/User Account management
• C#/.NET ( we use C# scripts inside SSIS script task)
• VBA (MS ACCESS) Project management/data flow/macros/events/error handling ( our front-end is written in VBA)
• MS Excel
• SQL Server tools: Profiler / Performance Monitor/ Execution Plan
• SQL Server Performance Tuning & Query optimization
• PL SQL (Oracle)
• VBA (MS ACCESS) Project management/data flow/macros/error handling
• Share Point