ETL Developer / Architect : ETL, Oracle, SQL, PL/SQL, UNIX shell scripts, Informatica : Boston, MA
10/12/2016 2:53:57 AM
ETL Developer / Architect
Responsibilities - As a part of the Data Warehouse / Business Intelligence Team, implement technology improvements to Grand Circle's Enterprise Data Warehouse environment - Implement and enhance ETL programs using Informatica Power Center and Informatica Power Exchange 9.1 against the Oracle 11g Data Warehouse - Contribute to technical architectural planning, data modeling, process flow documentation and the design and development of innovative solutions for the business - Create technical designs and mapping specifications - Develop and test extraction, transformation, and load ETL processes. - 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 both technical staff and business constituents to translate business requirements into technical solutions - Perform unit and system test/validation tasks - Estimate workload and participate in an Agile BI project team approach - Maintain technical and user documentation - Provide on-call support of the Data Warehouse nightly processing - Be an active participant in both technology and business initiatives
- At least 5 years' experience supporting Data Warehouse environments and 10 years working in IT - Advanced experience required in Informatica Power Center, Informatica Power Exchange - Advanced Oracle database skills including PL/SQL, packages, procedures, indexing and query tuning - Solid understanding of Data Warehouse design theory including dimensional data modeling - Experience writing and executing UNIX shell scripts - Proven individual contributor and team player with high communication skills - Provide coverage for off-hour support, approximately once every three weeks - Ability to thrive in change by having a fast, flexible, cooperative work style and ability to reprioritize at a moment's notice. - Bachelors degree required.