Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
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)