Short 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 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. 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