Wednesday, June 01, 2011

ETL Architect - (US-OH-Columbus)


ETL Architect - (US-OH-Columbus)

Compensation: 
$110K - $120K / Year
Minimum Education: 
Bachelors
Job Type: 
Full Time
Jobcode: 
CBTJA43

1. Define ETL architecture for loading data from source to warehouse 
2. Interact with business/data architects to gather the tranformation logic 
3. Develop the High Level and Detailed Design documents for the ETL process 
4. Work with ETL Development to clearly communicate ETL Architecture strategy and closely monitor implementation of ETL Architecture and Strategy based on expectations 
5. Perform Data analysis/data profiling 
6. Implement the best practice for ETL development process 

KNOWLEDGE, SKILLS AND ABILITIES REQUIRED TO PERFORM ESSENTIAL FUNCTIONS 

1. 10 or more years - Overall IT experience. 
2. 5 or more years of experience with Informatica and Teradata. 
3. Strong in SQL 
4. Strong working knowledge of MPP database architecture 
5. Experience in ETL designing for Terabyte sized systems. 
6. Full software development life cycle experience and understanding. 
7. Excellent team working and communication skills. 
8. Strong understanding of the performance tuning approach for the ETL process 
9. Teradata certification is plus 
10. Working knowledge of BTEQ/MLOAD/FLOAD/TPUMP is plus 

REQUIREMENTS 
• Bachelor's degree in computer science, or equivalent; Master's degree is preferred. 
· Experience in Banking and Financial domain is plus 


Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume. 

NO RELOCATION.NO OVERSEAS RESUMES. NO 3RD PARTIES. 

To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe. Receive tweets from Twitter with job search tips – TheBigGameHuntr AND become a fan on Facebook http://goo.gl/Argw