Talent.com
SSIS Developer / ETL Specialist
SSIS Developer / ETL SpecialistClinDCast LLC • Chicago, IL, US
[error_messages.no_longer_accepting]
SSIS Developer / ETL Specialist

SSIS Developer / ETL Specialist

ClinDCast LLC • Chicago, IL, US
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Description

Job Description
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.


[job_alerts.create_a_job]

SSIS Developer / ETL Specialist • Chicago, IL, US

[internal_linking.similar_jobs]

Analyst, Development

InvenergyChicago, IL, United States
[job_card.full_time]

Invenergy is North America’s largest privately held developer, owner, and operator of power infrastructure.With 25 years of trusted execution, we deliver reliable, affordable energy through a diver...[internal_linking.show_more]

 • [job_card.promoted]

HRIS Analyst UKG)

The LaSalle NetworkChicago, IL, United States
[job_card.full_time]

LaSalle Network is hiring on one of the country's largest healthcare organizations, seeking a HRIS Specialist.This role plays an integral role within the HR team, overseeing all aspects of the HRIS...[internal_linking.show_more]

 • [job_card.promoted]

ADP Specialist

Insight GlobalChicago, IL, United States
[job_card.full_time]

Pay Rate: $30-$46/hour (based on experience).The ADP Systems Specialist is a senior-level, hands-on expert responsible for the administration, optimization, and ongoing effectiveness of the organiz...[internal_linking.show_more]

 • [job_card.promoted]

Configuration Specialist, Senior

Benchmark AnalyticsChicago, IL, United States
[job_card.full_time]

Dedicated to making a difference in law enforcement agencies across the U.Driven by data science and powered by machine learning, our offering analyzes officer performance data in order to identify...[internal_linking.show_more]

 • [job_card.promoted]

Applications Analyst II - Ambulatory/Healthy Planet

NorthShore PC ServiceSkokie, IL, United States
[job_card.full_time]

The hourly pay rate offered is determined by a candidate's expertise and years of experience, among other factors.Position: Applications Analyst II - Ambulatory/Healthy Planet.Location: 4901 Searle...[internal_linking.show_more]

 • [job_card.promoted]

HRIS Analyst Contractor

1872 ConsultingChicago, IL, United States
[job_card.temporary]

The position is a 36-month contract with possibility for extension.The position is hybrid 2-3 days onsite.Job Overview: We are seeking an experienced HRIS Analyst to support the Human Resources dep...[internal_linking.show_more]

 • [job_card.promoted]

HRIS Analyst

Blue Star Partners, LLCChicago, IL, United States
[job_card.temporary]

Remote – Possible Travel - Must be based in Northwest Indiana or Columbus, Ohio – Willing to consider candidates located in Pennsylvania, Virginia, Maryland, or Illinois.The HR Technology Analyst w...[internal_linking.show_more]

 • [job_card.promoted]

Systems Analyst II

Loyola UniversityChicago, IL, United States
[job_card.full_time]

Is this request for the creation of a new Position (or the modification of an existing Position) to temporarily support the WorkDay ERP?.Maywood-Health Sciences Campus.Is this split and/or fully gr...[internal_linking.show_more]

 • [job_card.promoted]

Senior Systems Analyst

CyfleHighland Park, IL, United States
[job_card.full_time]

About the job Senior Systems Analyst.We have partnered with a global industrial electrical manufacturing company in Highland, IL area to provide them with an Senior Systems Analyst.Please review th...[internal_linking.show_more]

 • [job_card.promoted]

ETL Architect

VBeyondChicago, IL, United States
[job_card.full_time]

We are seeking a seasoned ETL Architect to design and lead scalable data integration solutions for enterprise Azure + Databricks based Lakehouse.This role requires expertise in Azure, Databricks al...[internal_linking.show_more]

 • [job_card.promoted]

Ab initio ETL developer - Only Citizens (Onsite)

MILLENNIUMSOFTChicago, IL, United States
[job_card.full_time]

Job Title: Ab initio ETL developer.Location: Chicago, IL-(Onsite).Advance knowledge, experience & demonstrated proficiency in all aspects of Ab Initio tool set.Executes software solutions, design, ...[internal_linking.show_more]

 • [job_card.promoted]

Lead Epic Application Analyst - Testing & Business Continuity

Rush UniversityChicago, IL, United States
[job_card.full_time]

Location: Chicago, Illinois / Remote.Business Unit: Rush Medical Center.Hospital: Rush University Medical Center.Department: IT Pt Exprnce & Strat Prtnrshp.Full Time (Total FTE between 0.Rush offer...[internal_linking.show_more]

 • [job_card.promoted]

Systems Developer Analyst IT - SCM (O9)

Medline IndustriesNorthbrook, IL, United States
[job_card.full_time]

Job Summary This role is hybrid, onsite Tuesday - Thursday.Job Description Required skills: Extensive hands-on experience in O9 integration and configuration.Minimum of 4 years’ direct involvement ...[internal_linking.show_more]

 • [job_card.promoted]

Standards Systems Project Lead

UL Standards and EngagementEvanston, IL, United States
[job_card.full_time]

We have an exciting opportunity for a.Standards Systems Project Lead.UL Standards & Engagement This is a hybrid opportunity based in our Evanston, IL or Raleigh-Durham, NC office.Standards Systems ...[internal_linking.show_more]

 • [job_card.promoted]

EMR/EHR Implementation Specialist

AlignerrChicago, IL, United States
[job_card.full_time]

EMR/EHR Implementation Specialist.At Alignerr, we partner with the world's leading AI research teams and labs to build and train cutting-edge AI models.We are seeking experienced EMR/EHR Implementa...[internal_linking.show_more]

 • [job_card.promoted]

Sr Developer Analyst IT

Medline Industries - Transportation & OperationsNorthbrook, Illinois, US
[job_card.full_time]

Job Summary Office Location: Northbrook, IL Hybrid: Onsite Tues.If you want to know about the requirements for this role, read on for all the relevant information.Thurs This position sits on the Sa...[internal_linking.show_more]

 • [job_card.promoted]

Test Lead (ETL-Data)

United IT SolutionsChicago, IL, United States
[job_card.full_time]

Resource should have 10+ years of experience in ETL QA.Lead the ETL projects, including creating / reviewing test scenarios/ cases.Collaborate with cross-functional teams, including developers, dat...[internal_linking.show_more]

 • [job_card.promoted]

ETL Developer IV

SparktekChicago, IL, United States
[job_card.full_time]

An ETL developer needs to design, build, test and maintain systems that extract, load and transform data from multiple different systems.Leads, Designs, implements, deploys and optimizes backend ET...[internal_linking.show_more]