please reply to *d...@osairtech.com* *EDW Teradata Architect *
*Teradata* *Enterprise Data Warehouse (EDW) Architect* Location: New York, NY Duration: 3 months plus Total Exp.: 7 - 10+ Years *Relevant Exp.: 7+ Years * *Must have:* Excellent customer interface skills and requirements capture. *Modeling experience in ERWIN 7.1 or higher.* Ability to consult with organizations in the *initial design stages of projects to design systems and data models Strong data modeling concepts and architecture experience *Ability to review and analyze existing *Teradata SQL and load processe*s, identifying improvement opportunities, indexes, partitioning strategies, etc., and make recommendations to improve the processes, schema, SQL, load scripts and processes, etc. Then work with the process owners to implement the changes and document the improvements. *Must be familiar with Teradata tools including Teradata Manager, Loader Utilities: TPT, BTEQ, MLOAD, FLOAD, etc. Good understanding of Teradata architecture* *Advanced level SQL skills* Experience writing/understanding *UNIX shell scripts*. Excellent *physical database design, implementation, and support skills Strong verbal and written communication skills. Strong consulting and analytical skills. Good interpersonal skills. * *Responsibilities: *Analyzing requirements with Business partners Data analysis, design logical data models and physical database schemas Create database objects for tables, users, roles, profiles, grants, etc. Add columns, build indexes, and analyze indexes. Design and implement MLPPI strategies Stats and index analysis Performance tuning Design and monitor alerts, database parameters, and performance metrics Performs capacity and scalability planning. Identify innovative, cost effective ways to implement and support physical databases technologies. Troubleshoot and resolve database, load and reporting issues. *Good to have: *Teradata DBA skills 5+ years hands-on experience with ETL tools preferably Informatica 5+ years hands-on experience with reporting tools like SAP Business Objects, MicroStrategy, etc. Dev Technical Recruiter Osair Technologies LLC, 36 York Road, West windsor,NJ | 08540-3512 Voice : 630-566-7324 | Fax :732-289-6076 d...@osairtech.com | www.osairtech.com Yahoo IM: dev.osair | Gtalk: dev.os...@gmail.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to us_itgroups@googlegroups.com. To unsubscribe from this group, send email to us_itgroups+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/us_itgroups?hl=en.