SSIS Developer

@ Long Finch Technologies
Long Finch Technologieslongfinchtechnologies.com

SSIS Developer

Sachse, Texas
Posted 1 day ago

About the job

Our company specializes in data solutions, focusing on ETL, data integration, and reporting. The role involves developing SSIS packages, SQL queries, and supporting data processes to ensure data quality and efficiency.

Requirements

  • 5+ years experience with SQL and SSIS
  • Strong SQL query writing skills
  • Experience with ETL and data integration
  • Data validation and exception handling
  • Troubleshooting SSIS packages

Qualifications

  • Bachelor's degree in a related field
  • 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