Oracle Data Services ETL Developer - OMC in Hillsboro, Oregon
An experienced consulting professional who has a broad understanding of solutions, industry best practices, multiple business processes or technology designs within a product/technology family. Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices.
Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices. Demonstrates expertise to deliver functional and technical solutions on moderately complex customer engagements. May lead the solution design and implementation aspects of engagement(s) ensuring high quality, integrated software solutions within constraints of time and budget. May act as the team lead on projects, providing coaching, guidance and feedback to develop skills of team members. Effectively consults with management of customer organizations. Participates in business development activities. Develops and leads detailed solutions for moderately complex projects.
6-8 years of experience relevant to this position including 3-4 years consulting experience preferred. Undergraduate degree or equivalent experience preferred. Product or technical expertise relevant to practice focus. Ability to communicate effectively. Ability to build rapport with team members and clients. Ability to travel as needed.
Oracle is an Affirmative Action-Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veterans status, age, or any other characteristic protected by law.
Position : Data Services ETL Developer - OMC
Location : Nationwide (Preferred Location : North America)
Data Services is a key team within the Oracle Marketing Cloud Consulting Organization responsible for designing and building new custom applications and data processing for Responsys, Eloqua and CX Audience Clients.
The Data Services Consultant plays an important role in supporting top Clients delivering white glove service through the design, documentation and build cycle of custom projects.
The successful candidate will have experience in supporting previous digital marketing ETL development. Expert level knowledge of the RI platform a plus. Knowledge of data management best practices, APIs, and application of project management and agile methodologies are key to the Consultants success.
Reports up through the Manager of Data Services
Will work in partnership with the Solution Architect to design, implement, maintain data warehousing and data management solutions to support business reporting and analytics
Includes building source system data ETL processes, verifying data accuracy, design of complex interactions between data fields within the client solution
Develop data set processes for data modeling, mining, and production
Designs, develops and automates reports
KNOWLEDGE & SKILLS
Strong analytical skills; ability to collect, organize, analyze and interpret data/information with key attention to detail
In-depth technical expertise regarding data models, data analysis and design, master data management, metadata management, data warehousing, business intelligence, data quality improvement
Proficiency in SQL building, maintaining and extracting data from relational databases
Proficiency in PL/SQL
Proficiency in bash shell scripting and UNIX
Understands relational database structure; design and maintain robust database schemas
Ability to research and implement best practice database management techniques
Strong skills in organization and time management
Communication skills and strong team work a must
Strong problem solving skills
Essential Job Duties
Design build and maintain ETL feeds for new and existing data sources
Ensuring ongoing accuracy of data ETL feeds, monitoring for changes in source systems
Per solution requirements, build appropriate linkages and relationships between data fields and the data warehouse
Documentation of all metadata including data source, field type, definition, etc. for each field and table created
SME for data sources, structure and definitions
Structuring data in a way that is easy to understand, query and display
RELEVANT EXPERIENCE and TRAINING
5-7 years relevant experience in ETL development required
2 years consulting experience preferred
Product or technical expertise relevant to practice focus
Ability to build rapport with team members and clients
Ability to travel as needed
Ideal candidate will excel in creating a global inclusive environment, possess an infectious positive can-do attitude, ability to inspire team members, maintains a collaborative approach when working across teams, and deliver results under pressure
Undergraduate degree or equivalent experience preferred
Proven ability to be a team player
Strong communication and presentation skills with the ability to communicate and negotiate in a professional manner with clients and internal staff
Due to the nature of the clients and the work, US Citizens and Green Card Holders (GC) / EAD only - no work sponsorships are available currently.
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veteran’s status or any other characteristic protected by law.
Title: Data Services ETL Developer - OMC
Location: United States
Requisition ID: 200014VX
- Oracle Jobs