What are the responsibilities and job description for the SSIS Developer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, HPTech Inc., is seeking the following. Apply via Dice today!
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)
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)