What are the responsibilities and job description for the Senior SSIS Developer position at Programmers.io?
Job Description:
Position: Senior SSIS Developer
Location: Tulsa, Oklahoma (3 Days onsite/week)
Hire Type: Contract
Client is seeking a highly skilled Senior SSIS Developer who is a hands-on expert. The ideal candidate will have deep experience designing, developing, optimizing, and troubleshooting complex SSIS packages and data integration solutions.
This role requires expertise in working with advanced ETL patterns, third-party SSIS components (ZappySys), APIs (REST/SOAP), XML processing, and data integrity techniques such as checksums.
Key Responsibilities
Technical Development:
Design, develop, and maintain complex SSIS packages for enterprise-scale data integration.
Build robust ETL pipelines handling high-volume and diverse data sources.
Implement and manage:
Data transformations:
Incremental loads (CDC, SCDs, delta logic)
Error handling and logging frameworks
Integrate external systems via:
REST/SOAP APIs
ZappySys connectors
XML / JSON data ingestion and parsing
Advanced Data Integration
Develop solutions using:
XML parsing (XPath, XQuery)
JSON transformations
Checksum/hash-based data validation and deduplication
Work with heterogeneous data sources including:
SQL Server, Oracle, flat files, APIs, cloud data sources
Optimize package performance for large datasets and complex transformations
Debugging & Optimization
Troubleshoot and resolve:
Package failures
Performance bottlenecks
Data quality issues
Conduct deep debugging of SSIS workflows, scripts, and data flows
Implement performance tuning techniques (parallelism, buffering, indexing, query optimization)