Job Title: Datastage Developer
Duration:12 Months
Location: Jersey City NJ
Tax Terms:1099 W2 C2C
Role Objectives
- Performs analysis and design of the business requirements and specifications as required.
- Develops and maintains interface ETL processes between databases and/or flat files.
- Works with various application team members to obtain the requirements for their development work.
- Creates unit test plans and performs unit testing for the interface processes that they developed or modified.
- Creates documentation for the processes that they developed as well as updates documentation for the processes that they modified.
- Performs peer code reviews including verification of compliance with coding standards and ensures that the code they developed adheres to coding standards and functional / technical specifications.
- Coordinates code promotion activities through all SDLC environments and validates that promoted interface code is working as expected.
- Assists QA team with identifying QA test cases and supports them during QA testing.
- Updates team leader and project manager with status of assigned development/project work.
- Troubleshoots production issues independently and assists in timely resolution of incidents.
- L2L3 ETL Support. Supports weekend maintenance technology / business recovery tests and system verification / validation events.
- Keeps up to date on new features and enhancements in the development tools used by the team.
Qualifications and Skills
- Expert experience implementing and supporting large data warehouse/data mart using Datastage ETL tool.
- Functional experience using data model as the main document to design and develop the Datastage load process for a data warehouse/data mart.
- Strong knowledge of relational and dimensional database concepts.
- Experience working in all phases of a full project life cycle including design.
- Experience developing both server and parallel jobs running on a Unix platform against relational databases (i.e. Oracle or SQL Server systems) as source and target data environment.
- Expert understanding of data warehouse concepts and experience implementing data warehouse.
- Demonstrate ability to work on multiple projects simultaneously.
- Excellent communication skills both verbal and written with the ability to write and communicate requirements to business and technology partners.