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.
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 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.
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 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 www.cgi.com.
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.
WE ARE AN EQUAL OPPORTUNITY EMPLOYER.
- Communication (Oral/Written)
CGI - 2 years ago
copy to clipboard
About CGI Group
CGI doesn't generate make-believe worlds, but rather real-life worldwide IT services. The company is the leading...