*Hi,*
Client: State of Iowa *Position: MS SQL SSIS Packages Analyst* Location: Des Moines, IA Duration: 10+ months. Extendable up to 3 years Start: ASAP Interview: Phone *Short Description: * This position will be a member of a team but will need to work independently. They will report to a Senior Architect/DBA but will require self-direction. Job responsibilities will span ETL development, data transformation and modeling. * * *Complete Description: * This position has the potential to extend for three 1- year extensions. Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. The candidate will be responsible for taking the project through the entire SDLC, working with the business users to determine the business requirements and apply the business rules to the data. This candidate should be an expert in creating, modifying and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend. Advanced skills in writing complex Structured Query Language (SQL) queries are required. Experience working with a large variety of data, demographic, personal, numeric data and identify normal ranges, outlier data, typical and non-typical data results. ETL developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems. • Proficient in development of *SQL Server Integration Services (SSIS) packages*. • Proficient using *MS SQL 2005 or later and writing relational database queries and stored procedures using SQL*. • Experience *extracting data from a large variety of sources, transforming and loading to a SQL data warehouse*. • Evaluate and address data quality issues. • Developing error checking and resolution routines. • Experience in interacting with customers regarding application requirements. • Strong business writing and interpersonal skills necessary for customer contact. * * *Required /Desired:* *Skill* *Required /Desired* *Amount of Experience* Develop, modify and optimize SSIS packages Required 5 Years SQL 2005 Required 5 Years SQL 2008 Required 3 Years Experience building SSIS packages using built-in SSIS components Required 5 Years Experience writing complex T-SQL Required 5 Years Experience analyzing, profiling, manipulating data from a large variety of sources Required 5 Years Experience loading data into a SQL Data Warehouse Required 5 Years Troubleshoot abstract data, profile, analyze and optimize data Required 5 Years Develop error checking and resolution routines Required 5 Years Data modeling experience Required 5 Years Analyze and optimize table design Required 5 Years Ability to work with end users to extract business requirements Required 5 Years Ability to analyze data and apply business rules and requirements Required 5 Years Agile project experience Highly desired *Thanks & Best Regards* *V**INNI **| Oberon IT*** 1300 W. Walnut Hill Lane,Suite:263, Irving, TX 75038 *Email *-*[email protected]* *Office:*972-330-4350 ; *EXT.NO* 314; *Fax:*1-800-218-2820 -- You received this message because you are subscribed to the Google Groups "as400placements1" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send an email to [email protected]. Visit this group at http://groups.google.com/group/hrccpl?hl=en-GB. For more options, visit https://groups.google.com/groups/opt_out.
