ETL Developer, MS SSIS

BI / ETL Developer role (SSIS) – must be highly technical with SSIS and optimization. Duties: • Design, develop, configure and document business intelligence systems and data warehouse. • Design and develop SSIS packages, stored procedures and ETL code • Develop database objects, stored procedures and packages, views, tables and triggers as needed • Converting data and tuning / optimizing code • Upgrade databases from SQL Server 2000 / 2008 to SQL Server 2012HA • Migrate DTS packages to SSIS Requirements: • Minimum 5 years BI / ETL solution development and Data Warehousing experience • Hands-on experience in technical ETL Development with SQL Server Integration Services (SSIS) • Technical experience with SQL Server 2005/2008 (SQL Server 2012 HA a plus) • Experience developing stored procedures with T-SQL • Expertise in query tuning, index creation, database optimization and troubleshooting • Experience in gathering and analyzing business requirements • Ability and experience producing technical documentation • Self-starter with the ability to work independently and in team environment 3 month contract to hire Citizen or Green Card Atria Group LLC