Description
Skills Required:
- Testable strong SQL with complex queries
- Experience translating business requirements to SQL ETL
- Strong analytical and problem solving skills
- Performance tuning skills (Teradata)
- ETL experience with Teradata database
- Experience with IBM InfoSphere Information Server (DataStage)
- Experience with Data Architecture including knowledge of dimensional Datamodelling techniques, ERWIN, etc.
o Experience with Dimensional Datawarehouse ETL Design
- Job scheduler experience
o Experience in requirements development for large projects
- Proficient testing skills - unit, system, and integration
- Very good verbal and written communication skills
Preferred:
- Experience with PVCS and/or ChangeMan MVS code versioning software
- Experience with Zeke MVS Job scheduler
- Mainframe MVS JCL programming
Analyst Attitude Profile:
- Self-starter, responsible
- Strong team ethic and customer-support focus
- Ability to contribute knowledge by sharing and training technology skills to peers
- A finisher', seeing a project or task through to completion in spite of challenges
- Good troubleshooting and problem-solving skills and instincts
Initial Project Assignment/Responsibilities:
- The Applications team is starting a project to create a Business Intelligence dashboard for assets. This project team will work in a matrixed environment in coordination and governed by the IT Business Intelligence team. This team supports Business Intelligence (BI) initiatives and the enterprise implementation of OBIEE+ supported by star-schema data models.
- Candidate must enjoy working in a team environment developing ETL solutions and detailed designs for the Datamodelling requirements of BI initiatives
This individual will see the project through all scopes and then support the completed project.