EXCELON SOLUTIONS PRIVATE LIMITED - Senior SSIS Developer

Data Analyst is needed in Tulsa, United States.

Client: EXCELON SOLUTIONS PRIVATE LIMITED

Location: Tulsa, OK

Contract: Contract

Job Description

Role: Senior SSIS Developer

Location: Tulsa, Oklahoma (3 Days onsite/week)

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.

Requirements

Experience:

• ZappySys: 5 years (Required)
• SSIS: 8 years (Required)

Key Responsibilities:

• 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 including:
• 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.
• 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.
• 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).

Additional Information

Pay: $50.00 - $55.00 per hour

Work Location: On the road