DataStage Developer

Description

Project Details CECL Project requires FCB to change accounting standards for risk analysis for the banks portfolio and accounts. This is requiring the risk analytics team to create new forecasting models. The new models requires continuous updates to the Data Warehouse. The developer will build out the production environment based on business requirements using DataStage. Will then work with the business to help analyze the data
MustHave Skills (Stack rank in order of priority. Most critical skill listed first & what they need to be capable of doing with each technology) 5+ years of DataStage Development
ETL experience SQL experience Data Analysis experience Unix/Linux understanding
NiceToHave Skills Shell scripting
DB2 with Netezza
Education & Certifications no requirements
Daily Responsibilities The developer will build out the production environment based on business requirements using DataStage. Will then work with the business to help analyze the data
Additional Details The DataStage Programmer Analyst will be a member of First Citizens Banks (FCB) Data Warehouse team. This role will support enterprise data warehouse projects at the bank supporting Enterprise Risk, CECL, Basel and Financial Reporting.
Work in a data warehouse environment which includes data design, database architecture, metadata and repository creation.
Work with end users to document data requirements, perform complex source to target data mapping and develop/maintain ETL programs to support FCBs enterprise data warehouse.
Analyze data loaded into the data warehouse for accuracy.
Develop, maintain, and support the enterprise data warehouse system and corresponding data marts using IBM DataStage.
Troubleshoot and tune existing data warehouse applications. Incorporate existing subject areas into an enterprise model.
Create new or enhanced components of the data warehouse.
Experience with enterprise scheduling tools (ex. ControlM, AutoSys) to automate DataStage program execution, file transfers, etc.
Experience using a source code control tool (ex. Git, TFS) to manage DataStage programs.