Software Developer - SSIS / SQL

Job Description

On behalf of our Financial Services client, Procom is searching for a Software Developer - SSIS / SQL for a 12-month role. This position is a hybrid position with 4 days onsite at our client’s Austin, Texas office.

Software Developer - SSIS / SQL - Job Description:
The project involves supporting and enhancing business-critical data pipelines and scheduled jobs using SQL Server batch processing with SSIS packages. This role focuses on immediate delivery expectations with minimal ramp-up time.

Software Developer - SSIS / SQL - Responsibilities:
• Develop, enhance, and support SSIS-based SQL batch jobs
• Build and maintain ETL and data movement pipelines
• Optimize SQL queries and stored procedures for performance and reliability
• Support batch execution, monitoring, and issue resolution
• Perform root cause analysis for data or job failures
• Document SSIS packages, batch logic, and data flows
• Collaborate with QA, production support, and full-time engineering staff

Software Developer - SSIS / SQL - Mandatory Skills:
• 5+ years of software development experience
• Strong hands-on experience with SSIS package development and support
• Strong SQL Server expertise, including complex queries and performance tuning
• Experience building and supporting SQL-based batch jobs
• Working knowledge of .NET / C# in backend or batch workflows
• Experience supporting scheduled/automated jobs in production environments
• Strong troubleshooting skills for batch failures and data issues

Software Developer - SSIS / SQL – Nice-to-Have Skills:
• Experience with job schedulers (SQL Agent, Control-M, Autosys)
• Experience working with legacy batch jobs
• Familiarity with Git and CI/CD pipelines
• Financial services or regulated environment experience