DATA INTEGRATION DEVELOPER DEVELOPER

DATA INTEGRATION DEVELOPER DEVELOPER

WALL STREET OPTIONS
New York, New York | Posted: April 8, 2014

JOB DESCRIPTION

DATA INTEGRATION DEVELOPER DEVELOPER

FIRM: GROWING ALTERNATIVES INVESTMENTS FIRM

DATA INTEGRATION DEVELOPER will work with the Enterprise Data Architect and other developers, will own data integration projects designed to serve the needs of Investment and Risk teams.

DETAILED DESCRIPTION:
: 20% Data Architecture Planning
: 50% Design and Development
: 30% Testing/Implementation

Data Integration Developer will design and development of data integration capabilities for the Investment and Risk teams. Provide Investment and Risk teams data from our Accounting and Market Data systems and external data feeds. Data Integration Developer reports to the Enterprise Data Architect and work closely with members of the data integration development team and business intelligence team.

KNOWLEDGE & SKILLS REQUIRED:
o Experience with financial data warehouse systems, Master Data Repositories, Performance Analytic, and Risk Analytic systems







Additional Info

o Experience working on data warehouse systems
o Strong knowledge of ETL processes/design as well as data modeling, both relational and dimensional
o MS SQL Server development skills; experience writing T-SQL scripts, dynamic SQL, complex stored procedures and functions
o Experience in ETL design/development using SSIS
o Experience with .Net framework to create SSIS objects
o Understand Microsoft's business intelligence tools (i.e., SSRS and SSAS) l
o Data handling across different data sources - SQL Server, Oracle, MS Access, MS Excel
o Strong knowledge of SQL Server 2005/2008R2 Database Engine
o Experience using database design tool tools such as ERStudio
o Understanding of metadata and data quality concepts; working with a metadata repository

BACKGROUND:
Undergrad - Information Systems, Computer Science
Minimum - 2 years relevant technical Database/ETL Developer