http://richmondsql.org/cs2007/search/SearchResults.aspx?o=DateDescending&tag=ssis,JobOpp&orTags=0Search results matching tags 'ssis' and 'JobOpp'en-USCommunityServer 2007.1 (Build: 20917.1142)http://richmondsql.org/cs2007/forums/p/110/146.aspx#146Wed, 30 Sep 2009 21:39:21 GMT2e8a3759-4cfd-4c9f-8103-2483fc393c1e:146andy<p><strong>ETL Programmer Analyst Team Lead</strong></p> <p>&nbsp;</p> <p>Candidates will contribute as an ETL team lead in the Data Management Group (DMG) responsible for design, development, and implementation of interfaces and conversions for the Medicaid Management Information System in Idaho. </p> <p>&nbsp;</p> <p>ETL team duties include requirements validation, code development, source control, unit testing, and version deployment scripting. SQL and stored procedure expertise in a RDBMS environment required, Microsoft SQL Server 2005 T-SQL desired. ETL development expertise with Microsoft SQL Server Integration Services desired. </p> <p>&nbsp;</p> <p>Team lead duties include working with a project manager to prioritize task assignments, progress tracking, and ensuring timely, yet accurate delivery, Mentorship acumen required. Full life cycle development experience required. Configuration and release management experience highly desired. Health information management experience highly desired. Excellent written and oral communication required. Some travel may be required (25% maximum).</p>http://richmondsql.org/cs2007/forums/p/109/145.aspx#145Wed, 30 Sep 2009 21:28:54 GMT2e8a3759-4cfd-4c9f-8103-2483fc393c1e:145andy<p><b>SSIS Developer</b></p> <p>&nbsp;</p> <p>-SSIS and SQL development as well as Maintenance and Support<br />-Maintains information policies and procedures to support current and future data information needs.<br />-Ensures proper data definitions, ownership, use and integrity of data.<br />-Facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.<br />-Establishes and maintains excellent knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues.<br />-Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.<br /><br /><br />Skills Required:<br />-STRONG SKILLS IN SSIS AND SQL are the most important!<br />-Knows ins and outs and techniques of SSIS and SQL<br />-Knows stored procedures, functions, and data modeling<br />-Someone who is an expert at process and will ask questions if design flaws exist<br />**Strong UNIT TESTING to unit test their work before it goes to Change management for system testing<br />-Extensive experience with SQL Server 2005 T-SQL and stored procedures required. (6 years)<br />-Experience with Microsoft SSIS required. (2 - 3 years)<br /><br />-Requires BA/BS in related field and 6-8 years experience in data analysis, data modeling, and working with automated data warehouse systems, or any combination of education and experience, which would provide an equivalent background.<br />-Experience with programming languages and various statistical programs in addition to general knowledge of major components of managed care operations required.<br />-Excellent analytical, problem-solving and PC skills required.<br />-Excellent oral and written communication skills required.<br /><br /><br />Preferred Skills:<br />-Experience with large Data Warehouses and Data Marts preferred.</p>