Title: Marketing Database ETL Developer
Skills: ETL; Ab Initio; Data Warehouse; Oracle 9i or 10g; SQL; Unix
Date: 7-13-2007
Location: Broomfield, CO
Area code: 303
Tax term: FULLTIME
Pay rate: DOE
Length: Full Time Position ID: 97255
Dice ID: corpexp Job description: To see all Corporate Express jobs, go to the Employment section of the Corporate Express website (www.CorporateExpress.com)
Friendly Atmosphere; Competitive Salaries; Environmentally Conscious; Opportunity to Develop and Advance; Corporate Express is a place where technology melds with an innovative business strategy, a place of excitement, vision, integrity and dedication to a higher standard.
Corporate Express...opportunity in your hands!
Let's face it...EVERY business needs some level of office product and service support to run efficiently. What makes Corporate Express unique? Our broad product offering addresses our clients' requirements for an office to run smoothly. From office set up through daily office and facility supply maintenance, we position our clients for success by permitting them to focus on what's most important to their business. Our global presence, ease of online
purchasing, competitive pricing and hands on approach to working with our customers sets us apart from our competitors.
MARKETING ETL DEVELOPER
ESSENTIAL DUTIES AND RESPONSIBILITIES
o The individual will be a member of the Data Warehouse team. This team is responsible for all development work, maintenance and 3rd tier support performed on the Data Warehouse.
o The primary responsibility of this role will be to build and maintain a Marketing Database data mart as part of a new project effort and to focus most development work in building reporting functionality for the marketing department at Corporate Express.
o Design, develop and maintain several different load programs in various program languages (Ab Initio, SQR, PL/SQL). Ab Initio and PL/SQL is a must and SQR background is a plus.
o Works with business requirements analyst to identify and understand source data systems.
o Responsible for creating and maintaining standard development life cycle documentation as part of all development project tasks.
o Adapts ETL processes to accommodate changes in source systems and new business user requirements.
o Performance tune new/existing programs that load data into the data warehouse.
o Technical resource for the data warehouse and Business Analyst team.
o Work closely with other data warehouse team members and the internal architecture group to work through scalability issues, new sourcing architectures, and processing standards.
o Maps source system data to data warehouse models.
o Meets with DSS Data Modeler and DBA to review design strategies for new ETL processes.
o 3rd Tier nightly support on-call rotation required of all DW ETL developers (~2 weeks daily once every other month).
REQUIREMENTS
o Proficient development background in Ab Initio
o Extensive Oracle 9i or 10g experience, specifically in the areas of
Partitioning, Index types, SQL*Loader and other Oracle storage parameters that are useful for loading and utilizing large databases.
o 3+ years experience working with relational databases.
o 3+ years of advanced SQL use (Correlated sub-queries, Unions, Minus, Outer/Inner Joins, Aggregate Functions, group by and having syntax). Must be able to read Oracle Explain plans and react to adverse performance plans accordingly.
o 1+ years experience with PL/SQL, Stored Procedures & Packages and DB triggers.
o 2+ years experience with an ETL development tool.
o 2+ years working on various types of Unix operating systems.
o Solid background in 3GL/4GL programming languages.
o Good Unit test skills along with good knowledge of unit testing techniques.
o Strong troubleshooting skills.
o Working knowledge of several partitioning concepts (Hash, Round-Robin, Range, etc.) and parallel processing depths.
o Experience working with data warehouses; understands data warehouse theory.
o Must be proficient in the Unix VI editor.
o Understands Unix File Systems, Mount Points, Directory Permissions, Soft & Hard file links
o Must have strong Unix shell scripting skills in (KSH, Bourne or CSH).
o Industry knowledge in marketing concepts such as closed loop sourcing, data augmentation from external sources, and campaign management processes is a big plus.
Professional
o Strong data analysis/analytical skills
o Detail oriented, strong self-testing skills
o Enjoys working in a small team environment
COMPETENCIES
Bachelor's degree in Computer Science or related technical field and/or equivalent combination of education, training, and experience.
Corporate Express is an Equal Employment Opportunity/Affirmative Action employer that promotes work force diversity and hires without regard to race, color, religion, national origin, age, gender, marital status, disability, sexual orientation, veteran status or other protected status. Travel required: none Telecommute: no
