ETL ARCHITECT Job Listing at Harbor Freight Tools in Calabasas, CA (Job ID 1326828)

Description

Establish, manage, and utilize tools to
monitor the success/failure of the data warehouse. Review the referential
and historical integrity of data warehouse information. Develop software
using Informatica PowerCenter to create initial ETL load routines and
establish standard and templates of large or architecturally significant
applications. Create design pattern templates for deliverable objects.
Define and implement ETL development standards and procedures. Define
and implement ETL tool configuration. Ensure effective ETL functional
decomposition into deliverable objects. Display a deep understanding of
relational database design concepts and SQL programming. Build
partnerships across the application, business, and infrastructure teams.
Collaborate with developers and business users to gather required data and
determine the big-picture view of the company's needs and requirements.
Adhere to standard SDLC procedures and ensure the creation of
appropriate documentation. Telecommuting is permitted.

Requirements

Bachelor of Science or Technology in Computer Science, Information
Technology, Engineering, Civil Engineering, or a related field of study.

Seven (7) years of experience in the position offered or as an Informatica
Integration Specialist, Senior Informatica Integration Specialist, Technology
Analyst, Senior Associate – Projects, or a related ETL Developer.

Seven (7) years of experience developing, administering, optimizing and
maintaining large enterprise class Data Warehouse projects and performing
ETL implementations. Five (5) years of experience with all of the following:
Informatica PowerCenter, data warehouse and database design and
development, SQL/PL and SQL programming, Windows batch scripting,
ETL Data transformation, Data modeling and Data Aggregation
technologies, Data Warehouse and Data Mart physical RDBMS schemata,
data virtualization tools, and WSDL and XSD web services design and
development. Telecommuting is permitted.
corporate corporate corporate