Direct client requirement: Teradata Developer

Direct client requirement: Teradata Developer

Location is Dayton, OH, duration is 6 months CTH, it’s a direct client requirement. 

Two basic conditions to become a CareSource employee: (1) Legal resident or US Citizen and (2) Non-smoker.

Below are two descriptions, and you need a little bit of both.  The underlying requirements is experience and a proven track record with exceptional references  doing this in a Teradata environment, and knowledge/expertise with Teradata SQL, TPT, Tools and utilities.

ECTL Designer

The ECTL designed specializes in designing the processes and integration of these processes for extract, cleanse, transform, and load.  Must have the ability to understand the overall requirements and integrate them into the design.  This individual may have design skills in one particular area, such as designing the extract of data from the source system, or may be proficient in designing the load routine, or may have the skills to design all areas of ECTL.  In cases where an ECTL tool is used, must be knowledgeable in these tools to match the design with the features the tool has to offer.

The designer provides efficient design and construction of systems and subsystems to extract, condition, and load data from operational systems and other sources into a defined physical data model according to business and technical requirements.  The ECTL designer also provides thought-leadership in the selection and implementation of data transformation tools required to satisfy business and technical requirements.  The job may also provide input to the database designer to optimize the data loading of the physical database.

This person is charged with all the design efforts that concern the extraction of data from the source systems and any data conditioning performed on the host.  This is a very technical effort and is heavily involved in the project as soon as data mapping is complete and stays involved, but to a lesser degree, to the end of the project.  This person could also be very useful in the planning phase of the project, contributing expertise to the evaluation of the best alternatives for ECTL based on expected row counts, file sizes, and other source data parameters.

Responsibilities include:

- Interface with system stewards to gather requirements.

- Define data element requirements, including history, timeliness, and frequency of data.

- Define volume and timing requirements.

- Design the ECTL interface including technology choices.

- Define server process requirements.

ECTL Developer

This individual specializes in building the applications as specified by the designer in the design documents.  This individual must have the skills necessary to implement the design and in the specific tools that will be used to build the ECTL applications.  These individuals may have specific skills, such as Oracle utilities to extract data from source, or in Teradata utilities, such as FastLoad, MultiLoad, and Tpump.  They may also be required to be proficient in vendor tools, such as Trillium, Ab Initio, Genio, or Informatica.  They must be able to understand and interpret the design for building the applications for execution.  This is a highly technical role and may be involved in the project as soon as data mapping is complete and stays involved to the end of the project.

Responsibilities include:

- 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 data into a data warehouse.

- Design, develop, and test processes for loading cyclical data into a data warehouse.

- Participate in performance, integration, and system testing.

- Document modules designed and developed.

- Interface with application designer, project manager, and database analyst.

- Use code generators.

- Use system utilities.

- Use extraction tools.

- Develop host data manipulation applications.

- Develop code to condition data while it is being extracted.

- Code for conversion of type, format, and length.

- Code for field concatenation.

- Utilize substring functions.

- Convert business rules imbedded in host application programs.

- Match/merge utilities.

- Check for referential integrity.

- Develop code to create files that can be used with load scripts to load the target database.

- Analyze load file format required