USA Jobs, Careers and Recuitements
Job Target Job Search

Contact Information

Contact Name: DAVE
Address: Rabbit ,Elk Grove , California 95758 - USA
Contact Phone: 6674791

Job Details: Data Warehouse Architect Date: May 24 2020

Job Reference: 2025
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Recruiter
Employment type: Full Time, Contract
Salary: 70 / Contract
Degree: Masters
Experience: 3 years
Location: Sacramento, , 94203
Job Skills: no skill specified
Share Job with Others

Job Tools

Job Description

12 to 15 years of experience in the field or in a related area

Plans, develops, tests, and documents computer programs (specifically in data warehouse ETL: Extraction,

Transform and Load), applying knowledge of programming techniques and computer systems.

Evaluates user request for new or modified application software to determine feasibility, cost

and time required, compatibility with current system, and computer capabilities.

Consults with team members and users to identify current operating procedures and clarify objectives.

Formulates plan outlining steps required to develop program, using methodologies such as structured analysis and design or object-oriented development.

Work involves assisting in analyzing systems outlines to develop programs for computer applications,writing solution programs,

documenting the methods and procedures used in program development, and testing and correcting programs.

Works under limited supervision with considerable latitude for the use of initiative and independent judgment.

Designs technical data models and specifications for accomplishing user requirements in the business intelligence sphere.

Converts project specifications, using specialized software, into sequence of detailed instructions and logical steps

applying knowledge of computer programming techniques and computer languages.

Performs unit testing to detect syntax or logic errors. Replaces, deletes, or modifies codes to correct errors. Analyzes,

reviews and alters program to increase operating efficiency or adapt to new requirements. Writes documentation to describe program development,

logic, coding, and corrections.

Assists business analysts and users to solve problems. Recreates steps taken by user to locate source of
problem and corrects programs to fix errors.

May provide technical assistance to program users.

Will monitor performance of program after implementation and use knowledge of database tuning

to improve substandard performance. Specializes in developing programs for data warehouse/business intelligence applications.

The contractor will work with the business analysts, BI architect, and developers on the data warehouse team and on the source systems team(s).

The tools and technologies used for this work are specialized, and the contractor

will have the responsibility to mentor and lead other team members in the proper use of these tools and technologies,including developing,

recommending, and communicating their best practices.

Extremely high level of expertise (12 or more years) with Oracle, including PL/SQL and SQL, performance tuning, and DDL operations
Required 12 Years

Extremely high level of expertise (12 or more years) in data modeling and/or data warehouse schema design
Required 12 Years

Ability to analyze and evaluate user requirements and the characteristics of source system data
Required 10 Years

Advanced knowledge of ETL (Extraction, Transformation and Load)
Required 5 Years

Documentation skills to produce program component specifications, requirement specifications, test plans, and user documentation
Required 5 Years

Oracle Warehouse Builder expertise
Required 1 Years

Copyright © 2020 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.