• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Roles and Responsibilities of ETL Developer in Data Stage

Roles and Responsibilities of ETL Developer in Data Stage

ETL Developer roles and responsibilities are:

-Understand Requirements.

-Prepare Questions.

-Logical design (flow chart)

-Physical design (coding)

-Unit test

-Performance Tuning

-Peer view – if it is ok , proceed to next step, if else start again from 3 step

-Design Turnover Document (DTD)/ Technical Design Document (TDD)/ Detailed Design Document (DDD)  — > produces job Report

-Back ups

-Job sequencing

General flow of an project:

Roles and Responsibilities of ETL Developer in Data Stage

 

 

Ware house modeling

– – >  Architecture

– – >  Dimensional modeling(schemas)

– – >  Dimensional characteristics

– – >  Fact characteristics

– – > for a developer if he is given by Document he need to , follow all the 10 rules and regulations.

Document

__ One Record for each Kindle (Multiple Records  for multiple address and Dummy Records for joint Accounts)

  • In an Banking sector , for each and every customer , he many have many accounts such as

 

Roles and Responsibilities of ETL Developer in Data Stage

 

– – >So, one record should be maintained for every customer

Desired to gain proficiency on DataStage?
Explore the blog post on DataStage training to become a pro in DataStage.

Format of Mapping Document 

Roles and Responsibilities of ETL Developer in Data Stage

 

– – > We have two formats of Mapping documents

  1. Word

  2. Excel sheet

– – > we many also get job templates as input for  designing jobs.

Format

 S NO  Load order Target entity Target Attribute SRC entity SRC Attribute TRF EH Cornet

 

S no Load order Target entity Target Attribute SRC entity SRC Attribute TRF EH Cornet


Example

EXP _ EMP à hire date à EMP

Dept Name à DNO àDEFT

First Name

Last Name

Middle Name.

– – >  from these  5 details an Mapping document is text prepared and given to the developer

Exp _ EMP :-

To find out the experience of an employee we need to  know the hire date  from the EMP table

So, EMP is one of the Source entity and its Source attributes will be ENO, ENAME, Hire date, DNO .

DEPT Name :-

To Know the Dept Name , We need to Know the DNO from DEPT table

So, DEPT is another Source Entity with DNO, DANME as Source attributes.

– – >first, last and Middle Names Will be taken from the EName of EMP Table.

– – > Now the Target Attribute , that we need to find out are, ENO, First Name ,Middle Name, Last Name, EXP_EMP, Dname

Target Entity or Target  Table Will be EXP_ EMP

Conventions:-

Set of rules to be followed

There are 4 types of conventions that are to be followed while naming :

-Job Naming

-Stage Naming

-Variable Naming

-Parameters Naming

For indepth understanding of DataStage Tutorials click on

Summary
Review Date
Reviewed Item
Roles and Responsibilities of ETL Developer in Data Stage
Author Rating
4

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Roles and Responsibilities of ETL Developer in Data Stage"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.