Job Title: ETL Developer
Location: New York, NY
Job Type: Contract
Duration: 12+ Months
Spruce Technology is a mid-size and rapidly-growing Information Technology services firm headquartered in New Jersey. An award-winning firm (Inc 5000, SmartCEO) with a steadily growing portfolio of commercial and government clients, Spruce Technology provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide.
Provide technical support for the administration and production of Informatica. Responsible for data loading and manipulation to ensure data sources are efficiently and effectively loaded into the data warehouse.
Work with Cognos to generate reports. Will need to enhance existing artifacts & troubleshoot..
Work closely with application services and operations team on ETL development efforts including analysis and design of integration solutions, data and reporting needs of internal and external stakeholders, and enhancement related to applications and services.
Develop interface with external systems that exchange data with database.
Access legacy ETL procedures for logical / technical issues and work with Data Architect and Business system Lead to resolve issues.
Work with Business and Data Team members to help upgrade current infrastructure and systems.
Assist in the development of reporting interfaces by ensuring ETL procedures integrate properly with necessary dependent systems.
Tracking, analyzing and resolving trouble tickets.
High-level Business Requirements
Detailed Use Cases and Business & Technical Requirements for assigned areas
Business Process Flows and business Rules
Functional Design Document / Functional specifications
ETL Test Plan
ETL Performance Test Plan
Error Messages inventory
Assist with QA Plan & Acceptance Criteria
If interested, please forward a current copy of your resume with contact information to or you can call me on my desk no
ETL, Informatica, Cognos
Spruce Technology Inc.