SSIS Developer ETL SpecialistProgrammers.io • Louisville, Kentucky, USA

[error_messages.no_longer_accepting]

SSIS Developer ETL Specialist

Programmers.io • Louisville, Kentucky, USA

[job_card.30_days_ago]

[job_preview.job_type]

[job_card.full_time]

[job_card.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

[job_alerts.create_a_job]

Etl Developer • Louisville, Kentucky, USA

[internal_linking.similar_jobs]

Edifecs developer

Futran Tech Solutions Pvt. Ltd. • Louisville, KY, United States

[job_card.full_time]

Louisville, Kentucky(Local Only).Works closely with the customer's IT team to deliver high-quality releases.Participation in Technical Governance and define technical tasks.Experience with Healthca...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

TREASURY ANALYST

Equus • Louisville, KY, United States

[job_card.full_time]

At APM, we live our values of iCARE - Integrity, Customer focus, Accountability, Respect, and Excellence - in everything we do. We are a purpose-driven organization where procurement decisions direc...[show_more]

[last_updated.last_updated_variable_hours] • [promoted] • [new]

Strategic Solutions Analyst

Waystar • Louisville, KY, United States

[job_card.full_time]

The Strategic Solutions Analyst will act as a liaison between Waystar and our most strategic clients and partners.This is accomplished by handling inbound inquiries by phone and email, as well as c...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

Diesel Mechanic I & II - $2500 Sign On Bonus!!

Kenan Advantage Group • Scottsburg, Indiana, United States

[job_card.full_time]

KAG is North America's largest tank truck transporter and logistics provider, delivering energy commodities, specialty products, merchant gases and food products across the United States, Canada an...[show_more]

[last_updated.last_updated_variable_hours] • [promoted] • [new]

Locum Physician (MD / DO) - Emergency Medicine in Scottsburg, IN

LocumJobsOnline • Scottsburg, IN, US

[job_card.full_time]

Doctor of Medicine | Emergency Medicine.Competitive weekly pay (inquire for details) .LocumJobsOnline is working with Rhino Medical to find a qualified Emergency Medicine MD in Scottsburg, Indiana,...[show_more]

[last_updated.last_updated_30] • [promoted]

IT Systems Analyst Specialist Sr

Sedgwick • Louisville, KY, United States

[job_card.full_time]

By joining Sedgwick, you'll be part of something truly meaningful.It's what our 33,000 colleagues do every day for people around the world who are facing the unexpected. We invite you to grow your c...[show_more]

[last_updated.last_updated_variable_hours] • [promoted] • [new]

Manager of Continuous Improvement, Quality and EHS

Ajulia Executive Search • Lebanon Junction, Kentucky, United States

[job_card.full_time] +1

Are you looking to make a career change to an exciting company? This exciting opportunity as a Manager of Continuous Improvement-Quality & EHS offers a competitive salary plus an excellent benefits...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

IRL Tech

K.A. Recruiting • Mt Washington, KY, United States

[job_card.full_time] +1

IRL Tech opening at a beautiful facility in the Louisville, KY area.MANY different shift options available!.SIGN ON / RELOCATION BONUS MAY BE AVAILABLE • • •. Lab certification in specified job area.If y...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

ATS Integrated Solutions Project Engineer

ATS Companies • Louisville, KY, United States

[job_card.full_time]

Established in 1986, ATS Companies is the leading provider of energy management services, automated control systems, critical airflow solutions, and building systems integration.We aim to be the ma...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

Lead Networx Analyst, Contract Configuration Info Mgmt

Molina Healthcare • Louisville, KY, United States

[job_card.full_time]

Provides lead level analyst support for configuration information management activities.Responsible for accurate and timely implementation and maintenance of critical information on claims database...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

Team OTR CDL-A Company Truck Drivers

Transco Lines, Inc. • AUSTIN, Indiana, US

[job_card.full_time]

We know being a driving team is tough.That's why we make sure your team not only gets competitive pay, but home time to enjoy it as well. Your team will always get the utmost respect, appreciation, ...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

ETL tester

Diverse Lynx • Louisville, KY, United States

[job_card.full_time]

Location - Louisville, Kentucky (Onsite - 5 Days WFO).Test lead who can automate heterogeneous database test cases to reconcile data post cloud migration for SIT testing in python and spark tech st...[show_more]

[last_updated.last_updated_30] • [promoted]

Oracle Developer with ETL (OBIA)

Axiom Software Solutions Limited • Louisville, KY, US

[filters.remote]

[job_card.full_time]

[filters_job_card.quick_apply]

Oracle Developer with ETL (OBIA).Location – Louisville, KY (Remote).Note : Customer is looking for OBIA Upgrade / Implementation , OBIEE and ETL experience. Developer who has strong understanding of Or...[show_more]

[last_updated.last_updated_30]

Ab Initio Senior Developer

Purple Drive • Louisville, KY, United States

[job_card.full_time]

The ideal candidate should be able to design, develop, and optimize Ab Initio workflows while ensuring performance, scalability, and reliability of enterprise data solutions.ETL development and dat...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

Travel Physical Therapist (PT) in Mount Washington, KY

AlliedTravelCareers • Mount Washington, KY, US

[job_card.full_time] +1

Competitive weekly pay (inquire for details) .AlliedTravelCareers is working with Delta Healthcare Providers to find a qualified Physical Therapist (PT) in Mount Washington, Kentucky, 40047!.Settin...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

Senior System Analyst

Southern New Hampshire University • Louisville, KY, United States

[job_card.full_time]

Southern New Hampshire University is a team of innovators.Individuals who believe in progress with purpose.Since 1932, our people-centered strategy has defined us - and helped us grow a team that n...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

Emergency Medicine Physician

Team Health • Scottsburg, Indiana, US

[job_card.full_time]

Emergency Medicine physician employment in Indiana : Are you a clinician who aims to make a difference in the lives of your patients by providing quality care? TeamHealth needs someone like you! De...[show_more]

[last_updated.last_updated_variable_days] • [promoted]

Technical Business Analyst

Relativity • Louisville, KY, United States

[job_card.full_time]

Relativity's Problem Management is seeking a Technical Business Analyst who excels at using data analytics to uncover trends in quality, client workflows, product performance and efficiency.Your in...[show_more]

[last_updated.last_updated_variable_days] • [promoted]