ComResource is looking for a Lead ETL Developer – DataStage.
This person will be leading development and analysis of a large Data Warehouse. The team works Kanban style, and is a mix of on- and off-shore developers. The Lead ETL Developer role is a position responsible for the Design, Development, Testing, and Support of these databases. A key component of the role is to also act as a Technical Lead interfacing with offshore development partners and as a mentor to more junior level team members.
Design, Code, Test, and Document mappings/transformations of load routines to the Data Warehouse or Data Marts.Translation of Functional Specifications into Technical Design Specifications for off-shore development team.May serve as an individual contributor on smaller initiatives, or as a member of a development team on larger initiatives.Function as Technical Lead to junior resources or off-shore development team.May be asked to tune SQL statements to ensure optimal performance.Provide input on physical database design decisions.Troubleshoot and problem-solve data integrity issues.Maintain documentation in corporate data dictionary.May provide 24 x 7 production support.
3 - 5 years of related experience with Ascential DataStageProficient in SQL with experience in other relational Data Bases including Oracle and DB2Must be proficient in Data Modeling principles and with strong Extract, Transform, and Load (ETL) concepts, as well as working knowledge of 3rd party ETL toolsMainFrame /or Job Control Language (JCL) a plus.Scripting skills (SQL, AQT, Shell) a plus