ETL Developer
Multivision - Burlington, VT

This job posting is no longer available on Multivision. Find similar jobs: ETL Developer jobs - Multivision jobs

The ETL Developer will focus on ETL design, development and support. Responsible for ETL processes and tools as well as database loading and manipulation to ensure that the data needs are met throughout the course of the projects and production support. Understands business problems and opportunities in the context of the requirements and recommends solutions that enable the organization to achieve its goals. Interprets and transforms information based on business requirements and provides the data for delivery. Conducts detailed research of vendor products and assists with general project management.

Essential Functions:

Strategy & Planning

Collaborate with business users/developers to provide required data

Research and provide alternatives and recommendations based on best practices and application functionality

Understands the business processes, how the application supports the business processes and applies this knowledge to best solve problems

Acquisition & Deployment

Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts

Assist with design and implementation of data warehouses, planning applications and reporting solutions

Gains necessary input/approval of requirements and design and participates in code reviews and may perform code review for others

Assists in requirements gathering and creates system and user documentation

Operational Management

Develop solutions to leverage ETL tools and suggest process improvements.

Conduct root cause analysis and resolve production problems and data issues.

Validate the data in the database and also responsible for testing the routines developed.

Lead user sessions for requirements gathering and testing.

Provide ongoing maintenance and support of assigned ETL flows and their Client applications

Assist users with problems and resolves issues independently.

Create test plans, test cases, test scripts and performs functional testing.

Create and maintain system documentation.

Work with existing systems to track and manage requests and issues.

Provide business reports to management and clients.

Incidental Functions

Assist with projects as may be required to contribute to efficiency and effectiveness of the work.

Up to 25% travel as required.

ESSENTIAL SKILLS REQUIRED:
5+ years IT experience.

Experience with one or more of the following ETL Tools, or equivalent:

Informatica

Oracle Data Integrator (ODI)

Oracle Warehouse Builder (OWB)

High level of proficiency in advanced query development and design with one or more of the following:

SQL

MDX

XQuery

XML/A

Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems.

Advanced knowledge in Shell and PERL scripting in Unix/Linux environment.

Strong understanding of relational and dimensional data models.

Working knowledge of software development and support methodologies.

NONESSENTIAL SKILLS DESIRED (including team oriented, managerial skills, etc.)

See Essential Skills Required.

HARDWARE/SOFTWARE PACKAGES

See Essential Skills Required.

EDUCATION REQUIREMENTS

College degree plus 5 or more years IT experience

Multivision - 17 months ago - save job - block
Recommended Jobs
MS BI Junior Developer, Burlington, VT, $65K-...
Nigel Frank International Limited - Burlington, VT
Nigel Frank International Limited - 9 days ago

Business Intelligence Analyst
Dealer.com - Burlington, VT
Dealer.com - 30+ days ago

Software Engineers
iTech US, Inc. - South Burlington, VT
Dice - 7 days ago