As an ETL Analyst / Programmer you will be joining the Business Intelligence project and design/develop IBM Datastage jobs to extract / transform and load data from various source information systems into an oracle data warehouse environment.
Your Responsibilities
- Work with Business Analysts and Data Modeller to design and implement ETL specification details to meet Business Requirements.
- Develop ETL parallel jobs and sequences to extract, land, transform data to be prepared for a data warehouse presentation area.
- Work with Business Objects Developers and Data Base Administrator / Data Analyst to ensure data designs (models and naming conventions) support a data warehouse environment utilising detail and aggregate star models.
- Develop exception handling capability for ETL jobs and report exceptions accordingly.
- Creation of ETL/data lineage documentation
Yours Skills
- Proven experience working in a Data Warehouse environment using Kimball methodology
- Previous use of the IBM Datastage suite of products or SAP Data Services
- Demonstrated experience and understanding of Systems Analysis and Quality Assurance within a Data Warehouse environment.
- Previous experience using IBM Data Stage
Interested candidates please send your resume to qld@candle.com.au or call Nancy on 07 3217 6966 for a confidential discussion.
|