- 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.
CRITICAL JOB KNOWLEDGE AND CORE COMPETENCIES/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.