Innovations technological

Hi

Please let me know your interest for this position

Reply back with expected hourly rate

Interview Mode-In Person Only  

Location: Des Moines, IA

Duration: 12+ months

Rate: Open

Job Description

This position will be joining our database support team and require a data warehouse skill set, utilizing stored procedures, SQL and Teradata Utilities.

The candidate will work with Teradata DBAs and other business staff to

identify required data elements for use in targeted systems.

Responsibilities

·         Utilize business requirements to perform impact analysis and convert to detailed designs

·         Code, test and deploy stored procedures to load data to the warehouse and various marts

·         Apply user access/roles as specified by business requirements

·         Assist with use cases, test cases and system documentation for assigned projects

·         Troubleshoot and resolve SQL errors and performance problems

·         Follow best practices for Teradata deployments

·         Write queries to facilitate management analysts needs for testing and research

·         Communicate accurate and useful status updates

·         Manage and report time spent on all work activities

Skills Needed

Data Warehousing concepts and project experience                        Required         5 Years

Strong analytical/mathematical and reasoning skills            Required         5 Years

Expertise in SQL programming (views/store procedures/macros/functions), based on business requirements and architectural guidelines and standards          Required         5 Years

Strong Teradata SQL expertise is a must (familiarity with SQL Assistant)    Required         5 Years

Knowledge of Teradata Stored Procedure/Macro     Required         5 Years

Teradata load utilities: BTEQ, FastLoad, MultiLoad, OleLoad           Required         5 Years

Developing packages with SQL Server Integration Services (SSIS)    Required         5 Years

Working knowledge of Entity Relationship Models   Required         5 Years

Proficiency with Teradata concepts and logical/physical database design   Required         5 Months

Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision      Required         5 Years

Strong written and verbal communication skills        Required         5 Years

Ability to work in a team environment          Required         5 Years

Preference will be given to candidates who demonstrate knowledge of tax compliance program development            Highly desired

Agile Experience         Desired

Thanks
Archit
 
Archit Jain
Software People Inc.
archit.jain@softwarepeople.us
Ph: 631-739-8782 © Fax: 631-574-3122
Gtalk: ajain0102

Certifications: NY MWBE, VA SWaM, DE OMWBE, MA MWBE