PBT Group requires the services of consultants to assist with the development of one or more data marts, including: - A student records data mart for enrolment and progression reporting, including trend analyses; - For bandwidth consumption reporting; - For departmental financial reporting by cost centre against budgets. The Business Objects Data Services Developer will be will be required to design and develop the ETL systems for delivering data to the various data marts (both historic load processing and incremental load processing). The outcomes of the engagement will be the ETL System Specifications and an ETL system to handle historic fact and dimension loads, incremental fact and dimension loads and automation of these processes. | ||||
Skills required | ||||
- Knowledge of Relational Database concepts and SQL. - Excellent in analytical and problem solving skills. - 3+ years’ experience in Business Objects Data Services. - Experience in performance Tuning ETL jobs - performance tuning will be an essential part of the job. - Experience in both creating new ETL logic via Business Objects Data Services, learning the logic and design of existing ETL processes, and being able to run and support them including scheduling and troubleshooting | ||||
Interaction and reporting: - The Business Objects Data Services Developer will report to the BI/DW Project Manager - Interaction and close working relationships will be maintained with: - Business users - Systems analysts and developers - Other technical staff - Workshops may be conducted with business representatives, business and systems analysts and developers. Key Roles for the Business Objects Data Services Developer: - Drive the process to design and develop the ETL system. (The project manager and other system analysts/developers will assist with requirement definition activities); - Drive the process to ensure the quality of data (ensure the data stewards take an active role in assisting with data quality during the ETL development process); Key deliverables for the Business Objects Data Services Developer: - ETL system specifications, including the high level ETL process and detailed plan for each table; - ETL system to handle historic fact and dimension loads, incremental fact and dimension loads, aggregate processing and automation of these processes. Task list for the Business Objects Data Services Developer: - Design high level ETL process - Develop strategies for extracting data - Develop strategies for policing data quality - Develop strategies for dimension change management - Design strategy to meet availability requirements - Design the structure of the ETL staging area - Design detailed ETL plans for each table - Set up initial job sequencing - Document the ETL system specification - Obtain User acceptance/ review - Build dimension table surrogate key management system - Load the date table and other static dimensions - Build loads for type 1 dimension tables; test - Build loads for type 2 dimension tables; test - Build loads for other Dimensions; test - Build fact table loads; test - Design, build and test ETL system automation - Obtain user acceptance/ review |
Recruiter: CompuJobs