SSIS Developer / ETL Specialist

The SSIS Developer will design, develop, and maintain ETL workflows using SQL Server Integration Services (SSIS) to support data integration, transformation, and loading processes for enterprise data solutions., * ETL Development

• Design and implement complex SSIS packages for data extraction, transformation, and loading (ETL) from multiple sources (DB2, Oracle, Flat Files, XML).
• Utilize advanced SSIS transformations such as Conditional Split, Fuzzy Lookup, For Each Loop, MultiCast, and Script Components for data processing.
• Implement error handling, logging, and checkpoints for robust package execution.
• Performance Optimization
• Tune SSIS packages and SQL queries for optimal performance.
• Apply best practices for SSIS performance, including parallelization, lookup caching, and bulk loading techniques.
• Integration & Scheduling
• Schedule and monitor SSIS packages using SQL Server Agent.
• Configure credentials, proxy accounts, and permissions for secure execution.
• Testing & Troubleshooting
• Perform debugging and troubleshooting of SSIS packages.
• Conduct backend database testing and validate data integrity.
• Collaboration
• Work closely with BI teams to provide data for analytics and reporting.
• Support Power BI and SSRS reporting requirements when needed.

• 3+ years of experience in SSIS development and ETL processes.
• Strong knowledge of SQL Server, T-SQL, and database objects (procedures, functions, views).
• Experience with SSIS performance tuning and troubleshooting.
• Familiarity with data warehousing concepts (Star Schema, Fact/Dimension tables).
• Exposure to Power BI and SSRS is a plus.
• Excellent analytical and communication skills.

Preferred Skills

• Knowledge of advanced SSIS components (CDC Splitter, DQS Cleansing, Fuzzy Grouping).
• Experience in handling large datasets and optimizing ETL workflows.
• Understanding of Agile methodologies.