SSIS Developer

Job Title: SSIS Developer (Performance Optimization) Location: Mclean, VA Description: The SSIS Developer will play a crucial role in enhancing the performance of our legacy SSIS jobs. You will analyze existing code, identify performance bottlenecks, and implement effective solutions to improve data processing efficiency. Responsibilities: Conduct thorough performance assessments of existing SSIS packages, identifying areas for optimization. Rewrite or enhance SSIS code to improve execution speed and resource utilization. Analyze data sources and target systems to identify potential performance impacts. Implement appropriate indexing and partitioning strategies to optimize data access. Enhance error handling mechanisms to ensure data integrity and reliability. Create clear and concise documentation for optimized SSIS packages. Work closely with data analysts, architects, and other team members to understand data requirements and integration needs. Required skills: Proven experience as an SSIS Developer with a strong focus on performance optimization. In-depth knowledge of SSIS architecture, components, and best practices. Proficiency in SQL Server and T-SQL. Strong analytical and problem-solving skills. Ability to work independently and as part of a team. Excellent communication and documentation skills. Experience with SSIS packages for large-scale data integration. Familiarity with performance tuning techniques for SQL Server databases. Knowledge of data warehousing and ETL concepts.