Deployed at Macquarie Offshore Services Pty Ltd.

Data Warehouse Production Support / Data Warehouse ETL Developer* Responsible for the daily loading of data from source systems to the data warehouse database.* Ran and monitored the workflows for CMISD Data Warehouse ETL processes.* Created data maps of identified VSAM files from their respective COBOL Copybooks using Informatica Power Exchange for VSAM.* Develop & implement enhancements to ETL mappings and workflows used in operation.* Document, investigate and resolve numerous data quality issues raised by reports recipients.* Gather data from business users; develop ETL procedures for ad-hoc/ special requirements.* Resolved issues and/or ETL Mapping bugs arising from defects found during the UAT.* Administer the development application server of Informatica Power Center;* Work with Informatica Support in the investigation and resolution of software issues.* Updated the ETL Documents, which contains the source systems analysis, data flow, naming standards and nomenclature, and source-to-target mapping of the data warehouse to be built.* Experience in installation and configuration of, Informatica Power Center Version (7.1.2 and 9.5) Client, Informatica Power Exchange Version (7.1.2 and 9.5) , Oracle 9i DB & DS Client, OFSA 4.5, Oracle 11g Client and Business Objects Version(6.5.1 and 4.0).* Ensures that the metadata repository is synchronized with the production data sources, ETL processes, warehouse schema, and Business Objects software metadata.Concurrent Data Warehouse Referential Officer* Administers referential data by creating new referential data entries, updating existing ones, and retiring entries that are no longer needed through Oracle Forms Services Application and/or flat files;* Manages referential operation (e.g. managing ETL and/or capturing of forex, pool rates & annual targets, updating business unit information, business unit hierarchy & business calendar, adding new deposit product & account types)

• Product testing and design check.• Executes test procedures and documents the results.• Makes simple test procedures as necessary based on detailed specifications