ETL Developer Job
CGI - Burlington, VT

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

Job Order: J0113-0960 - Permanent Full Time
Title: ETL Developer
Category: Information Technology
City: Burlington, Vermont, United States

Job Description: ETL Developer

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 target 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:


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.
Hardware/Software Packages

See Essential Skills Required.

College degree plus 5 or more years IT experience At CGI, we're a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in more than 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.

We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted.

No unsolicited agency referrals please.


- Communication (Oral/Written)
- Detail-oriented
- Java
- JavaScript

Reference: 233936

CGI - 2 years ago - save job - copy to clipboard
About this company
426 reviews
About CGI Group CGI doesn't generate make-believe worlds, but rather real-life worldwide IT services. The company is the leading...