Job ID :
Company :
Location :
Type :
Duration :
6 Months
Status :
Openings :
Posted :
26 Feb 2014
Job Seekers, Please send resumes to


Position Description:

Direct responsibility for the design, maintenance, and support of Data Warehouse Systems.  The developer requires a high level of analytical and creative skills and an in-depth knowledge of database structure, data warehouse configuration, methodology, design, and modeling.  The developer’s typical duties includes but not limited to designing and building data warehouses,  designing ETL architectures and procedures,  performing analysis, SQL scripting,  tuning and optimization on very large (multi-terabyte) databases, managing capacity planning and performance analysis,  working with application developers to design and develop database objects and structures according to project specifications, addressing data quality issues with users, vendors and management,  analyzing organizational data requirements and creating logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin. Must be able to work with and within a cross-functional development, QA and production team.


Skills Required:

Advanced Teradata skills (e.g., SQL, FastExport, compression), minimum of 5 years experience
UNIX:  For development of Kornshell scripts to execute Teradata BTEQ & UNIX functions.  (Data transformations are   performed using SQL.)  
Connect Direct
ETL Ascential DataStage 
ZENA:  For development of processes & scheduling.
Software development lifecycle process and the requirement to generate supporting artifacts for each phase 
Experience in data warehousing/data mart environment
Experience in data profiling, data analysis, data quality checking
Verbal & written communication skills with both IT and business (who represent multiple levels within organization)
Ability to multi-task and work on multiple projects & prioritize correctly.


Skills Matrix:


Years of Experience

Last Used

Experience as ETL Developer



Experience in designing ETL Architecture



Experience in SQL programming



Experience in Teradata



Experience with FastExport



Experience with Compression



Experience with ZENA



Experience with Mainframe



Experience in data warehousing



Experience in data mart



Experience with Kornshell scripts



Experience with ETL Ascential DataStage



Experience with BTEQ