spacer image
MacMillan Logo white spacer white spacer
white spacer Careers  |  Contact 
white spacer white spacer
spacer image
spacer image red line spacer image
spacer image gray line white line white line white line gray line spacer image
spacer image gray line white line gray line gray line gray line white line gray line spacer image
spacer image gray line white line gray line
About MacMillan gray line Our Publishers gray line Bookseller Services gray line Acedemic & Library Services gray line
gray line white line gray line spacer image
spacer image gray line white line gray line gray line gray line white line gray line spacer image
spacer image gray line white line gray line
gray line gray line gray line
gray line gray spacer
gray spacer
Careers
Browse Open Jobs
Search
Newly Added Items
International Sales
Ordering
Out-Of-Print
white spacer

 

 

 

 

 

 

gray spacer gray line gray line
Job Details

Requisition Number 17-0170
Post Date 8/14/2017
Title ETL Developer
Organization Name Macmillan
City New York
State NY
Description
Macmillan is a group of media companies in the United States held by Verlagsgruppe Georg von Holtzbrinck, based in Stuttgart, Germany, which publishes a wide range of books, magazines, and digital products for the consumer and education markets. Our American publishers include Farrar, Straus and Giroux, Henry Holt & Company, W.H. Freeman and Worth Publishers, Palgrave Macmillan, Bedford/St. Martin’s, Picador, Roaring Brook Press, St. Martin’s Press, Tor Books, Hayden McNeil, i>clicker, Macmillan Children’s Group, Macmillan Audio and Bedford Freeman & Worth Publishing Group. We are an Equal Opportunity Employer. The successful candidate for this position will be an employee of Holtzbrinck Publishers, LLC.
Requirements
Position Description:

The ETL developer will be responsible for development and maintenance of the ELT/ETL processes in support of the Oracle Data Warehouse., including

• Development, validation, and support of the ELT/ETL procedures using ODI
• Implementation of data integration and data loading tasks
• Monitor and troubleshoot production data loads
• Data analysis
• Documentation of technical and system specifications documents for ETL processes


Major Responsibilities:

• Development, validation, and support of the ELT/ETL procedures with ODI
• Implementation of data integration and data loading tasks
• Migration of Legacy Jobs into ODI
• Monitor and troubleshoot production data loads
• Documentation of technical and system specifications documents for ETL processes

Required Skills / Knowledge:

• Strong written and oral communication skills
• Strong customer service orientation
• Knowledge of Data Warehouse architectures, including star- and snowflake- schema
• Strong analytical skills; Solid interpersonal skills
• Must be highly organized and work quickly; easily handle and adapt to numerous and shifting priorities
• Ability to successfully engage in multiple initiatives simultaneously
• Expertise in the Oracle ODI toolset and Oracle PL/SQL
• Strong knowledge of ELT/ETL concepts, design and coding
• SQL Performance tuning
• Proven experience in developing functional applications and systems of medium to high technical complexity

Experience Needed:

• 3 to 5 years hands-on experience with ELT/ETL development in a Data Warehouse environment
• 5+ years of relevant experience in a Data Warehouse Environment.
• 3 to 5 years developing with an ETL tool.
• Experience with Oracle Data Integrator is a plus
• Has experience with Oracle, SQL queries, stored procedures, for interfacing with the database and database designs.
• Experience in publishing, digital media is a plus.
• Some experience with Jython, Python or Groove is a plus
• Some experience working with Json file format and APIs.
• Experience with ‘Big Data’ is a plus

Educational Background Required:

• Bachelor degree in Computer Science, M.I.S., Business, Math/Stats or related field
Apply On-line
Send This Job to a Friend
gray line gray spacer gray spacer gray spacer gray line gray line
gray line gray line
gray line white line gray line spacer image
spacer image gray line white line gray line gray line gray line white line gray line spacer image
spacer image gray line white line white line white line gray line spacer image
spacer image gray line gray line gray line gray line gray line spacer image
spacer image gray line gray line gray line gray line gray line spacer image
spacer image gray line gray line gray line gray line gray line spacer image
spacer image gray line white line white line white line gray line spacer image
spacer image gray line white line gray line gray line gray line white line gray line spacer image
spacer image gray line white line gray line
 About Us | Careers | Contact | Site Map | Terms of Use | Privacy Notice   Macmillan 2007 
gray line white line gray line spacer image
spacer image gray line white line gray line gray line gray line white line gray line spacer image
spacer image gray line white line white line white line gray line spacer image
spacer image gray line gray line gray line gray line gray line spacer image