Software Developer - SSIS / SQL (.NET)

Job Description

On behalf of our technology client, Procom is searching for a Software Developer - SSIS / SQL (.NET) 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 (.NET) - Job Description:
The project involves developing, enhancing, and supporting business-critical data pipelines using SSIS packages. The focus is on optimizing SQL Server batch processing and ensuring the stability and reliability of scheduled jobs. The role requires immediate hands-on contribution with minimal ramp-up time.

Software Developer - SSIS / SQL (.NET) - 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 (.NET) - 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 stored procedures
• Experience building and supporting SQL-based batch jobs
• Working knowledge of .NET / C# used 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 (.NET) – Nice-to-Have Skills:
• Experience with job schedulers (SQL Agent, ControlM, Autosys)
• Experience working with legacy batch jobs
• Familiarity with Git and CI/CD pipelines
• Financial services or regulated environment experience

Software Developer - SSIS / SQL (.NET) – Assignment Length:
This is a 12-month contract position.