ETL Developer

The ETL Developer is part of the Data Analytics team group and is responsible for designing, building, deploying, supporting and maintaining ETL A2A Data Stage interfaces using the IBM Info Sphere Data Stage ETL development tool.

The ETL Developer will be main Data Stage ETL interfaces and will design, develop, maintain, and support Data Stage ETL compliance processes using the IBM Info Sphere Data Stage tool. This role is also responsible for complex interface process development, troubleshooting issues, supporting weekend maintenance and production support of the interface processes development by the ETL Team. Reports to the Team Leader.

Has no direct/indirect reports.

Takes full ownership of one or more projects primarily focused on developing integration solutions for multiple projects. This role executes deliverables with minimal supervision applying standard operating procedures as well as technical expertise to unique sets of facts, refers more complex matters to supervisors or other experienced staff. This role participates in a production weekly support roster.

The job responsibilities are described herein:

• 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.
• 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.

• 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.

Need only locals NJ,NY

The ETL Developer is part of the Data Analytics team group and is responsible for designing, building, deploying, supporting and maintaining ETL A2A Data Stage interfaces using the IBM Info Sphere Data Stage ETL development tool

The ETL Developer will be main Data Stage ETL interfaces and will designs, develops, maintains, and supports Data Stage ETL compliance processes using the IBM Info Sphere Data Stage tool. This role is also responsible for complex interface process development, troubleshooting issues, supporting weekend maintenance and production support of the interface processes development by the ETL Team. Reports to the Team Leader.

Has no direct/indirect reports.

ETL Support. Supports weekend maintenance, technology / business recovery tests and system verification / validation events.

Assists QA team with identifying QA test cases and supports them during QA testing.