Description
ETL System Architect
Woodland Hills, CA 91367
Position type: w2
Contact duration: 6 months + (strong possibility of extension)
Senior ETL developer to develop ETL processes in Oracle on UNIX platform for Business Objects applications. Requires strong experience with SQL, PL/SQL, Data Warehousing, and ETL processes. Business Objects (Universe and Report development) and UNIX Shell Scripting experience very helpful. Entertainment, financial or royalty experience a plus. Position responsibilities will include hands on development, as well as interaction with the business or other IT groups.
Responsibilities:
- Programming duties will include designing the application, including documentation, developing the framework and reviewing the deliverables for consistency. This position will have to be hands-on as needed to work in the following areas and within departmental guidelines:
- Application Development related to new projects that will be defined
- Enhancements, Maintenance and Support of existing applications
- Adherence to Technology Standards for the department
- Integration with other groups in the company related to hosting, DBA support, Server support and upgrades and production support.
- Develop code in accordance with defined standards and generally accepted practices.
- We expect everyone on our team to present creative solutions to our technology problems.
- Test and document all code changes. This includes unit testing, system testing, performance testing, and capacity testing.
- Perform work in development environment, test in staging environment and work with other groups to push changes to production.
- Account for time spent on activities using time tracking application.
- Meet timelines and communicate with project manager as to progress of open items.
Requirements:
- 5+ Years developing in SQL and PL/SQL
- Minimum 7 years IT experience
- Experience with Data Warehousing concepts and processes required
- Experience developing custom (non-tool based) ETL processes required
- Experience with UNIX and Business Objects very helpful.
- Experience with large data volumes highly preferred
- Knowledge of logical and technical database application design.
- Full project life cycle development experience
Education and Additional Experience/Knowledge:
- B.S. or M.S. in Computer Science, business or related field
- Equivalent experience may be substituted for degree