Talent.com
SSIS Developer ETL Specialist
SSIS Developer ETL SpecialistProgrammers.io • Louisville, Kentucky, USA
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]
    Systems Integration Developer

    Systems Integration Developer

    Firstsource • Louisville, KY, US
    [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_1_day] • [promoted]
    AEL Helicopter Pilot - HAA

    AEL Helicopter Pilot - HAA

    Air Evac Lifeteam • Louisville, KY, US
    [job_card.full_time]
    We invite you to join a team of highly skilled emergency medical experts, pilots and mechanics!.Our mission of providing care to the world at a moment's notice is at the heart of everything we do.W...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Power Generation EIT 1

    Power Generation EIT 1

    GAI Consultants Inc. • Louisville, KY, US
    [job_card.full_time]
    EIT 1to work with the Power Generation Business Sector on primarily Power Generation projects and when needed other regional projects. GAI offers its employees the ability to work remotely or in a h...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Youth Advocate (Specialty JCPS Connector and SEL Specialist)

    Youth Advocate (Specialty JCPS Connector and SEL Specialist)

    Neighborhood House • Louisville, KY, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Neighborhood House in Louisville, KY, is hiring a full-time, non-exempt Youth Advocate, an experienced professional focused on connecting K-12 youth with school systems for better support, utilizin...[show_more]
    [last_updated.last_updated_variable_days]
    Travel Physical Therapist (PT) - $1,888 per week in Mount Washington, KY

    Travel Physical Therapist (PT) - $1,888 per week in Mount Washington, KY

    AlliedTravelCareers • Mount Washington, KY, US
    [job_card.full_time]
    Travel Rehab : Physical Therapy Mt Washington.Location : Mt Washington.Shift Details : 8H Days (12 : 00 AM-12 : 00 PM).Length : 13 WEEKS 13 weeks. Apply for specific facility details.[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    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]
    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_hours] • [promoted] • [new]
    CDL-A Flatbed Truck Driver - $0.40 to $0.63 per mile in Scottsburg, IN

    CDL-A Flatbed Truck Driver - $0.40 to $0.63 per mile in Scottsburg, IN

    AllTruckJobs • Scottsburg, IN, US
    [job_card.full_time]
    CALL TO SPEAK WITH A SEATING SPECIALIST TODAY! .Western Express has immediate openings in our Flatbed and Dry Van divisions for company drivers and driver trainers! With our newly increased pay pac...[show_more]
    [last_updated.last_updated_30] • [promoted]
    CDL-A Flatbed Truck Driver - $0.40 to $0.48 per mile in Scottsburg, IN

    CDL-A Flatbed Truck Driver - $0.40 to $0.48 per mile in Scottsburg, IN

    AllTruckJobs • Scottsburg, IN, US
    [job_card.full_time]
    CALL TO SPEAK WITH A SEATING SPECIALIST TODAY! .Western Express has immediate openings for entry level company truck drivers and driver trainers. With our newly increased pay package, you'll earn on...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Physical Therapist - $1,888 per week

    Travel Physical Therapist - $1,888 per week

    Triage Staffing • Mt Washington, KY, United States
    [job_card.full_time]
    Triage Staffing is seeking a travel Physical Therapist for a travel job in Mt Washington, Kentucky.Job Description & Requirements. Travel Rehab : Physical Therapy Mt Washington.Location : Mt W...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    Travel Skilled Nursing Facility (SNF) Occupational Therapist - $1,840 per week

    Travel Skilled Nursing Facility (SNF) Occupational Therapist - $1,840 per week

    TheraEx Therapy • Scottsburg, IN, United States
    [job_card.full_time]
    TheraEx Therapy is seeking a travel Skilled Nursing Facility (SNF) Occupational Therapist for a travel job in Scottsburg, Indiana. Job Description & Requirements.Occupational Therapist – HIRING!.BLS...[show_more]
    [last_updated.last_updated_30] • [promoted]
    OTBI Developer

    OTBI Developer

    Axiom Software Solutions Limited • Louisville, KY, US
    [filters.remote]
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Location – Louisville, KY (Remote).We are seeking an experienced OTBI Developer with a strong focus on Finance Cloud and BI Publisher reporting. The ideal candidate will have hands-on experience in ...[show_more]
    [last_updated.last_updated_30]
    Travel Physical Therapist - $1,903 per week

    Travel Physical Therapist - $1,903 per week

    IDR Healthcare • Shepherdsville, KY, United States
    [job_card.full_time]
    IDR Healthcare is seeking a travel Physical Therapist for a travel job in Shepherdsville, Kentucky.Job Description & Requirements. IDR Job ID #BMPT-Shepherdsville,-KY-(0010-1909)-AN-0003.Pay package...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Governance Analyst

    Data Governance Analyst

    Old National Bank • Louisville, Kentucky, United States
    [job_card.full_time]
    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.Old National Bank h...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Physician / Internal Medicine / Indiana / Permanent / Physician - Internal Medicine in Indiana Job

    Physician / Internal Medicine / Indiana / Permanent / Physician - Internal Medicine in Indiana Job

    VISTA Staffing Solutions • Scottsburg, IN, US
    [job_card.permanent]
    This position with one of VISTA s healthcare partners in.Schedule : 6a 6p and 6p 6a, 8 10 shifts / month.Setting : Critical Access Hospital. Type of Cases : General Emergency Medicine.Credentialing : Emer...[show_more]
    [last_updated.last_updated_30] • [promoted]