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.
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
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.
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:
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:
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.
See Essential Skills Required.
College degree plus 5 or more years IT experience
Multivision - 17 months ago