SSIS Developer / ETL Specialist jobs in United States
cer-icon
Apply on Employer Site
company-logo

ClinDCast · 13 hours ago

SSIS Developer / ETL Specialist

positionAL
timeFull-time
remoteOnsite
seniorityMid Level
date3+ years exp

ClinDCast LLC is seeking an SSIS Developer / ETL Specialist to design, develop, and maintain ETL workflows using SQL Server Integration Services (SSIS). The role involves creating complex SSIS packages for data integration and transformation, optimizing performance, and collaborating with BI teams for analytics and reporting.

ConsultingElectronic Health Record (EHR)Health CareInformation Technology

Responsibilities

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
Tune SSIS packages and SQL queries for optimal performance
Apply best practices for SSIS performance, including parallelization, lookup caching, and bulk loading techniques
Schedule and monitor SSIS packages using SQL Server Agent
Configure credentials, proxy accounts, and permissions for secure execution
Perform debugging and troubleshooting of SSIS packages
Conduct backend database testing and validate data integrity
Work closely with BI teams to provide data for analytics and reporting
Support Power BI and SSRS reporting requirements when needed

Qualification

SSIS developmentSQL ServerT-SQLETL processesData warehousingPower BISSRSAnalytical skillsAgile methodologiesCommunication skills

Required

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)
Excellent analytical and communication skills

Preferred

Exposure to Power BI and SSRS is a plus
Knowledge of advanced SSIS components (CDC Splitter, DQS Cleansing, Fuzzy Grouping)
Experience in handling large datasets and optimizing ETL workflows
Understanding of Agile methodologies

Company

ClinDCast

twittertwittertwitter
company-logo
ClinDCast offers healthcare IT solutions and consulting services.
dateFounded in 2020
location
Wesley Chapel, Florida, USA
people-size51-200 employees
web-link
https://www.clindcast.com/

Funding

Current Stage
Growth Stage
Company data provided by crunchbase