Data Services ETL Developer - OMC

"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.*This is a remote/office based position which may be performed anywhere in the United States except for within the state of Colorado.**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 - OMCLocation : 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.*PRIMARY RESPONSIBILITIES** 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 staffDue 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 veterans status or any other characteristic protected by law.**Job:** **Consulting***Organization:** **Oracle***Title:** *Data Services ETL Developer - OMC***Location:** *United States***Requisition ID:** *200014VX*"