(Enter skills, job title, etc.)

Data Warehouse, ETL Dev

Job Title:

Data Warehouse, ETL Dev


New York, NY


Information Technology


12 month +

Job Description:

This position is for a hands-on lead Developer in the Data Warehouse team of the North America based Firm Risk Management (FRM)Technology team.The successful candidate will have an opportunity to work closely with the FRM business unit, IT business analysts, GUI development teams and Data providers and consumers to deliver FRM Data Warehouse systems related projects.The candidate must have minimum 10 years hands-on IT experience, preferably in the financial services industry working on all aspects of SDLC with focus on ETL, Transactional Data Processing (OLTP) and Data Warehouse. Must have strong ability to work on multiple IT projects simultaneously, working with the stake holders, clients and other system owners to drive the projects to successful completion. Must have previous involvement in data modeling and/or systems architecture. Responsibilities will include technical analysis, design, development and perform enhancements.

The candidate will participate in all of the following activities:
-Hands-on development experience working with large volume db.
Strong knowledge of table partitions, high performance loading and data processing.
Practical experience to decide between DB vs. ETL processing OR both.
Working with business analysts and other project leads to understand requirements.
Modeling and implementing database schemas.
Designing, developing, maintaining and supporting Data Warehouse Extract, Transform and Load (ETL) software using Informatica, Shell Scripts, DB2 UDB and Autosys.
Coming up with system architecture/re-design proposals for greater efficiency and ease of maintenance and developing software to turn proposals into implementations.
Hands on development using big data / Greenplum platform

Job Requirements:

Skills Required :
Ability to deliver multiple simultaneous projects under pressure of regulatory driven deadlines
10+ years of relational database experience with emphasis on Data Warehouse (DB2 UDB / Oracle / Sybase / SQL Server)
7+ years ETL experience (Informatica / Ab Initio)
Strong knowledge of any one programming language
Hands-on experience with Greenplum / DB2 / Teradata / Oracle
Excellent analytical ability ?Strong collaboration and communication skills

Skills Desired :
Market Risk, Credit Risk, Operational Risk and Liquidity Risk knowledge
Job scheduler knowledge

Tip of the Week

Make sure your LinkedIn profile is identical or similar to your resume. Consistency is key!


View Starpoint's Top Tips.

Send Us Your Resume

Let Starpoint's expert recruiters help you land your next job.


Submit Your Resume