Talent.com
EDW Informatica ETL Developer (4 positions)
EDW Informatica ETL Developer (4 positions)Datamaxis • Springfield, Illinois, United States
EDW Informatica ETL Developer (4 positions)

EDW Informatica ETL Developer (4 positions)

Datamaxis • Springfield, Illinois, United States
6 days ago
Job type
  • Full-time
  • Remote
Job description

Location : Telecommute (with occasional travel to Springfield, IL)

Rate : depending on experience

Job Summary :

We are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata. The ideal candidate will have a deep understanding of data integration, performance tuning, and data warehousing best practices, with a focus on supporting healthcare-related data systems.

Required Qualifications :

  • 7+ years of experience with Informatica PowerCenter and ETL development.
  • 5+ years of experience writing complex SQL and performance tuning.
  • 5+ years of experience with Teradata (v17+), including Fastload, TPT, and Multiload utilities.
  • 5+ years of Informatica PowerCenter administration experience.
  • 2+ years of Unix Shell (Bash / Korn) scripting experience.
  • Strong communication, collaboration, and mentoring skills.
  • Bachelor’s or advanced degree in IT, Computer Science, Mathematics, or a related field.
  • Strong organizational and time management skills.

Preferred Qualifications :

  • Residing in or near Springfield, IL.
  • 5+ years of data warehouse development experience.
  • 5+ years of data modeling experience using ERWIN or similar tools.
  • 2+ years of experience with Azure Data Factory and Snowflake.
  • Experience with scripting languages such as Python, R, or JavaScript (React).
  • Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager.
  • Experience with Medicaid, Medicare, or healthcare data systems.
  • Experience working in Agile environments.
  • Knowledge of BI and data integration technologies across relational and multidimensional
  • systems.

    Key Responsibilities :

  • Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and
  • load data from various agency sources.

  • Automate data staging processes and optimize ETL job scheduling for performance and
  • efficiency.

  • Administer and support ETL environments, including development and production systems.
  • Perform repository backups, recovery operations, and system maintenance.
  • Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica
  • transformations.

  • Monitor and troubleshoot ETL jobs across development, testing, and production environments.
  • Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in
  • Teradata.

  • Collaborate with stakeholders to define requirements, document technical solutions, and
  • support project planning.

  • Participate in unit, integration, and system testing.
  • Provide technical support, mentoring, and guidance to team members.
  • Communicate project status and deliverables to leadership and clients.
  • Continuously learn and apply new technologies to enhance system performance and
  • capabilities.

    Create a job alert for this search

    EDW Informatica ETL Developer 4 positions • Springfield, Illinois, United States

    Similar jobs
    Sales Engineer - Central IL

    Sales Engineer - Central IL

    Spirax Group • Springfield, IL, US
    Full-time
    Here at Spirax Sarco we offer the industry's most extensive range of products with services, coupled with practical industry application expertise. In short, we build solutions that set the benchmar...Show more
    Last updated: 30+ days ago • Promoted
    LPN (Day or Evening) - $3k Sign on and ADN Paid For!

    LPN (Day or Evening) - $3k Sign on and ADN Paid For!

    Universal Health Services, Inc. • Springfield, IL, United States
    Full-time +1
    This opportunity is either full-time (40 or 32 hours / week) or part-time (24 hours / week), benefit eligible position.There is opportunity for overtime, and to cover various shifts if interested.New G...Show more
    Last updated: 9 days ago • Promoted
    Diesel Fleet Techs III - Earn $35-$42.21 / Hr - $7.5k Sign-On + Benefits

    Diesel Fleet Techs III - Earn $35-$42.21 / Hr - $7.5k Sign-On + Benefits

    Sysco • Litchfield, IL, US
    Full-time
    Sysco is Now Hiring Diesel Fleet Technicians in St.Hour • - Up to $7,500 Sign-On Bonus for New Hires.Annual Tool Allowance - Comprehensive Benefits. We offer our colleagues the opportunity to grow pe...Show more
    Last updated: 30+ days ago • Promoted
    Conduce con DoorDash (de tiempo parcial o completo)

    Conduce con DoorDash (de tiempo parcial o completo)

    DoorDash • Williamsville, IL, United States
    Por qué entregar con DoorDash?.DoorDash es el líder número uno de la categoría en entregas de comida, retiro de comida y entregas de tiendas de conveniencia en EE. Como Dasher, tendrás múltiples opo...Show more
    Last updated: 30+ days ago • Promoted
    Conduce con DoorDash - Sé tu propio jefe

    Conduce con DoorDash - Sé tu propio jefe

    DoorDash • Williamsville, IL, United States
    Por qué entregar con DoorDash?.DoorDash es el líder número uno de la categoría en entregas de comida, retiro de comida y entregas de tiendas de conveniencia en EE. Como Dasher, tendrás múltiples opo...Show more
    Last updated: 30+ days ago • Promoted
    Embedded ROI Processor ll

    Embedded ROI Processor ll

    Datavant • Springfield, IL, United States
    Full-time
    Datavant is a data platform company and the world's leader in health data exchange.Our vision is that every healthcare decision is powered by the right data, at the right time, in the right format....Show more
    Last updated: 8 days ago • Promoted
    Software Development Snr Director (JoinOCI-Leader)

    Software Development Snr Director (JoinOCI-Leader)

    Oracle • Springfield, IL, United States
    Full-time
    As a Senior Director you will lead a team responsible for a critical element of the host lifecycle within Oracle's cloud business (OCI). Delivering GPU compute capacity quickly and at high quality t...Show more
    Last updated: 8 days ago • Promoted
    OSHA Training Developer / Administrator (MAIII)

    OSHA Training Developer / Administrator (MAIII)

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Office of the Illinois Secretary of State.Union : .S Second St, Springfield, IL – Sangamon County.Salary : .Range $65,000 to $80...Show more
    Last updated: 30+ days ago • Promoted
    Become a Surrogate and Help Create a Family While Supporting Your Own

    Become a Surrogate and Help Create a Family While Supporting Your Own

    Inclusive Surrogacy • Litchfield, IL, US
    Full-time +1
    Become a Surrogate and Help Create a Family While Supporting Your Own.Surrogacy gives you the opportunity to make an extraordinary impact in someone’s life while strengthening your own family’s fut...Show more
    Last updated: 7 days ago • Promoted
    Travel CT Tech - $2,129 to $2,361 per week in Springfield, IL

    Travel CT Tech - $2,129 to $2,361 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Ready to start your next travel adventure? LRS Healthcare offers a full benefits package, 24 / 7 support, and a responsive, traveler-first culture. What are you waiting for? Apply today!.Valid license...Show more
    Last updated: 6 days ago • Promoted
    CDL-A Lease Driver - Up to $130k+ after deductions

    CDL-A Lease Driver - Up to $130k+ after deductions

    Trekker • Litchfield, IL, US
    Full-time
    Take control of your future with a lease program built for drivers who want more than miles — they want ownership.At Trekker, we know success isn’t luck — it’s focus.That&rs...Show more
    Last updated: 3 days ago • Promoted
    Lead Technology Leader

    Lead Technology Leader

    Humana • Springfield, IL, United States
    Full-time
    Become a part of our caring community and help us put health first.The Lead Technology Leadership Professional is responsible for all aspects of software or hardware product delivery and performanc...Show more
    Last updated: 4 days ago • Promoted
    Assoc Analyst Technology

    Assoc Analyst Technology

    Medline Industries - Transportation & Operations • Springfield, Illinois, United States
    Full-time
    Job Summary The Associate Analyst Technology role will play a crucial role in ensuring the smooth exchange of data between the organization and partner systems. This position is responsible for prov...Show more
    Last updated: 30+ days ago • Promoted
    Application Specialist - Greenview, IL

    Application Specialist - Greenview, IL

    Prairieland FS • Greenview, IL, USA
    Full-time
    Quick Apply
    Compensation is determined based on your experience and qualifications.In addition to base pay, you may be eligible for overtime, commission, and performance-based increases and bonuses.We are comm...Show more
    Last updated: 30+ days ago
    Application Developer

    Application Developer

    TradeJobsWorkForce • 62563 Rochester, IL, US
    Full-time
    Analyze the ideas, business models, and user requirements to formulate a design strategy to carry out.Act as a tenant to draw out a workable application design and coding parameters with the essent...Show more
    Last updated: 30+ days ago • Promoted
    IT Low Code Developer & SQL Analyst

    IT Low Code Developer & SQL Analyst

    United Community Bank • Auburn, IL, US
    Full-time
    United Community Bank is seeking a dynamic and detail oriented Low Code Developer & SQL Analyst to join our IT team.This role is ideal for someone who thrives at the intersection of logical thi...Show more
    Last updated: 25 days ago • Promoted
    Travel CT Tech - $2361 / Week

    Travel CT Tech - $2361 / Week

    LRS Healthcare - Allied • Springfield, IL, US
    Full-time
    LRS Healthcare - Allied is seeking an experienced CT Tech for an exciting Travel Allied job in Springfield, IL.Shift : Inquire Start Date : 02 / 16 / 2026 Duration : 13 weeks Pay : $2361 / Week.Ready to st...Show more
    Last updated: 6 days ago • Promoted
    Locate Technician - Montgomery County, Illinois

    Locate Technician - Montgomery County, Illinois

    Stake Center Locating • Litchfield, IL, US
    Full-time
    Utility Locator (Field Technician).Stake Center Locating is hiring entry level Locate Technicians to locate underground utilities, troubleshoot, and mark the ground (using paint and flags), promoti...Show more
    Last updated: 30+ days ago • Promoted