Senior SSIS Developer
Job Location:
Monthly Salary:
Posted on:
8 days ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
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.
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)
