SSUSA Job #540: Senior IBM InfoSphere DataStage (ETL) Developer

Job Description


Our global banking client is seeking a Senior IBM InfoSphere DataStage (ETL) Developer to work in the Applications Development - Internal Interface department.


The candidate for the Senior DataStage (ETL) developer position will be responsible for designing and developing batch/ETL interfaces using IBM's ETL tool Datastage as part of the bank's Interface Team.  The candidate will be responsible for maintenance and support of the existing interface DataStage processes including investigation of issues and production troubleshooting. This position will be a key member in of the Interface Team and will support bank's critical applications for Europe and North America. The incumbent wilw work with the interface development team to design, build, deploy and support new Datastage 8.x+ ETL interfaces based on the technical and functional requirements adhering to the banks best practices.  Create, update and publish interface documentation, system diagrams, presentations, workflows, project plans, risk logs and issue logs.  Promote code on all SDLC environments and validate that the interface code is working as expected.  Perform technical walkthroughs of DataStage programs for design and development peer reviews.








MUST have DataStage parallel and server experience, preferably v. 11.x  5+ years of combine experience in DataStage 11.3x/9.x/8.x Excellent understanding of data warehouse concepts and experience implementing data warehouse using DataStage ETL tool Good knowledge & experience on using IBM QualityStage Experience with developing both server and parallel jobs running on a UNIX platform against relational databases such as Oracle or SQL Server systems as source and target data environments Experience working in all phases of a full project life cycle, including low-level Design Strong knowledge of relational and dimensional database concepts Experience working with Information Analyzer, Metadata Workbench, Business Glossary ( Governance Catalog ) is a plus Knowledge of Unix shell scripting is a plus.






Required  Skills/Abilities:




DataStage 8.x/9.x/11.x
QualityStage 8.x/9.x/11.x
Experience implementing large data warehouse/ data mart using DataStage ETL tool
Good experience using data model as the main document to design and develop the DataStage load process for data wahehouse / data mart
Oracle Databases 11g and 12c
Operating Systems: Unix and Red Hat Linux
Excellent communication (oral and written) skills are a must.
Microsoft Office applications: Word, Excel, Visio and PowerPoint.




Job Location
New York City

Position Type