Talent.com
SSIS Developer ETL Specialist
SSIS Developer ETL SpecialistProgrammers.io • Louisville, Kentucky, USA
[error_messages.no_longer_accepting]
SSIS Developer ETL Specialist

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]
    ETL with SQL

    ETL with SQL

    CData Software • Louisville, KY, United States
    [job_card.full_time]
    Participates in the design, creation, and maintenance of computerized databases.Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.Works direct...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    Information Systems Developer of AI and Automated Solutions Intern

    Information Systems Developer of AI and Automated Solutions Intern

    Trilogy Health Services • Louisville, KY, United States
    [job_card.full_time]
    Get more than just experience-get paid to grow! During our Summer 2026 Internship Program, you'll build real-world skills while working on projects that make an impact. Connect with executives and i...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    Practice Transformation Specialist, Kentucky

    Practice Transformation Specialist, Kentucky

    Aledade • Louisville, KY, US
    [job_card.full_time]
    Practice Transformation Specialist (PTS).Practice Transformation Specialists are HQ’s most direct interface with providers and can glean valuable insight into our partner practice’s hap...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Systems Integration Developer

    Systems Integration Developer

    Firstsource • Louisville, Kentucky, United States
    [job_card.full_time]
    We are seeking a highly skilled Senior BPaaS System Integration Developer to design, build, and maintain integrations across our enterprise BPaaS platform. This role is critical in ensuring seamless...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Remote Senior Integration Analyst

    Remote Senior Integration Analyst

    Technology Consulting, Inc. • Louisville, KY, United States
    [filters.remote]
    [job_card.permanent]
    TCI has an immediate need for a Remote.Senior Integration Analyst in Louisville, KY.This is a long-term contract opportunity not available for C2C. NOTE : This position requires US Citizenship or Per...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    Analyst, Systems Exempt

    Analyst, Systems Exempt

    LifePoint Health • Louisville, KY, United States
    [job_card.full_time]
    We are seeking a highly motivated and experienced professional to serve as the.Physical Access Control Systems (ACS).Building Automation Systems (BAS). This Brentwood-based role involves close colla...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    CDL-A - Dedicated Flatbed truck driver - Metrie

    CDL-A - Dedicated Flatbed truck driver - Metrie

    Schneider • Shepherdsville, KY
    [job_card.full_time]
    Dedicated Flatbed truck driver - Metrie.Haul lumber with flatbed trailers.Drive within IL, IN, KY, MO, TN and WV.Mileage pay and load pay, plus hourly pay while on duty, not driving.Paid time off a...[show_more]
    [last_updated.last_updated_30] • [promoted]
    ADB Developer

    ADB Developer

    Diverse Lynx • Louisville, KY, United States
    [job_card.full_time]
    Location - Louisville , KY (Onsite).Diverse Lynx LLC is an Equal Employment Opportunity employer.All qualified applicants will receive due consideration for employment without any discrimination.Al...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    Business Analyst (IT) : II

    Business Analyst (IT) : II

    V-Soft Consulting Group • Louisville, KY, United States
    [job_card.full_time]
    Business Analyst (IT) : II (Onsite).Primary Location : Louisville, Kentucky.V-Soft Consulting is currently hiring for a.Must have at least 3 years of HCHB and HCHB Analytics experience in Home Health...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    Implementation Supervisor II

    Implementation Supervisor II

    LanceSoft • Louisville, KY, US
    [job_card.full_time]
    Location : Hybrid, Louisville KY Duration : 0-12+ Months (Temp to Hire) Shift : 1.[show_more]
    [last_updated.last_updated_30] • [promoted]
    MSP - Tier II Systems Engineer

    MSP - Tier II Systems Engineer

    Technology Plus • Louisville, KY, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Since 1995, Technology Plus has been a trusted technology partner for businesses, offering expertise in IT, Telecom, Cabling, Security, and Audio / Visual services. We pride ourselves on delivering pe...[show_more]
    [last_updated.last_updated_30]
    Locum Physician (MD / DO) - Emergency Medicine in Scottsburg, IN

    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]
    CDL-A Drivers : Top Pay with Weekly Home Time

    CDL-A Drivers : Top Pay with Weekly Home Time

    TRANSCO LINES • Scottsburg, IN
    [job_card.full_time]
    Now Hiring Class A CDL Solo Drivers.Our drivers enjoy steady miles and pay, top benefits, and great home time.We know being a driver is tough. That's why we make sure you not only get great pay, but...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Roadway EIT

    Roadway EIT

    HMB Professional Engineers • New Albany, IN, US
    [job_card.full_time]
    As a top 14 transportation firm, HMB has some of the largest infrastructure projects in country.New Albany to work on capstone-type projects and be client facing from day one.Engaged professionals ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Info Sec Insider Threat Alst

    Info Sec Insider Threat Alst

    Old National Bank • Louisville, Kentucky, United States
    [job_card.full_time]
    US-IL-Tinley Park | US-IL-Chicago | US-IN-Evansville | US-MN-Lake Elmo | US-MN-St Louis Park | US-IN-Indianapolis | US-KY-Louisville | US-WI-Milwaukee | US-MI-Troy | US-WI-Madison | US-TN-Nashville...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Systems Engineer

    Sr. Systems Engineer

    Sortation Labs LLC • Louisville, KY, US
    [job_card.full_time]
    Experienced technical lead specializing in the design and development of parcel sortation and material handling systems.Adept at leading customer bids and projects from concept through execution, w...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Oracle Developer with ETL (OBIA)

    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]
    Associate Administrator Systems Administration

    Associate Administrator Systems Administration

    TTEC • Louisville, Kentucky, US
    [job_card.full_time]
    Your potential has a place here with TTEC’s award-winning employment experience.As a Associate Administrator Systems Administration working remotely in the United States, you’ll be a part of bringi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]