I have a very urgent DIRECT CLIENT requirement for SQL Programmer w/Teradat in* *Des Moines, IA*.P*lease Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number.
Please send the resumes at r...@cncconsulting.com <alb...@cncconsulting.com> Job Title: SQL Programmer w/Teradata Location: Des Moines, IA Duration: 6 months Note: GC/Citz only Implement enhancement programming for Teradata Data Warehouse applications utilizing stored procedures, SQL and Teradata Utilities. Design, implement and test programs specified by Business Analysts and reporting requirements. Create scripts to extract and load data to and from Teradata platform. Assist the data warehouse Business Analysts and other staff with the utilization and implementation of Business Objects universes and reports. 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 Justice Data Warehouse (JDW) management and customers, providing specific purpose, operation, implementation, and maintenance objectives. Work with JDW management to determine internal resource requirements for projects. Participate as a JDW team member and follow all self directed work team principles. Using report generation tools, utilities, or application code, create ad hoc reports as requested by senior staff or customers. 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 agency databases, as well as developing the procedures to link new data to other existing databases on JDW. Work in conjunction with CJJP administrative and senior staff to enhance JDW capabilities. Troubleshoot and modify failed code and scripts so they work correctly and efficiently. As an agency expert, provide technical expertise and direction to management and staff on how JDW could be utilized for emerging data needs. Applicant must possess a working solid knowledge of complex SQL. Additionally, preference will be given to applicants who possess a working knowledge of Teradata Utilities, Business Objects, and ETL skills and tools or 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. Skill Required / Desired Amount of Experience Expertise Rating Ability to write complex SQL queries Required 5 Years Load source data from Oracle or SQL, apply business rules, manipulate and load into Teradata Required 5 Years Responsible for developing and testing the most complex and involved applications that will enhance and supplementing the data warehouse reporting Required 5 Years Analyze, develop, test and document best practices for planning, designing and adding new agency databases Required 5 Years Develop procedures to link new data to other existing databases Required 5 Years Research, write, test and design multi-agency databases and stored procedures to support a system-wide response to business requirements Required 5 Years Create ad hoc reports as requested Required 5 Years Analyze and administer system management processes including availability, storage management, capacity planning, system performance Required 3 Years Troubleshoot and modify failed code and scripts, so they work correctly and efficiently Required 5 Years Analyze, design, code, test, and document new and existing code to meet specifications and programming standards Required 5 Years Business Objects Highly desired 2 Years Teradata Utilities Highly desired 2 Years Working knowledge of the criminal or juvenile justice Desired 1 Years Familiarity with Windows server Desired 1 Years Thanks, Raj Chouhan 720-789-5728 Phone r...@cncconsulting.com <alb...@cncconsulting.com> -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/groups/opt_out.
