Need US Citizen or GC only.*- Direct Client *
*Immediate Interview and Start ASAP!!!*



*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> *

Job Title: SQL Developer
Location: Des Moines, IA
Duration: 3+ months
Direct Client Position
Need US Citizen or GC only.
Rate: $55/hr on C2C

Implement enhancement programming for 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 data warehouse
platform.  Assist the data warehouse Business Analysts and other staff with
the utilization and implementation of Business Objects universes and
reports.

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.

Provide technical direction and coordinate with management throughout
projects.  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.  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.

Skills required:
1. Working knowledge of SQL to create, edit and troubleshoot large, complex
queries, views and stored procedures
2. Planning, building, editing and troubleshooting of Windows batch script
(.bat and .cmd) files
3. Light Windows server administration, primarily creating and maintaining
schedules that run the script files
4. Excellent oral and written communication, and be self-motivated

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.

Ability to write complex SQL queries Required 5 Years
Load source data from Oracle or SQL, apply business rules, manipulate and
load into data warehouse 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 3 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 3 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 Nice to have 2 Years
Teradata Utilities Nice to have 2 Years
Working knowledge of the criminal or juvenile justice  Desired 1 Years
Familiarity with Windows server, task scheduling, and batch file scripting
Desired 1 Years

*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> *

Thanks,
Sam
CNC Consulting, Inc.
201-546-3096
s...@cncconsulting.com

-- 
You received this message because you are subscribed to the Google Groups "Open 
Source Erp & Crm" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to open-source-erp-crm+unsubscr...@googlegroups.com.
To post to this group, send email to open-source-erp-crm@googlegroups.com.
Visit this group at http://groups.google.com/group/open-source-erp-crm.
For more options, visit https://groups.google.com/d/optout.

Reply via email to