Hello!!!
Title: Teradata Data Modeler for Mortgage Data Warehouse Location: Dallas, TX Contract Length 6 months Teradata Data Modeler for Mortgage Data Warehouse This position is for a senior level database administrator, preferably Teradata administrator, who is responsible for design, development and administration of large scale (500Gb - 2TB in size) analytical & transactional data structures on various databases like Teradata, SQLServer, DB2 and Oracle. Included within those responsibilities are the areas of data access and delivery technologies. Duties include but not limited to: Logical data modeling, physical database design, implementation and testing of large scale database structures Map business requirements into system requirements Performance monitoring and tuning including SQL optimization and tuning Shell and Batch scripting Software installs and upgrades Experience: 5+ years of relevant work experience Financial Services Experience Good understanding and hands on experience in logical data modeling and data warehouse concepts In-depth experience in deriving optimized physical data models from the logical data model provided In-depth experience in security administration using roles and profiles mechanism Hands on experience on performance tuning of complex SQLs In-depth knowledge of Teradata utilities such as Multiload, Fastexport, BTEQ, Fastload and TPump Solid understanding of Teradata client tools such as SQLAssistant, Performance Monitor, Teradata Manager and Teradata Administrator Hands on experience in using MSSQLServer, Oracle and DB2 databases Hands on experience in using MS Office products and Windows XP or higher version of OS Solid verbal and written communication skills Teradata Certification is a must and any other DB certifications might add value Familiarity with ETL tools like Ab Initio, DataStage, Informatica Financial domain experience is a plus but not necessarily required Ability to work independently and communicate across multiple levels (Product owners, Executive sponsors, Team members) Work experience in Agile methodology is a plus Thank you for your time and have a great day! John Victor Business Development Manager Aim Computer Consulting N. Laurel Park Drive, Suite #513, Livonia, MI 48152 Tel: (734) 591-3562 Ext: 169 Fax: (734) 418-2603 <mailto:jvic...@aim-cc.com> jvic...@aim-cc.com