ETL Developer, MS SSIS

Atria Group · Fort Worth, TX, us · 13 years ago

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

Explore more jobs