Talent.com
Enterprise Data Warehouse (EDW) Informatica ETL Developer
Enterprise Data Warehouse (EDW) Informatica ETL DevelopereAspire Technolabs Inc. • Springfield, IL, US
Enterprise Data Warehouse (EDW) Informatica ETL Developer

Enterprise Data Warehouse (EDW) Informatica ETL Developer

eAspire Technolabs Inc. • Springfield, IL, US
[job_card.variable_hours_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Description

Job Title : Enterprise Data Warehouse (EDW) Informatica ETL Developer

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

Type : C2C / W2

Visa Status : H1B

Job Summary :

Client is seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our 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, particularly within healthcare-related data systems.

Key Responsibilities :

  • Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various sources.
  • Automate data staging processes and optimize ETL job scheduling.
  • 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 various Informatica transformations.
  • Monitor and troubleshoot ETL jobs across all environments.
  • Write and optimize complex SQL queries and Unix Shell scripts for Teradata data marts.
  • Collaborate with stakeholders to define requirements and document technical solutions.
  • Participate in unit, integration, and system testing.
  • Provide technical support, mentoring, and guidance to team members.

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.
  • Bachelor’s or advanced degree in IT, Computer Science, or a related field.

    • Preferred Qualifications :

  • Residing in or near Springfield, IL.
  • 5+ years of data warehouse development and data modeling experience (ERWIN).
  • 2+ years of experience with Azure Data Factory and Snowflake.
  • Experience with Python, R, or JavaScript (React).
  • Familiarity with IDQ, Address Doctor, and Metadata Manager.
  • Experience with Medicaid, Medicare, or healthcare data systems.
    • [job_alerts.create_a_job]

    Enterprise Warehouse • Springfield, IL, US

    [internal_linking.similar_jobs]
    Territory Sales Manager - Educational Engineering Products - Illinois

    Territory Sales Manager - Educational Engineering Products - Illinois

    Mercury Hampton Ltd • Springfield, IL, US
    [job_card.full_time]
    Shape the Future of Engineering Education as a Territory Sales Manager!.Location / Territory Texas, Arkansas, Kentucky, Tennessee, Missouri, Illinois, Indiana, Michigan, Iowa, Minnesota, & Wiscon...[show_more]
    [last_updated.last_updated_30] • [promoted]
    RN Oncology

    RN Oncology

    Lancesoft INC • Springfield, IL, US
    [job_card.full_time]
    Years of experience REQ : Minimum 1 year experience required.Certs REQ : Chemo cert required.Open to accommodating block schedule? Discuss schedule requests with manager. Must have active IL license i...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel RN- IMC 12hr Days REQ : 11348578

    Travel RN- IMC 12hr Days REQ : 11348578

    Fidelity on Call, LTD • Springfield, IL, US
    [job_card.full_time]
    Pay Rate : $58 – $63 / hr combined (taxable hourly + tax-free allowances for travel, housing, meals).Rates may vary and are subject to client changes. Step-Down / Intermediate Care RN J...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Direct Support Professional (Springfield, IL)

    Direct Support Professional (Springfield, IL)

    Individual Advocacy Group • Springfield, IL, US
    [job_card.full_time]
    To achieve a community-integrated and enriched lifestyle based on values of individual self-worth, dignity, equality, and respect for adults with developmental disabilities.To assist individuals in...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Platform Developer - ETL

    Senior Platform Developer - ETL

    Krasan Consulting Services • Springfield, IL, US
    [job_card.full_time]
    Hiring for : Senior Platform Developer (Data Modeling & Database Architecture).Data Modeling & Architecture.Design and develop conceptual, logical, and physical data models for greenfield in...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Information Systems Advisor II - Drivers Applications

    Information Systems Advisor II - Drivers Applications

    Illinois Secretary of State • Springfield, IL, US
    [job_card.full_time]
    Office of the Illinois Secretary of State.Information Systems Advisor II - Drivers Applications.Union : .Springfield, IL – Sangamon County.Salary : &...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Analyst (Remote)

    Data Analyst (Remote)

    Quality Talent Group • Springfield, IL, US
    [filters.remote]
    [job_card.full_time]
    Our client is a leading force in advancing safer, smarter AI technology.Their work has been featured in.They have built a global community of expert contributors and have paid more than.No contract...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Platform Developer - ETL (Springfield)

    Senior Platform Developer - ETL (Springfield)

    Krasan Consulting Services • Springfield, Illinois Metropolitan Area, United States
    [job_card.full_time]
    Hiring for : Senior Platform Developer (Data Modeling & Database Architecture).Design and develop conceptual, logical, and physical data models for greenfield initiatives and legacy modernization ef...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    RN - IMC

    RN - IMC

    Lancesoft INC • Springfield, IL, US
    [job_card.full_time]
    Years of experience REQ : Minimum 2 years' experience required.Weekend REQ : Will work every other weekend.Certs REQ : ACLS and BLS required. Will float to like units as needed.Open to accommodatin...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Store Manager

    Store Manager

    GPM Investments LLC • Springfield, IL, US
    [job_card.full_time]
    Lead with Purpose as a Store Manager at One of the Nation’s Top Convenience Chains!.Are you an inspiring leader ready to do more than manage—ready to. Take full ownership of your store&#...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Enterprise Data Warehouse (EDW) Informatica ETL Developer (Springfield)

    Enterprise Data Warehouse (EDW) Informatica ETL Developer (Springfield)

    eAspire Technolabs Inc. • Springfield, IL, United States
    [job_card.full_time]
    Job Title : Enterprise Data Warehouse (EDW) Informatica ETL Developer.Location : Telecommute (with occasional travel to Springfield, IL). Client is seeking a highly experienced Informatica Extract Tra...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    RN IMC

    RN IMC

    Lancesoft INC • Springfield, IL, US
    [job_card.full_time]
    Years of experience REQ : Minimum 2 years' experience required.Certs REQ : ACLS and BLS required.LanceSoft is rated as one of the largest staffing firms in the US by SIA.Our mission is to establi...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Medicaid Data Warehouse Analyst (Subject Matter Expert)

    Medicaid Data Warehouse Analyst (Subject Matter Expert)

    MSR Technology Group • Springfield, IL, US
    [job_card.permanent]
    Medicaid Data Warehouse Analyst (Subject Matter Expert).Remote | Contract (Multi-Year or Permanent Option) | Competitive Pay + Benefits. Join a high-impact initiative supporting a state Medicaid Ent...[show_more]
    [last_updated.last_updated_30] • [promoted]
    SQL Data Analyst - Healthcare Claims

    SQL Data Analyst - Healthcare Claims

    MSR Technology Group • Springfield, IL, US
    [job_card.permanent]
    SQL Data Analyst - Healthcare Claims.Remote | Contract (Multi-Year or Permanent Option) | Competitive Pay + Benefits.This opportunity gives you real impact on Medicaid data solutions that improve h...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr. Medicaid Data Analyst CMS Reporting & Analytics

    Sr. Medicaid Data Analyst CMS Reporting & Analytics

    MSR Technology Group • Springfield, IL, US
    [job_card.full_time]
    Medicaid Data Analyst – CMS Reporting & Analytics.Long-term contract with the possibility of conversion to full-time employment. Remote role with benefits provided.We are seeking a senior-...[show_more]
    [last_updated.last_updated_30] • [promoted]
    DB2 / SQL Analyst - Information Systems Technician I

    DB2 / SQL Analyst - Information Systems Technician I

    Illinois Secretary of State • Springfield, IL, US
    [job_card.full_time]
    Office of the Illinois Secretary of State.Information Systems Technician I – DB2 / SQL Analyst.Union : .S Second St, Springfield, IL – Sangamon County...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Analyst

    Senior Data Analyst

    CSpring • Springfield, IL, US
    [job_card.full_time]
    At CSpring, we believe in the power of data to drive decisions and real-world impact.We’re a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Hiring Oncology / MS RN

    Hiring Oncology / MS RN

    Lancesoft INC • Springfield, IL, US
    [job_card.full_time]
    Job details and responsibilities : .Guaranteed Hours : 4 •12 =48 Hrs.Location : Springfield, IL 62702.Pay rate : W2 Pay Rate RT (Regular Time) W2-$41. LanceSoft is rated as one of the...[show_more]
    [last_updated.last_updated_30] • [promoted]