Description
Responsible for the architectural system design. Designs, develops, and constructs application systems and consults with clients to refine application needs. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. Leads and directs the work of others. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department.This role needs the developer to:
- Design and develop ETL solutions using Oracle Warehouse Builder (OWB) for interfacing between source application and the Enterprise Data Warehouse.
- Execute unit tests and validate expected results; iterating until test conditions have passed.
- Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production.
- Modify existing OWB code to provide defect fixes for existing ETLs.
- Troubleshoot defects to determine root cause
- Performance tune the ETL process and recommend and implement ETL tuning techniques.
- Develop SQL and PL/SQL to create stored procedures for Business Objects reports
Should be well versed in design and development of ETL processes for large Data warehouse as well support production code base. Should be able to work independently with other IT support as well us users for operational support. Requires a bachelor's degree in area of specialty and at least 15+ years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices, and procedures.