ETL Developer, MS SSIS
AtriaGroupLLC
Posted: April 15, 2013
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
Atria Group LLC is seeking an experienced ETL Developer with expertise in MS SSIS to design, develop, and document business intelligence systems and data warehouse, with a focus on optimization and database tuning.
Required Skills
Job Description
Atria Group LLC
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