*Dear partner,*
*9to9* *Software Solutions* is looking for a *Data Warehousing Expert* for our client in *Houston, TX* *Job title: Data Warehousing Expert - Public Petroleum Data Model implementation Lead* *Duration: 6+ Months* *Location: Houston TX* *Interview: Telephonic + In person* *Skill set:* Public Petroleum Data Model (PPDM), Data Warehousing, Master Data Management, ETL, Oracle SQL, PL SQL, general database coding, enterprise integration, xml, Java web services · Developing, Coding and Testing integration solutions from a Well Master Data Management solution. · Knowledgeable of Public Petroleum Data Model (PPDM) and extracting data. · Data Warehousing and Master Data Management experience. · Oracle SQL, Pl*Sql and general database coding and knowledge. · Experience with enterprise integration, xml, xslt, Java Web Services. · Deal with complex ETL applications particularly experience with production accounting and drilling applications · TOW, Avocet, Open Wells, Well View. *Responsibilities :* · gathering requirements from customers · Establish a well hierarchy for key identifiers · Map data source attributes into TDM GL Staging Tables so the data can be loaded into TDM consistently · Enhance TDM GL Staging Tables to support all data sources listed · Populate TDM (PPDM) database with data for the Company Central region (2 districts) consisting of approximately 10,000 wells · Data sources will include: · Aries · OpenWells · Avocet · GeoPortal · RigView · IHS well and production data for the 10,000 Central Region wells · Define the attributes to be exported/synchronized from TDM · Select a subset of attributes (identifiers) to export/synchronize with: · Wellview/OW · Production Accounting (Avocet) · Aries · RigView · Configure the TDM to record these attributes into the TDM audit tables for consumption by Company processes to integrate/synchronize with external systems · Company will build the processes to read the data from the TDM audit tables · Assist with creation of Well Master Data Mart view · Assist with creation of the Well Master view from the TDM data source *Best Regards,* *Vineeth * Sr Technical Recruiter | 9to9 Software Solutions LLC Direct: 203-678-8000 Ext- 206 | 860-760-0401 | Fax: 855-929-SOFT Email:[email protected] <[email protected]> | http://www.9to9soft.com [image: http://www.9to9soft.com/images/9to9logo.jpg] *CONFIDENTIALITY NOTICE*: This is an e-mail transmission and the information is privileged and/or confidential. It is intended only for the use of the individual or entity to which it is addressed. If you are not interested in receiving our e-mails then please reply with REMOVE in the subject line and your ID will be removed from our mailing list. We are sorry for the inconvenience caused to you. -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/business_intelligence. For more options, visit https://groups.google.com/d/optout.
