Data Warehouse - Various ETL software design, development and enhancements, documentation and maintenance work; mentoring less senior team members and knowledge transfer very important.
Years of Experience: 12 to 15 years of experience in the field or in a related area
Roles and Responsibilities:
o Plans, develops, tests, and documents computer programs (specifically in data warehouse ETL: Extraction, Transform and Load), applying knowledge of programming techniques and computer systems.
o Evaluates user request for new or modified application software to determine feasibility, cost and time required, compatibility with current system, and computer capabilities.
o Consults with team members and users to identify current operating procedures and clarify objectives.
o Formulates plan outlining steps required to develop program, using methodologies such as structured analysis and design or object-oriented development.
o 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.
o Works under limited supervision with considerable latitude for the use of initiative and independent judgment.
o Designs technical data models and specifications for accomplishing user requirements in the business intelligence sphere.
o Converts project specifications, using specialized software, into sequence of detailed instructions and logical steps applying knowledge of computer programming techniques and computer languages.
o Performs unit testing to detect syntax or logic errors. Replaces, deletes, or modifies codes to correct errors.
o Analyzes, reviews and alters program to increase operating efficiency or adapt to new requirements.
o Writes documentation to describe program development, logic, coding, and corrections.
o Assists business analysts and users to solve problems.
o Recreates steps taken by user to locate source of problem and corrects programs to fix errors.
o May provide technical assistance to program users.
o Will monitor performance of program after implementation, and use knowledge of database tuning to improve substandard performance.
o Specializes in developing programs for data warehouse / business intelligence applications.
o The contractor will work with the business analysts, BI architect, and developers on the data warehouse team and on the source systems team(s).
o 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.
o Extremely high level of expertise (12 or more years) with Oracle, including PL/SQL and SQL, performance tuning, and DDL operations – 12 years
o Extremely high level of expertise (12 or more years) in data modeling and/or data warehouse schema design – 12 years
o Ability to analyze and evaluate user requirements and the characteristics of source system data – 10 years
o Advanced knowledge of ETL (Extraction, Transformation and Load) 0 5 years
o Documentation skills to produce program component specifications, requirement specifications, test plans, and user documentation – 5 years
o Oracle Warehouse Builder expertise strongly preferred – 5 years