Oracle ETL Developer
Optimal Business Group, Inc - Portland, OR

This job posting is no longer available on Optimal Business Group, INC. Find similar jobs: Oracle ETL Developer jobs - Optimal Business Group jobs

Role: Oracle ETL Developer

Location: Herndon, VA or Portland, OR

Duration: 6+ Months

Start Date: ASAP

Interview: Phone screen followed by a required F2F
(Candidate must be able to come on-site for a face to face interview on their own expenses.)
Higher preference will be given to Local Candidates.

Required Experience:
  • Strong experience with ODI 11g including environment configuration, integrations development, production of scripts and packages, optimization
  • Understanding of ETL/ELT design principals, disciplines and workflows (best practices/methodology)
  • Experience designing and deploying data warehouse models
  • Working knowledge of data warehouse concepts and practices (dimensions/facts, datamarts, staging tables, change-data-capture, materialized views, data pump, DB links)
  • Strong background using Oracle SQL & PL/SQL to develop a variety of solutions
  • Data modeling (logical and physical), prior use of ER tools (e.g. ER Studio, Erwin)
  • Experience producing reports in Oracle BI Publisher strongly preferred
  • Strong communication skills interfacing with technical and non-technical audience, internal and external stakeholders
Preferred:
  • Experience with components of Oracle BIEE 10g/11g (BI Answers, dashboards and analytics)
  • ETL configuration via Oracle Warehouse Builder, Oracle DAC
  • Exposure to Active Data Guard, Informatica, OLAP cubes/MDX
  • B.S. in Computer Science or related
Description:
This individual will join the Data Systems group as the primary owner of Oracle ETL and system integrations. This person will have a solid understanding of reporting and interact daily with members of the Business Intelligence team and report developers. The role will also interface with external vendors to design and develop data extractions and data exchanges. This will be a key contributor in the development of new data warehouse products with an Oracle technology focus.

Essential duties and responsibilities include the following. Other duties may be assigned.

Job Duties:
  • Design, develop, test and deploy ETL/ELT mappings using ODI
  • Participate in requirements gathering, design and implementation of ETL/Integration solutions
  • Development of ETL to/from normalized and dimensionally modeled databases
  • Participate in database design/architecture, including data warehouse dimensional modeling
  • Perform data modeling using ER Studio
  • Interface with report/BI developers on development and troubleshooting of reports/analytics products
  • Perform gap analysis of disparate systems, manage metadata, develop conforming dimensions, hierarchies and calculations/attributes based on business requirements
  • Optimize and convert existing ETL/ELTs
  • Contribute to Master Data Management strategy & processes
For more details, Please contact Lekshmi@301-358-3620