Hi I hope you are doing well. I am sending the new requirement, please go through it and let me know if you are comfortable.
*Need = Teradata Consultant Location = Des Moines, IowaDuration = 12+ months* Interview Type: * In Person Only.* *Required:* Convert business requirements into Teradata solutions utilizing *SQL and other Teradata Tools (BTEQ, MultiLoad, FastLoad, Teradata SQL and FastExport*): 5 Ability to write *complex SQL queries*: 5 Create ad hoc reports as requested: 5 Troubleshoot and modify failed code and scripts, so they work correctly and efficiently: 5 Analyze, design, code, test, and document new and existing code to meet specifications and programming standards: 3 Analyze and administer system management processes including availability, storage management, capacity planning, system performance: 3 Highly desired: *Z/OS Mainframe (ISPF, TSO, JCL): 2* *Business Objects coordinating up to 80 different universe options*: 2 *Certified Teradata SQL Expert preferred (version 14.0 or greater): 2*Preference will be given to candidates who demonstrate *knowledge of tax compliance program development:* 2 *Oracle 11g or higher knowledge* - backup and recovery understanding, patch maintenance, security setup (user ids and group ids) and ability to define O: 2 *Description:* The person will also provide support for business intelligence application Business Objects which provides reports for the compliance, collections, and data processing divisions. Will report to Tax Gap Program Manager and work with Teradata Data Base Administrator and other staff. The specialist will implement enhancement programming for Teradata Data Warehouse applications utilizing stored procedures, SQL and Teradata Utilities including BTEQ, MultiLoad, FastLoad, Teradata SQL, and FastExport. Design, implement and test programs specified by the Tax Gap Program Manager for reporting requirements. Create scripts to extract and load data to and from Teradata version 14.0. Using utilities or application code, create ad hoc reports as requested. Recreate lost reports, files, or data as needed. Review monthly processes to automate, where practical. Coordinate and perform system development, programming, implementation, and maintenance activities. Analyze and administer system management processes including availability, storage management, capacity planning, system performance, data modeling, and system security. Analyze agency operations and procedures and determine feasibility for automation and prepare workflow timelines. Prepare systems documentation and develop program code. Analyze, develop, test, and document best practices for planning, designing, and adding new databases, as well as developing the procedures to link new data to other existing databases. Troubleshoot and modify failed code and scripts so they work correctly and efficiently. Provide technical direction and coordinate with management throughout projects. Generate proposals for modifications, including preliminary plans and recommendations of application and development software. Direct the presentation, discussion, and explanation of all technical aspects of the proposed projects to management and customers, providing specific purpose, operation, implementation, and maintenance objectives. Work with management to determine internal resource requirements for projects. Participate as an team member and follow all self-directed work team principles. Applicant must possess a working solid knowledge of Teradata Utilities including ETL tools and complex SQL. Additionally, preference will be given to applicants who possess a working knowledge of Business Objects, and IBM Mainframe environment (ISPF, TSO, JCL), and who demonstrate the ability to quickly learn and apply these skills. The successful applicant will be expected to work with a variety of databases that have a high level of complexity. Good communication and organization skills necessary. -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Thanks&Regards James Miller | IT Recruiter ITBrainiac Inc, Princeton, NJ 08540 Direct: (609-935-3773)*101 | Fax 312.582.2699 Website:www.itbrainiac. Yahoo :james.usrecruiter Gtalk :james.usrecruiter Email : [email protected] Notice: This email contains confidential or proprietary information which may be legally privileged. It is intended only for the named recipient (s). If an.addressing or transmission error has misdirected the email, please notify the author by replying to this message. If you are not the named recipient, youare not authorized to use, disclose, distribute, copy, print or reply on this email, and should immediately delete it from your computer system list
