Hotlist-Hotlist ETL DB - St. Paul, MN

 

ETL DB

6 months

St. Paul, MN

Database Resource Job Description
The candidate will be responsible for data integration and transformations (ETL Process) from the corporate data warehouse into Oracle databases, including the design (schema, objects and load processes), documentation and support. They should be able to follow established Software Development methodology to develop new integrations and enhancements to existing integrations. They should be able to execute projects according to established businesses process including testing, performing root cause analysis, and debugging processes to resolve the issues. The candidate should be able to handle complex analysis with little supervision and develop actionable recommendations based upon the analysis performed.

Duties and Responsibilities

·         Work with the pricing and corporate data warehouse teams to ensure that the proper data is identified and transformed into a usable format for the pricing application.

·         Responsible for designing the queries and transformation processes to support pricing integrations (ETL Process).

·         Responsible for the implementation and maintenance of the integration process including the databases objects used to support the integration.

·         Responsible for problem escalation to the team, Oracle DBAs or Corporate Database personnel as appropriate.

·         Develops and implements strategies to translate business requirements into feasible designs.

Skills / Attributes Required

·         Oracle Database (10g / 11g) experience.

·         Proficient in SQL / PL SQL.

·         Experience working with multiple RDBMS systems - Oracle, SQL Server and Teradata.

·         Experience with SSIS

·         Good communication skills.

·         Good analytical and problem solving skills.

·         Ability to work independently and as part of a team

·         Experience writing Functions and Procedures in SQL Server and Oracle

·         Performance Tuning Experience

·         Understanding of Pricing Systems / Vendavo / SAP a plus.

 

 

Regards,
 
Ali

Key Business Solutions, Inc.

|| Office: 916 978 1051 || Fax: 916 646 2081 || Email: ali@key-soft.com || Website: www.key-soft.com ||

 

Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.

 

--
You received this message because you are subscribed to the Google
Groups "USA: RECRUITERS GUIDE" group.
To post to this group, send email to RECRUITERS_GUIDE@googlegroups.com
To unsubscribe from this group, send email to
RECRUITERS_GUIDE+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/RECRUITERS_GUIDE?hl=en
 
PLEASE PROMOTE THIS GLOBAL CHAT ROOM FOR RECRUITERS (US STAFFING)
 
 
LINK: http://www.netbookteknologies.com and then click on CHAT ROOM.
 
(IN CASE NOT ABLE TO RUN THE MESSENGER APPLICATION KINDLY DOWNLOAD JAVA FROM DOWNLOAD LINK OF WWW.NETBOOKTEKNOLOGIES.COM)
 
NOTE: YOU HAVE THE FACILITY TO DO PRIVATE CHATTING WITH INDVIDUAL USERS AS OTHER MESSENGERS.

--
You received this message because you are subscribed to the Google
Groups "Hotlist-Hotlist" group.
To post to this group, send email to hotlist-hotlist@googlegroups.com
To unsubscribe from this group, send email to
hotlist-hotlist+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.co.in/group/hotlist-hotlist?hl=en