Talent.com
Informatica ETL Developer
Informatica ETL DeveloperCSpring • Springfield, IL, United States
Informatica ETL Developer

Informatica ETL Developer

CSpring • Springfield, IL, United States
1 day ago
Job type
  • Full-time
Job description

At CSpring, we believe infrastructure and insight go hand in hand. We're looking for a seasoned Informatica ETL Developer to join our Enterprise Data Warehouse (EDW) team in support of a major healthcare data transformation initiative. This role is instrumental in building and maintaining robust data integration pipelines that ensure timely, trusted insights across Medicaid systems.

Whether you're optimizing job schedules, scripting solutions in Teradata, or leading performance tuning efforts, you'll be working on meaningful projects that power decision-making and improve healthcare delivery for real people.

Why You'll Love Working Here

  • Build What Matters - Play a key role in evolving data infrastructure that improves health outcomes across state Medicaid programs.
  • People-First Culture - We prioritize your growth, your wellbeing, and your voice-because consulting is personal.
  • Technical Autonomy - Own your craft while collaborating with a cross-functional team of analysts, architects, and policy experts.
  • Innovation with Integrity - Solve complex problems while mentoring others and continuously improving system performance.

What You'll Do

  • Design, develop, and optimize ETL solutions using Informatica PowerCenter .
  • Implement automated data staging, integration, and scheduling processes across large datasets.
  • Build, test, and maintain mappings, mapplets, workflows, and sessions using advanced Informatica transformations.
  • Administer ETL environments (development and production), including backups, recovery, and system tuning.
  • Write and optimize complex SQL and Unix Shell scripts to support Teradata-based data marts and reporting layers.
  • Participate in solution design, requirements analysis, testing, and documentation activities.
  • Collaborate with cross-functional teams and clients to align solutions with business needs and timelines.
  • Provide technical guidance and mentorship to junior developers and analysts.
  • Keep up with new technologies and recommend improvements to enhance performance and scalability.
  • Requirements

  • 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 Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server).
  • 5+ years of Informatica PowerCenter administration 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 Unix Shell (Bash / Korn) scripting experience.
  • 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
  • Location & Travel

    This is a telecommute role with occasional travel ( ) to Springfield, IL for client meetings.

    At CSpring, we unlock the potential in people and data. If you're a hands-on technologist who thrives in a fast-moving, impact-driven environment, we'd love to connect. Apply today to help shape the future of healthcare data infrastructure.

    Create a job alert for this search

    Etl Developer • Springfield, IL, United States

    Related jobs
    Information Systems Technician

    Information Systems Technician

    Navy • Williamsville, IL, United States
    Full-time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...Show more
    Last updated: 30+ days ago • Promoted
    Amazon Robotics Technician

    Amazon Robotics Technician

    TradeJobsWorkforce • 62515 Buffalo, IL, US
    Full-time
    Help us succeed as our next Amazon Robotics Technician to maintain and troubleshoot robotic systems in the warehouse.Stay adaptable to meet changing priorities and business needs.Stay adaptable to ...Show more
    Last updated: 30+ days ago • Promoted
    Cyber Warfare Technician

    Cyber Warfare Technician

    Navy • Montgomery County, IL, United States
    Full-time
    ABOUT Enlisted Sailors in the Navy Cryptology community analyze encrypted electronic communications, jam enemy radar signals, decipher information in foreign languages, and maintain state-of-the-ar...Show more
    Last updated: 30+ days ago • Promoted
    DevOps / Site Reliability Engineer (Global-Remote-Non.US)

    DevOps / Site Reliability Engineer (Global-Remote-Non.US)

    Token Metrics • Athens, Illinois, United States, 62613
    Remote
    Full-time
    DevOps / Site Reliability Engineer (Global-Remote-Non.Token Metrics is seeking a results-oriented IT administrator to manage our company's IT infrastructure. You will be upgrading and installing hardw...Show more
    Last updated: 24 days ago
    Active Nuclear Med Officer

    Active Nuclear Med Officer

    United States Army • Petersburg, IL, US
    Full-time
    THE ARMY HEALTH CARE ADVANTAGE As a member of the Army health care team, you'll receive benefits that you won't be able to get in a civilian career. Challenging Work Feel inspired with great case di...Show more
    Last updated: 3 days ago • Promoted
    Crypto-Native UX Researcher (Remote - Global - Non-US)

    Crypto-Native UX Researcher (Remote - Global - Non-US)

    Token Metrics • Athens, Illinois, United States, 62613
    Remote
    Full-time
    Crypto-Native UX Researcher (Remote - Global - Non-US).At Token Metrics, were revolutionizing crypto investing by providing data-driven insights, analytics, and tools to empower traders, investors,...Show more
    Last updated: 24 days ago
    Application Specialist - Prairieland FS - Greenview, IL

    Application Specialist - Prairieland FS - Greenview, IL

    Illinois Staffing • Greenview, IL, US
    Full-time
    At Prairieland FS, you have the opportunity to make an immediate impact.Working with the industry's top professionals, you'll develop new expertise through varied job experiences and company-sponso...Show more
    Last updated: 6 days ago • Promoted
    SAP P2P Functional Consultant

    SAP P2P Functional Consultant

    Diverse Lynx • Athens, IL, United States
    Full-time
    Role : SAP PTP Functional Consultant.Experience (Years) : 10 & Above.We are seeking an S / 4HANA PTP Functional Consultant with hands-on experience in SAP Procure-to-Pay (PTP) processes for Amplify.The...Show more
    Last updated: 30+ days ago • Promoted
    Solution Architect

    Solution Architect

    TradeJobsWorkForce • 62515 Buffalo, IL, US
    Full-time
    Solution Architect Job Duties : Responsible for assisting in the establishment of an IT Architect...Show more
    Last updated: 30+ days ago • Promoted
    Remote Side Hustle Developer

    Remote Side Hustle Developer

    Finance Buzz • Taylorville, Illinois, US
    Remote
    Full-time +1
    This position is for individuals who want to develop a side income stream while still working full time.You will test different small-scale remote opportunities, learn what works, and grow what pro...Show more
    Last updated: 23 days ago • Promoted
    Nuclear Operations

    Nuclear Operations

    Navy • Lincoln, IL, US
    Full-time
    ABOUT Nuclear technicians, power plant operators, and subsystems specialists are responsible for keeping vital Naval submarines and aircraft carriers running. These highly trained, hands-on professi...Show more
    Last updated: 30+ days ago • Promoted
    Information Technology Professional (IT Support)

    Information Technology Professional (IT Support)

    Navy • Taylorville, IL, United States
    Full-time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...Show more
    Last updated: 30+ days ago • Promoted
    Application Specialist - Prairieland FS - Illiopolis, IL

    Application Specialist - Prairieland FS - Illiopolis, IL

    Growmark • Chesterfield, IL, US
    Full-time
    Application Specialist - Prairieland FS - Illiopolis, IL.Total Rewards package that delivers exceptional pay for exceptional performance, recognizes your dedication to our mission, and helps us att...Show more
    Last updated: 6 days ago • Promoted
    Application Specialist - Illiopolis, IL

    Application Specialist - Illiopolis, IL

    Prairieland FS • Illiopolis, IL, US
    Full-time
    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 • Promoted
    Principal Applied Scientist - OCI / GEN AI (ChatBot)

    Principal Applied Scientist - OCI / GEN AI (ChatBot)

    Oracle • Springfield, IL, United States
    Full-time
    At Oracle Cloud Infrastructure (OCI), we build the future of the cloud for Enterprises as a diverse team of fellow creators and inventors. We act with the speed and attitude of a start-up, with the ...Show more
    Last updated: 1 day ago • Promoted
    Nuclear Engineer

    Nuclear Engineer

    Navy • Sherman, IL, US
    Full-time
    ABOUT Nuclear technicians, power plant operators, and subsystems specialists are responsible for keeping vital Naval submarines and aircraft carriers running. These highly trained, hands-on professi...Show more
    Last updated: 30+ days ago • Promoted
    Earn Money Playing Games, Answering Surveys & Testing Apps

    Earn Money Playing Games, Answering Surveys & Testing Apps

    AttaPoll • Lincoln, IL, US
    Full-time
    Get paid to answer surveys, play games, test apps, and do tasks.Make extra money on your phone and instantly cash out to PayPal, Revolut, or with gift cards from $3.Show more
    Last updated: 6 days ago • Promoted
    IT Professional

    IT Professional

    Navy • Nokomis, IL, United States
    Full-time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...Show more
    Last updated: 30+ days ago • Promoted