Latest Jobs  
Advance your technical career… Find a tech school and start an IT career!
Start your career in the fast-growing technical field – Get more info here »
Advance your technology career with the latest technology skills - Get more info here »
 
This job has expired.
 
Job Information
Job title

Data Modeling/ Data Warehousing Consultant (#4271210)

Company Aetea Information Technology
Wage Not specified
Location United States, New Jersey, Jersey City
Employment type Contract to Perm
Education High School
Year Experience 4 - 5 Years of Practical Experience
Travel Not Specified
Published on 5/15/2005
Description
Our Company, AETEA Information Technology, has 9 offices nationwide with over 500 consultants currently working for us. Our clients are Fortune 500 companies in the financial (bank/brokerage), telecommunications, manufacturing, healthcare, pharmaceutical and insurance industries. Provide direction for the definition of a warehouse architecture that supports the business information needs for Worldwide Medicines Sales, Marketing and Medical Groups. Accept full responsibility and accountability for the data warehouse architecture and design activities, identifying areas of risk during the development process and driving out solutions which can be implemented to eliminate or reduce any risk. Collaborate with the project teams to establish overall direction to ensure the needs of all projects are met. Identify IT solutions to improve the effectiveness and efficiency of business processes. Communicate with team members and other stakeholders in a timely and effective manner in order to keep them apprised of architecture status and relevant issues of interest to, and impact on, the clients and their business areas.MAJOR SKILLS AND EXPERIENCE REQUIRED:- Progressive experience with the data warehouse architecture, Data Warehouse Decision Support design and application deployment - 5 years experience with ERwin preferably with star schema design- 4 years experience with Oracle 8I or 9I dimensional databases- 4 years experience with data warehouse database query optimization- 3 years experience in the pharmaceutical industry, preferably in sales and marketing- ETL and process specification experience- Application process modeling, data flow experience- Knowledge of logical and physical warehouse data design- Knowledge of the overall data warehouse architecture- Strong technical, problem solving and team skills- Strong verbal and written communication skills to document work steps and present findings to both clients and the technical teamRESPONSIBILITIES:- Analyze queries with database performance analysis utilities (Explain Plan, etc.)- Optimize query performance by defining a)appropriate indexes & b)an appropriate system of summary tables- Work with ETL team to specify load processes- Work closely with DBAs to resolve major issues (such as problems that require the application of Oracle patches and upgrades)- Respond to data quality and consistency concerns expressed by the user community- Capture and run user queries and critically examine the results- Work with the ETL team as necessary on more extensive data verification that cannot be resolved by analyzing the databases


You may apply directly with ?id=4271210df-tc

Experience/Skills
See Above

Other desired skills:
Data Modeling/ Data Warehousing Consultant (#4271210)
This job has expired.