ETL Developer with Oracle Warehouse Builder ( OWB) exp
- Austin, TX
This is our direct-client opening for an ETL Developer in Austin, TX. This is a full-time position that pays 100-110K + Benefits. Our client will offer relocation for nonlocal candidates and can also do visa transfers for those who currently are here on a visa.
Our client is looking for an outstanding individual to fill a key ETL Developer position. This position is responsible for the full life cycle of warehouse systems from requirements gathering and analysis through implementation of the production system. The developer will provide support in all aspects of data movement for a data warehouse environment, with emphasis on the Extract-Transform-Load (ETL) process. Persons in this position must understand the development and maintenance techniques surrounding data movement. You must be a team player and a self-starter who can work independently to exploit Oracle ETL, PL/SQL and proprietary technologies.
Code, test, debug, and document Data Warehouse and financially-related ETL applications of moderate complexity; also - collaborate with other engineers on code reviews, design documentation, process enhancements and other aspects of SDLC
Translate customer requirements and formulates detailed specifications from which programs are written
Maintain a suite of existing applications and provide critical production support to meet daily OLA/SLAs defined with internal and external stakeholders
Participate in 24hr on-call support (on rotation basis)
Identify opportunities to optimize our ETL environment including monitoring and implementing quality and validation processes to ensure data accuracy and integrity
Participate in development and production support around few non-ETL applications like EBX/MDM, OBIEE, TIDAL, etc.
Must have 4+ years experience working either a 'Data Warehousing' environment (focused on Operational Data Stores, Data Warehouse and Data Marts) or experience developing 'Enterprise ETL' applications
3+ years development experience with various ETL tools (combination of Oracle Warehouse Builder – OWB, IBM IBM DataStage, Informatica, etc) is required
1+ years development experience specifically with Oracle Warehouse Builder (OWB) is preferred
3+ years Oracle PL/SQL Development and Oracle SQL tuning experience is required
1+ years Java/XML working experience is preferred
Good understanding with basic Unix Scripting Language
Knowledge/experience with data warehousing concepts such as data modeling, data quality, SCD, ETL and developing data warehouse applications using an Agile methodology preferred
Working knowledge of the Business Intelligence (BI, OLAP, ROLAP) tools
Prefer experience with Master Data Management (MDM) environment
Prefer experience interfacing with ERP (Oracle E-Business Suite) environment
Prefer experience financial services or in a high-transaction processing environment
Bachelors of Science in Computer Science or related fields
Please complete the following skills-matrix and send back with your updated resume.
Total Experience as an ETL/Data Warehouse Developer:
Total Experience with Oracle PL/SQL:
Total Experience with Oracle SQL tuning:
Do you have any experience with Oracle Warehouse Builder (OWB)?
Do you have any experience with BI Tools / applications?
Do you have any experience with Oracle EBS?
Do you have a Linkedin Profile?
If so, what is the URL of your Linkedin Page:
Day Phone #:
Evening Phone #:
Cell Phone #:
Work Status (US Citizen / Green Card / H1B / etc.):