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

EDW Informatica ETL Developer (4 positions)

Datamaxis • Springfield, Illinois, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
  • [filters.remote]
[job_card.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.

    [job_alerts.create_a_job]

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

    [internal_linking.similar_jobs]
    Licensed Practical Nurse (LPN) - Part-time-2nd shift

    Licensed Practical Nurse (LPN) - Part-time-2nd shift

    Gardant • Girard, IL, United States
    [job_card.part_time]
    Responsibilities : • Oversees medication distribution as stated on physician orders, ensuring strict adherence to Community medication management documentation and procedure, and demonstrating stea...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Area Schedule Lead - Data Center Design, Engineering and Construction

    Area Schedule Lead - Data Center Design, Engineering and Construction

    META • Springfield, IL, United States
    [job_card.full_time]
    We are seeking a candidate for a key leadership role in scheduling for a portfolio of Data Center projects of strategic importance to Meta. The Schedule lead will act as a technical Schedule subject...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Assoc Analyst Technology

    Assoc Analyst Technology

    Medline Industries • Springfield, IL, United States
    [job_card.full_time]
    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 providing techni...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Earn $50,000–$100,000 as a Surrogate – Must Have Healthy Prior Delivery

    Earn $50,000–$100,000 as a Surrogate – Must Have Healthy Prior Delivery

    Ivy Surrogacy • Spaulding, IL, US
    [job_card.full_time] +1
    Becoming a surrogate mother is one of the greatest gifts of life!.Ivy Surrogacy is a third-party reproductive agency for parents all over the world seeking. At Ivy Surrogacy, we genuinely believe we...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Software Engineer

    Senior Software Engineer

    TekSynap • Township of Capital, South Dakota, US
    [job_card.full_time]
    Job Description Job Description Overview We are seeking a Senior Software Engineer to join our TekSynap team, supporting the Defense Intelligence Agency (DIA) and the Intelligence Community.The S...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Conduce con DoorDash - Sé tu propio jefe

    Conduce con DoorDash - Sé tu propio jefe

    DoorDash • Litchfield, 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.last_updated_30] • [promoted]
    Wireless Sales Pro

    Wireless Sales Pro

    Acosta, Inc. • Litchfield, IL, United States
    [job_card.part_time]
    Wireless Sales Pro General Information Company : PRE-US Location : LITCHFIELD, Illinois, 62056 Ref # : 34931 Pay Rate : $ 15. Experience / skills and / or location may influence position wage rate Ran...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Compensated Surrogacy Opportunity - Make a Life Changing Impact and Earn $60,000+

    Compensated Surrogacy Opportunity - Make a Life Changing Impact and Earn $60,000+

    Newborn Advantage Surrogacy • Riverton, IL, US
    [job_card.full_time]
    Compensated Surrogacy Opportunity - Make a Life Changing Impact and Earn $60,000+.Newborn Advantage Surrogacy is seeking qualified women to become gestational surrogates and help intended parents g...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Global Sales Leader - NDB (Nutanix Database Services)

    Global Sales Leader - NDB (Nutanix Database Services)

    Nutanix • Springfield, IL, United States
    [job_card.full_time]
    Hungry, Humble, Honest, with Heart.The Opportunity • • Nutanix has always been known for bringing simplicity to the most complex of technology challenges, delivering it through beautiful engineering...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Business Development Analyst, Senior - Inside Sales Specialist

    Business Development Analyst, Senior - Inside Sales Specialist

    Qualcomm • Springfield, IL, United States
    [job_card.full_time]
    Company : Qualcomm Technologies, Inc.Job Area : Sales, Business Development & Marketing Group, Sales, Business Development & Marketing Group > . Business Development - SIP General Summary : About Ar...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Portfolio Operations Lead, Indoor Retail

    Portfolio Operations Lead, Indoor Retail

    Vontier • Springfield, IL, United States
    [job_card.full_time]
    The Portfolio Operations leader drives solution and product performance within Indoor Retail through advanced P&L management, prioritization and execution of new product implementation into our fac...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Assoc Analyst Technology

    Assoc Analyst Technology

    Medline Industries - Transportation & Operations • Springfield, IL, US
    [job_card.full_time]
    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 providing techni...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Application Specialist - Greenview, IL

    Application Specialist - Greenview, IL

    Prairieland FS • Greenview, IL, USA
    [job_card.full_time]
    [filters_job_card.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.last_updated_30]
    Endocrinologist Opportunity | Partnership Track

    Endocrinologist Opportunity | Partnership Track

    Springfield Clinic • Springfield, IL, US
    [job_card.full_time]
    Springfield Clinic is seeking a BE / BC Endocrinologist.We are looking for a physician who values practice autonomy, collaboration and delivery exceptional patient care. Springfield Clinic is the larg...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Customer Solutions Practice Leader

    Customer Solutions Practice Leader

    Confluent • Springfield, IL, United States
    [job_card.full_time]
    K - $160K - Offers Equity - Offers Commission.At Confluent, we are dedicated to offering competitive pay and benefits that align with industry standards. We carefully consider several factors when d...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Product Designer, Release of Information

    Senior Product Designer, Release of Information

    Datavant • Springfield, IL, United States
    [job_card.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.last_updated_variable_hours] • [promoted] • [new]
    Application Developer

    Application Developer

    TradeJobsWorkForce • 62563 Rochester, IL, US
    [job_card.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.last_updated_30] • [promoted]
    Exp. Intermodal CDL-A Owner Operators - Home Time - Avg. $200,000 / Year

    Exp. Intermodal CDL-A Owner Operators - Home Time - Avg. $200,000 / Year

    Chicago Intermodal Transportation • Springfield, IL, US
    [job_card.full_time]
    Chicago Intermodal Transportation is Now Seeking Intermodal CDL-A Owner Operators.Average $200,000 per Year, Gross - Paid All Loaded Miles. Local or Regional Routes Available - No Forced Dispatch.Ow...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]