Senior SSIS Developer Tulsa, Oklahoma (3 Days onsiteweek) 10+ Years Must

Job Description

Role: Senior SSIS Developer
Location: Tulsa Oklahoma (3 Days onsite/week)

Contract

Role Description:
We are 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)

Mandatory Skills: Microsoft SSIS .