*Role: SQL/SSIS Developer Duration: 3 Months with the option to renew* *Location: Des Moines, IA*
*Interview*: In Person Only Senior level Database Administrator may work with more than one database architecture or have deep knowledge in a specific application database or set of databases to support architectural or decision support activities: *SQL/SSIS Developer* The State of Iowa is seeking an ETL Developer with extensive experience with SQL and SSIS. The ideal candidate will have the ability to troubleshoot and problem-solve with a strong sense of urgency. This person should be a self-starter, able to work both independently and cooperatively as required. The successful developer must be able to understand business requirements, data and concepts. State government experience is a definite plus. *Responsibilities:* • Refine business requirements into technical requirements and specifications • Design and develop SSIS packages, database objects, tables, stored procedures and views • Performance tuning the stored procedures and T-SQL. • Communicate accurate and useful status updates • Manage and report time spent on all work activities *Qualifications:* *Description:* Solid experience with Microsoft SQL Server 2008 R2 and above Developing packages with SSIS Strong knowledge of XML, schemas T-SQL language (queries, views, procedures) SQL Reporting Services Strong analytical/mathematical and reasoning skills. Ability to work in a team environment Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision Strong written and verbal communication skills Large-scale data migration experience Data warehousing concepts Agile Methodology Understanding of RDBMS and Data Warehouse designs SQL Server database troubleshooting and query optimization SQL Server Database Design SQL Server Stored Procedure Design and implementation *Screening Questions:* 1. How do you query XML data in SQL Server 2. What are different types of containers in SSIS? 3. How do you deploy SSIS packages or SQL Server. 4. In T-SQL, What is the difference between an inner and outer join? *Regards,* *Amit Kumar* *IDC Technologies, Inc Work: 408-668-8348 <(408)%20668-8348> Mailto: ami...@idctechnologies.com <ami...@idctechnologies.com> Hangout: recruiter.am...@gmail.com <recruiter.am...@gmail.com> _____________________________________* *Empowering Technologies Services* *Remote Services | IT Services | BPO | * *IT Consulting | Staffing Solutions |* *_____________________________________* *The views and opinions included in this email belong to their author and do not necessarily mirror the views and opinions of the company. Our employees are obliged not to make any defamatory clauses, infringe, or authorize infringement of any legal right. Therefore, the company will not take any liability for such statements included in emails. This message is sent in compliance with the new email bill section 301. Under Bill S.1618 TITLE III passed by the 105th US Congress, this message cannot be considered SPAM as long as we include the way to be removed, Paragraph (a)(c) of S.1618, further transmissions to you by the sender of this email may be stopped at no cost to you by sending a response of “REMOVE” in the subject line of the email, we really will remove you with immediate effect.* -- You received this message because you are subscribed to the Google Groups "IT RECURITER" group. To unsubscribe from this group and stop receiving emails from it, send an email to it-recuriter+unsubscr...@googlegroups.com. To post to this group, send email to it-recuriter@googlegroups.com. Visit this group at https://groups.google.com/group/it-recuriter. For more options, visit https://groups.google.com/d/optout.