Job Listing: ETL Developer

Volt Professional Search has teamed up with a company that was founded in 1983 and operates under one major premise: to give musicians the best prices and selection, along with superior service to help them achieve their goals in music. Armed with a vision for excellence, the company was the first in the music industry to offer a generous money-back guarantee, later to become the 45-day Satisfaction and Best Price double guarantee, along with many other innovative programs created to give musicians the best possible shopping experience found anywhere.

Currently, this company offers over 36,000 products in its mail order catalogs and on its website. Products offered include guitars, basses, keyboards, percussion, amps, as well as recording, mixing, lighting, and DJ gear. Hundreds of new products are added monthly as the company continues to broaden and deepen its offerings. It still offers money-back satisfaction and price guarantees on every purchase and prides itself on having a topflight staff of customer service people who live and breathe the products they sell. The website is easy and intuitive to navigate and its speedy search engine makes finding what you need a cinch. With a centralized warehouse strategically located for fast delivery, shipping time is minimized.

But this company is more than just catalogs and Web sites - they are about leading the industry with an award-winning commitment to quality, value, and service! More importantly, they recognize it's your support that has made them the #1 direct marketer of music gear in the world.
So come join a progressive, creative, and collaborative team in a stable, consistently growing music industry company. For over 20 years this company has steadily increased its market share to become the world's largest direct marketer of music gear. Their cutting-edge website has won a Top 50 award from Internet Retailer, and their Catalog has been recognized by Catalog Age, reflecting their creative culture to reach a creative customer base. They are always seeking motivated, bright individuals for their Corporate Headquarters, their recently expanded Contact Center, and their state-of-the-art Distribution Center. Many of their positions give you a chance to work directly with the latest and coolest music gear - a real boon for the musically minded.

Currently they are looking for an ETL Developer at their Corporate Headquarters.

The extraction, transformation, and load (ETL) developer creates jobs moving data from system to system. Source and target data often will be stored in enterprise-class databases, such as SQL Server or Oracle, but also include file-based items. Jobs created by the ETL developer will undergo a QA and DBA evaluation prior to moving to production. The ETL developer will be responsible for scheduling, monitoring, and responding to issues resulting from the ETL job execution. Corporate reporting and security standards must be followed. The ETL developer also will be responsible for generating data quality metrics and overall summaries of target data statistics, including their publication to metadata consumers.
As a member of their Decision Support team inside IT, this ETL developer will assist in SQL script creation, stored procedure development, and report development, in support of decision support analysts. Other non-central, but import tasks include entity-relationship diagramming using industry-standard tools, metadata maintenance, working with the DBA team, and general data maintenance, reporting, and database-oriented tasks.


Required Skills

ETL job creation using BIDS for SQL Server 2005 Integration Services jobs.

ETL job scheduling using SQL Server 2005 Agent.

Creation of data flows into different targets based on quality and consistency metrics.

Creation of data models using industry-standard CASE tools (e.g., ERwin, ER/Studio, PowerDesigner).

SQL coding with SQL Server Management Studio.

Conversion of legacy PL/SQL into T-SQL.

Creation of T-SQL stored procedures.

Creation of reports using SQL Server 2005 Reporting Services.

Creation of consistent documentation for all development efforts.

Facilitate database object code promotion using source control and communication with the DBA team.

Work with business users to develop requirements for information delivery requirements.

Work with outside vendors to manage import and export of proprietary information in a secure manner.

Evaluate products to support IT and Decision Support missions.

Accomplish all tasks while meeting information security requirements.


Essential Qualifications:

Minimum of three years of general ETL experience using industry-standard tools (e.g., Informatica, DataStage, SQL Server Integration Services).

Minimum of one year of ETL development experience using SQL Server 2005 Integration Services.

Minimum of one year of experience using .NET programming (can be based on CLR-based development in SQL Server).

Demonstrable experience in enterprise application integration planning and execution.

Demonstrable experience of defining and meeting data quality parameters.

Intimate familiarity with database concepts, including normalization, indexing, physical and logical modeling.

Intimate familiarity data warehousing concepts, designs, and industry-standard practices.

Familiarity with project management controls and techniques.

Ability to represent the company in a professional and positive manner and promote company values.

Date Posted: July 21, 2008

Job Details

Job Location

Candidate Application

Employer: Volt Staffing Address: Contact:
Job Type: Full-time City: Medford Phone: 216-737-0500
Experience: State: Oregon
Education: Any Zip Code:97504 Online: Website Link

Salary and Benefits

DOE

If you wish, you may also Submit Your Resume to the Insourced co-branded Resume Submission service, which will make your resume available to all employers in the CareerBuilder.com job search system.

Insourced lists job information exactly as provided by employers.
Please click on the Job Source link to confirm the status of a position and to clarify any discrepancies or errors in a job post.

Job Search Results for: Volt Staffing

Volt Telecommunications Group is looking for Central Office Technicians to work in Lake Havasu City and Kingman, AZ.Technicians will perform install, maintain & repair High Speed Internet service to residential or business customers, carrier equipment, special circuit, dat...
Exciting upcoming opportunities for Technical Support Agents! Volt has upcoming opportunities where your outstanding customer service and technical knowledge will be the key to your success!As a Technical Support Agent, your key responsibility will be to answer customers a...
Are you a customer service oriented individual with call center experience? Then Volt urges you to call today! Apple is seeking Customer Support Representatives to provide assistance with device set up, basic trouble shooting (Tier 1) and answer customers’ commonly asked q...
Looking for experienced Maintenance Tech to join stable manufacturing company in the Lexington area. Must be willing to work 1st, 2nd, and 3rd Shift. Please email your resume and salary requirements for immediate consideration. Volt is an Equal Opportunity Employer....
The Manufacturing Engineer position reports directly to the Director of Manufacturing Engineering and is primarily responsible for providing production support of precision electro-optical devices for analytical analysis of process gas applications.Responsibilities:Design ...

View all: Volt Staffing Jobs