Job Seekers, Please send resumes to resumes@hireitpeople.comShort Description: The State of Iowa is looking for a developer to support lead generation loads for the Audit Component Case Management application.
Complete Description: This TS 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 toidentify 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.
The candidate will work with Teradata DBAs and other business staff toidentify 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.
Skill | Required / Desired | Amount | of Experience |
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 |