Contractor - MDM/ PPDM Data Integration, ETL Developer Architect|
Compensation: $70.00 - $105.00 / Hour
Minimum Education: Bachelors
Job Type: Contract
Email this job to a friend
CONTRACTOR MDM/ PPDM DATA INTEGRATION, ETL DEVELOPMENT ARCHITECT
PROJECT DURATION: (10 months - 1 year) Ability to start within two weeks after interview
LOCATION: Houston, Texas - Applicants must be fully authorized to work in the U.S., physically be located in the U.S and able to interview in person, on-premises, and work at customer site location in Houston, Texas.
Enterprise Data Management solution Work with Senior Architect as a Team Divide tasks to accomplish Delivery
Current phase: Strategy phase is complete; implementation planning phase in process of completion; currently developing statements of work; Now we need to get it all done. Looking for a self-starter competent to work in most project phases of this Data Integration project. Below are areas of involvement:
Analysis, design, coding, testing, debugging, and documenting complex tasks
Partner with the business community in defining systems scope and objectives
Competent to work in most phases of MDM PPDM P2ES SOA upstream oil & gas data integration solution including but not limited to:
o Data modelling - Data architecture: star, snowflake. Star schema implementations: facts (transactional, accumulating snapshot, fact-less), slowly changing dimensions, bridges, aggregates, materialized views
o Involved with tool collection process May use existing tools or use new or combination of and looking for input
o Help with ETL, Oracle development, source target mapping,
o Build Data Model for Operations systems
o Provide analysis
o Possess and be an excellent communicator Ability to work with business and technology teams/ considers the business implications of the technology to the current business environment
Work with the Enterprise Data Governance team, business users, and business analysts to establish, develop, and maintain the Company master data program. (Standards, catalogs, data quality, data flow diagrams, analytics, etc.)
Design and integration with end-to-end BI solutions which include: integration of data sources (e-BS, Peloton) into a set of conformed Data Marts which comprised Enterprise DW; ETL and front end reporting utilizing OBIEE: rpd, Answers, Dashboards, Delivers
Develop and maintain productive working relationship with primary business representatives.
Effectively translate business/functional systems requirements into clear and concise assignments.
Perform system and application trending analysis. Suggest solution improvements as needed.
Perform analysis, development and sustainment of enterprise data solutions.
Responsible for maintaining the integrity, reliability, and compliance of the enterprise data solutions.
Analyze, scrub, and enhance data to improve data quality.
Ensure the Enterprise Data solution adheres to client company standards
Ability to communicate effectively with a wide range of audiences (technical and non-technical) and in a wide range of settings (e.g., one-on-one, small groups, in person, conference calls and via e-mail).
Capable of understanding and translating business requirements into enterprise data solutions.
Strong analytical and complex problem solving skills.
Competent to work in most phases of application development activities.
Capable of analyzing and extracting data across platforms and application repositories.
Possesses the ability to effectively promote and work in a team environment.
Uses complex debugging techniques to develop and test scripts, programs, and applications.
A complex understanding of SQL syntax; Data Profiling; environment is Oracle (10g or above) and Microsoft SQL Server
Experience working with ETL solutions and Development; a real roll up your sleeves well established Consultant who can work through all phases of the SDLC, SOA
Experience working with the PPDM data model
Experience working with Oracle EBS, P2ES Energy Solutions, P2 Merrick/ P2 ProCount (ProCount, P2s Hydrocarbon Accounting solution, to accurately manage production allocation requirements from the simple to complex both onshore and offshore)P2 eVIN (data processing measurement calculations, data verification and validation from all entry sources, operation scheduling) and Pelotons Wellview is a major plus.
Oil and Gas industry experience a must
Experience rationalizing and implementing master data (MDM) sets
Experience analyzing and implementing enterprise data quality solutions
Other Technology areas/ integration with: BI Apps components: DW, Informatica, DAC, OBIEE. Peloton/Well View and integration with existing BI Apps components.
Send resumes via Word Document to firstname.lastname@example.org; Please enter MDM, PPDM Modeling/ ETL Development Consultant in Subject line
Quality Contax Inc.