Job Code :
CDO Technologies Inc
Dayton Ohio US
Job Type :
Career Level :
Job Description :
The ETL Consultant specializes in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. This individual must have the skills necessary to understand the overall data warehouse architecture. The ETL Consultant designs and builds the ETL environment with the specific toolset required by the client. The ETL Consultant may also provide input to the database designer to optimize the data loading of the physical database. The ETL Consultant may be the Lead Consultant on a project.
Job Requirements :
Key Areas of Responsibility · Capture ETL Requirements. · Design, develop, and test processes for extracting data from legacy systems or production databases. · Design, develop, and test processes for validating and conditioning data prior to loading into a data warehouse. · Design, develop, and test processes for loading initial and cyclical data into a data warehouse. · Design the processes to meet service level agreements for data timeliness and frequency. · Determine which data elements are historic and the retention period for historic data. · Determine data growth trends and peak business periods. Skills · Knowledge/experience with ETL tools. · Prior ETL experience. · Knowledge and expereince with Informatica. Preferred: · Teradata Experience
To submit your resume for this job, select how you heard about the job and then click the "Submit Your Resume" button below.
(NOTE: You need to have an account created in order to refer someone. Clicking this button will ask you to log in. If you are a returning user, log in to refer the person. If you are a new user, please create a Resume Profile first.)