Senior SSIS Developer

Senior SSIS Developer

Tulsa OK - Onsite Contract - Wipro Rate - $65/hr C2C

Job Summary

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.

Required Skills

• SSIS
• SQL Server
• Oracle
• Flat files
• APIs
• Cloud data sources
• ETL development and optimization

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.

Technical Development (Continued)

• 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

Performance Optimization

• Optimize package performance for large datasets and complex transformations.

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

Performance Optimization

• Optimize package performance for large datasets and complex transformations.

Debugging & Optimization

Troubleshoot and Resolve:

• Package failures
• Performance bottlenecks
• Data quality issues

Advanced Troubleshooting

• Conduct deep debugging of SSIS workflows, scripts, and data flows.
• Implement performance tuning techniques, including:
• Parallelism
• Buffering
• Indexing
• Query optimization

Debugging & Optimization

Troubleshoot and Resolve:

• Package failures
• Performance bottlenecks
• Data quality issues

Advanced Debugging

• Conduct deep debugging of SSIS workflows, scripts, and data flows.
• Implement performance tuning techniques, including:
• Parallelism
• Buffering
• Indexing
• Query optimization

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.