Software Developer - SSIS / SQL
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