1. Project:ETL Development and maintenance
Company:Globetek Software Systems
Client : A German Insurance company
Technology:Oracle Warehouse Builder 10g, Toad 9.x, Oracle 10g, SQL, PLSQL.
Role:Developer.
Description:Oracle Warehouse Builder (OWB) is Oracle’s comprehensive tool for ETL .The Objective of the Project was to use OWB and perform the mappings .The main task was to migrate data from production environment into DWH environment, which included Design, Development, Testing and Deployment of the ETL jobs. Various jobs were created reflecting entire DWH. This project includes modules like Premium, Claim, Policy, Partner, IMD & All other procedures and functions. Includes new development as well as support, maintenance/enhancement of existing applications.
Contribution:
Worked closely with Project manager to identify and specify complex business requirements and processes. Researched and evaluated alternative solutions and made recommendations.
Created workflows within the mapping to migrate data based on the conditions given in the specifications.
Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression, look-ups.
Construct complex SQL queries with analytical functions.
Responsible to create and maintain ETL processes, mentor other team members.
Developed Logic in SQL, PL/SQL and ETL mappings.
Developed processes to enable movement of ETL processing from production to DWH.
Worked with programmers to develop and tune the ETL logic.
Ensured the ETL code delivered is running, conforms to specifications and design guidelines.
Took Initiative in completing all the ETL jobs, including jobs of other team members.
Worked as a team member and independently.