ETL Developer

Incorporated in 1921, Wilbur-Ellis Company is a leading international marketer and distributor of agricultural and industrial products, with sales exceeding $2 billion in 2007. The Company remains privately held, with ownership concentrated primarily within the founding family. We maintain a multinational marketing/distribution network of offices, formulation facilities, retail centers, and warehouses strategically located throughout North America and the Pacific Rim.  Wilbur-Ellis has been in business over 87 years and we recognize that our accomplishments would not be possible without the talent and dedication of our employees. Our decentralized, entrepreneurial culture, coupled with our belief in training and development, gives our people the freedom, knowledge, and responsibility to best serve our customers.

 

Position: ETL Developer

 

Position Reports to:  Business Intelligence Manager

 

Salary: Dependent on Qualifications

 

General Responsibilities: 

 

Responsible for the scripts required to extract, transform, clean and move data and metadata so they can be loaded in to a data warehouse/Business Intelligence system.

 

Primary Responsibilities:

 

· Work with business analysts to identify and understand source data systems.

· Map source system data to data warehouse models.

· Develop, test, schedule and implement extraction, transformation and load (ETL) processes (DDL, DML, stored procedures, triggers, views etc.)

· Define and capture metadata and rules associated with ETL processes.

· Adapt ETL processes to accommodate changes in source systems and new business user requirements.

· Work with BI analyst and support team to troubleshoot issues.

· Work with BI report developers to generate optimized code.

· Understand source and target data structures, ETL processes and products.

 

Qualifications/Requirements:

 

· 3+ years ETL development within a data warehouse environment preferably on SQL Server platform larger than 500 GB.

· A thorough understanding of relational database internals, star schema concepts, data warehouse data model and source data.

· Advanced SQL skills (SSIS, stored procedures).

· Strong problem-solving and metadata skills.

· Informatica or equivalent ETL tool experience a plus.

· Highly motivated, organized, detail oriented and a team player.

· Excellent communication skills.

· Prior experience with MicroStrategy or JDE EnterpriseOne a plus.

 

Education Requirements:

 

· Bachelor’s degree or equivalent

· 6+ years of hands on experience in IT

 

Wilbur-Ellis Company offers a competitive benefit package including health care, dental, vision, life and disability insurance, tax advantaged spending accounts, paid vacations, holidays, sick leave and a 401(k) plan. 

AA/EEOC

http://www.wilbur-ellis.com/