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

Enterprise Data Warehouse (EDW) Informatica ETL Developer

eAspire Technolabs Inc. • Springfield, IL, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.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, United States

    [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]
    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]
    Springfield-Warehouse

    Springfield-Warehouse

    Connor Co. • Springfield, IL, US
    [job_card.full_time]
    Warehouse position in Springfield, IL.We are looking for a career-minded person looking for a long-term career with a great company. Knowledge of HVAC and plumbing is helpful but not required.Availa...[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]
    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

    Enterprise Data Warehouse (EDW) Informatica ETL Developer

    eAspire Technolabs Inc. • Springfield, IL, US
    [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_hours] • [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]
    Physician / Endocrinology / Illinois / Permanent / Endocrinology Physician

    Physician / Endocrinology / Illinois / Permanent / Endocrinology Physician

    The Curare Group, Inc • Springfield, Sangamon County, IL, US
    [job_card.permanent]
    Join a thriving multispecialty care team in O'Fallon, IL, as a BE / BC Endocrinologist! Enjoy a flexible 4- or 5-day schedule, robust compensation ($295K - $352K), and a strong referral network....[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    RN IMC

    RN IMC

    Lancesoft INC • Springfield, IL, US
    [job_card.full_time]
    Experience : Minimum 2 years in IMC, Telemetry, or similar stepdown units.Certifications : BLS and ACLS required.Licensure : Active Illinois RN license required (No pending licenses accepted).LanceSof...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Everie Egg Donor

    Everie Egg Donor

    Everie • Chatham, IL, United States
    [job_card.full_time] +1
    Generous compensation : $9,000-$15,000 for first-time donors, with potential.Comprehensive medical care from top fertility specialists. Support and guidance from the Everie team.As an Everie Egg Dono...[show_more]
    [last_updated.last_updated_variable_days] • [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]