ClinDCast
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.
Empowering the Future of Healthcare
The healthcare Industry is on the brink of a paradigm shift where patients are increasingly being viewed as empowered consumers, utilizing digital technologies to better understand and manage their own health. As a result, there is a growing demand for a range of patient-centric services, including personalized care that is tailored to each individual's unique needs, health equity that ensures access to care for all, price transparency to make healthcare more affordable, streamlined prior authorizations for medications, the availability of therapeutic alternatives, health literacy to promote informed decision-making, reduced costs, and many other initiatives designed to improve the patient experience.
ClinDCast is at the forefront of shaping the future of healthcare by partnering with globally recognized healthcare organizations and offering them innovative solutions and expert guidance. Our suite of services is designed to cater to a broad range of needs of healthcare organizations, including healthcare IT innovation, electronic health record (EHR) implementation & optimizations, data conversion, regulatory and quality reporting, enterprise data analytics, FHIR interoperability strategy, payer-to-payer data exchange, and application programming interface (API) strategy.
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.
Empowering the Future of Healthcare
The healthcare Industry is on the brink of a paradigm shift where patients are increasingly being viewed as empowered consumers, utilizing digital technologies to better understand and manage their own health. As a result, there is a growing demand for a range of patient-centric services, including personalized care that is tailored to each individual's unique needs, health equity that ensures access to care for all, price transparency to make healthcare more affordable, streamlined prior authorizations for medications, the availability of therapeutic alternatives, health literacy to promote informed decision-making, reduced costs, and many other initiatives designed to improve the patient experience.
ClinDCast is at the forefront of shaping the future of healthcare by partnering with globally recognized healthcare organizations and offering them innovative solutions and expert guidance. Our suite of services is designed to cater to a broad range of needs of healthcare organizations, including healthcare IT innovation, electronic health record (EHR) implementation & optimizations, data conversion, regulatory and quality reporting, enterprise data analytics, FHIR interoperability strategy, payer-to-payer data exchange, and application programming interface (API) strategy.