The Role
Design, develop, and optimize ETL processes and data warehouse solutions using SSIS. Convert/migrate DTS packages, build T‑SQL stored procedures, tune queries and indexes, upgrade SQL Server instances, and produce technical documentation while gathering business requirements.
Summary Generated by Built In
Company Description
Atria Group LLC
Job DescriptionBI / 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
Skills Required
- 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
- Experience with SQL Server 2012 HA
- Experience developing stored procedures with T-SQL
- Expertise in query tuning, index creation, database optimization and troubleshooting
- Experience gathering and analyzing business requirements
- Ability and experience producing technical documentation
- Experience migrating DTS packages to SSIS and upgrading SQL Server instances
- Must be US Citizen or Green Card holder
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.
