ETL Developer, MS SSIS

Company Description Atria Group LLC

Job Description

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 Additional Information
• 3 month contract to hire
• Citizen or Green Card