Sign upLog in

SSIS Developer / ETL Specialist

ClinDCast LLC

Downton, AL

Apply
JOB DETAILS
SKILLS
Agile Programming Methodologies, Analysis Skills, Best Practices, Business Intelligence, Caching, Centers for Disease Control and Prevention (CDC), Communication Skills, Data Analysis, Data Processing, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Debugging Skills, Error Handling, IBM DB2, Identify Issues, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Multicast, Oracle, Performance Tuning/Optimization, Power BI, Query Optimization, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Scripting (Scripting Languages), Star Schema, Team Player, Testing, XML (EXtensible Markup Language)
LOCATION
Downton, AL
POSTED
26 days ago
Job Title: SSIS Developer / ETL Specialist
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.


About the Company

C

ClinDCast LLC