Job ID :
2894
Company :
Staffing Pipeline
Location :
KANSAS CITY, KS
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
28 Feb 2013
Job Seekers, Please send resumes to resumes@hireitpeople.com

ETL Developer IV

Hands-on Informatica Oracle BI Applications experience. Insure enterprise delivery and standardization of the data warehouse, and all data marts within the environment. Supports and troubleshoots production systems as required, optimizing performance, resolving production problems, and providing timely follow-up on problem reports.

 

Required:

• Bachelor's degree in Computer Science, Business Administration, Engineering, or related discipline with an information technology focus

• 5+ years "hands-on" Informatica experience; including Informatica version 9.0

• 3+ years "hands-on" Oracle Business Intelligence Applications (OBIA); including Oracle E-Business Suite for Finance and HR modules

• 3+ years experience with Oracle Data Warehouse Console (DAC)

• 5+ years "hands-on" RDMS SQL query experience in at least Microsoft SQL Server and Oracle

• Experience with OBIA Data Warehouse Schema's for Financials and Human Resources (including GL, AP, AR, Projects)

• Functional working knowledge of Oracle E-Business Suite modules, including GL, AP, AR,, Projects, and HR is a plus

• Supports and troubleshoots production systems, optimizing performance, resolving production problems, and providing timely follow-up on problem reports

• 2+ years experience with Oracle Business Intelligence Enterprise Edition (OBIEE) is a plus.

• Informatica developer certification or other equivalent certification training

• Codes, tests, and implements complex programs according to IT standards and Oracle best practices.

• Data Warehouse and Database Systems: Theory, architecture, design, configuration, operation, security, and tools

• Relational and dimensional database theory, architecture, design, and tools: Logical and Physical modeling, Dimensional modeling, Star and Snowflake schema, OLAP processing

• Champions quality of data in the warehouse

• Works with Data Analyst on physical model designs for star schemas

• Mentors others through issues and if needed, facilitate resolution

• Takes the established projects and drives them to completion, on time and on budget meeting the customer's expectations and objectives

• Familiarity with technology product & service offerings by vendors providing products and services in the data warehouse and database space

• Possess or has made progress towards receiving a TDWI Certification or equivalent experience

• 2+ year's management of technical/support personnel

• 2+ years project management

• 5+ years experience of successful data warehouse development

• Experience working in an enterprise data warehouse environment