ETL Developer, MS SSIS

Atria Group LLC; Fort Worth (TX); On-site; USD 80,000 - 120,000; Full time

Job summary

Atria Group LLC is seeking an experienced BI / ETL Developer to design and develop business intelligence solutions using SSIS. The role requires minimum 5 years of expertise in ETL development, database optimization, and strong technical skills to document and tune systems effectively. The ideal candidate should be a self-starter capable of working independently and collaboratively.

Qualifications

• Minimum 5 years in BI/ETL solutions and Data Warehousing.
• Hands-on experience with SQL Server Integration Services (SSIS).
• Experience with SQL Server 2005/2008, stored procedures, and query tuning.

Responsibilities

• Design and develop business intelligence systems and data warehouses.
• Create SSIS packages, stored procedures, and ETL code.
• Migrate DTS packages to SSIS and upgrade databases.

Skills

Data Warehousing

ETL Development

SSIS

T-SQL

Database Optimization

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