SSIS Developer

@ Long Finch Technologies
Long Finch Technologieslongfinchtechnologies.com

SSIS Developer

Carrollton, Texas
Posted 1 day ago

About the job

We focus on data integration and ETL solutions, helping businesses manage complex data processes. The SSIS Developer role involves creating and supporting SSIS packages, SQL queries, and data validation in a collaborative environment.

Requirements

  • 5+ years SQL and SSIS experience
  • Complex SQL query writing
  • SSIS package development
  • ETL and data integration
  • Data validation and troubleshooting

Qualifications

  • Bachelor's degree in relevant field
  • Strong analytical and problem-solving skills
  • Good communication skills

Full job description

We are looking for an experienced SSIS Developer with strong hands-on expertise in SQL, SSIS, ETL, and data integration. The ideal candidate will have experience developing and supporting SSIS packages, complex SQL queries, stored procedures, data validation, exception handling, and reconciliation reporting.

Required Skills

  • 5+ years of hands-on experience with SQL and SSIS.
  • Strong experience writing complex SQL queries and stored procedures.
  • Solid experience in SSIS package development, execution, and troubleshooting.
  • Experience with ETL processes, data integration, and data analysis.
  • Strong understanding of data quality checks, validation rules, and exception handling.
  • Experience with data reconciliation and reporting.
  • Bachelor's degree in Business, Information Technology, Computer Science, or a related field.
  • Strong analytical, problem-solving, and communication skills.

Roles & Responsibilities

  • Design, develop, test, deploy, and maintain SSIS packages and ETL solutions.
  • Develop complex SQL queries, stored procedures, and data transformation processes.
  • Implement data quality checks, validation rules, exception management, and reconciliation processes.
  • Evaluate business processes and identify opportunities for improvement and automation.
  • Troubleshoot and optimize existing SSIS packages and ETL workflows.
  • Perform data validation and support User Acceptance Testing (UAT).
  • Develop and maintain technical documentation and operational procedures.
  • Collaborate with business and technical teams to understand requirements and deliver effective solutions.
  • Monitor project deliverables and ensure timely completion.
  • Stay current with modern data integration and IT practices to improve existing processes.
Show full description