Link copied to clipboard!
Back to Jobs
SSIS Developer ETL Specialist at Programmers.io
Programmers.io
Louisville, KY
Information Technology
Posted 0 days ago
Job Description
Role Overview 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. Key Responsibilities 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. Qualifications 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. Key Skills SQL,Pentaho,PL/SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle Employment Type : Full Time Experience: years Vacancy: 1
Resume Suggestions
Highlight relevant experience and skills that match the job requirements to demonstrate your qualifications.
Quantify your achievements with specific metrics and results whenever possible to show impact.
Emphasize your proficiency in relevant technologies and tools mentioned in the job description.
Showcase your communication and collaboration skills through examples of successful projects and teamwork.