SSIS Developer

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)