EDW Informatica ETL Developer (4 positions)Datamaxis • Springfield, Illinois, United States
No longer accepting applications
EDW Informatica ETL Developer (4 positions)
Datamaxis • Springfield, Illinois, United States
8 days ago
Job type
- Full-time
- Remote
Job descriptionResiding 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 Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and Automate data staging processes and optimize ETL job scheduling for performance and 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 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 Collaborate with stakeholders to define requirements, document technical solutions, and 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
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 :
systems.
Key Responsibilities :
load data from various agency sources.
efficiency.
transformations.
Teradata.
support project planning.
capabilities.
Create a job alert for this search
EDW Informatica ETL Developer 4 positions • Springfield, Illinois, United States
Similar jobs
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
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
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
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
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
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
Office of the Illinois Secretary of State.Union : .S Second St, Springfield, IL – Sangamon County.Salary : .Range $65,000 to $80...Show more
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
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
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
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
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
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
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
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 Join our dynamic team dedicated to revolutionizing healthcare technology.As a key player, you will help design and execute both short-term and long-term strategic initiatives.Your leadership will b...Show more
LPN (Day or Evening) - $3k Sign on and ADN Paid For!
Universal Health Services, Inc. • Springfield, IL, United States
Full-time +1
Last updated: 10 days ago • Promoted
Diesel Fleet Techs III - Earn $35-$42.21 / Hr - $7.5k Sign-On + Benefits
Sysco • Litchfield, IL, US
Full-time
Last updated: 30+ days ago • Promoted
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
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
Earn $50,000–$100,000 as a Surrogate – Must Have Healthy Prior Delivery
Ivy Surrogacy • Spaulding, IL, US
Full-time +1
Last updated: 21 days ago • Promoted
Compensated Surrogacy Opportunity - Make a Life Changing Impact and Earn $60,000+
Newborn Advantage Surrogacy • Sherman, IL, US
Full-time
Last updated: 2 days ago • Promoted
Embedded ROI Processor ll
Datavant • Springfield, IL, United States
Full-time
Last updated: 9 days ago • Promoted
Software Development Snr Director (JoinOCI-Leader)
Oracle • Springfield, IL, United States
Full-time
Last updated: 9 days ago • Promoted
OSHA Training Developer / Administrator (MAIII)
Illinois Secretary of State • Springfield, IL, US
Full-time
Last updated: 30+ days ago • Promoted
Lead Technology Leader
Humana • Springfield, IL, United States
Full-time
Last updated: 5 days ago • Promoted
Physician / Endocrinology / Illinois / Permanent / Endocrinology Physician
The Curare Group, Inc • Springfield, Sangamon County, IL, US
Permanent
Last updated: 30+ days ago • Promoted
Assoc Analyst Technology
Medline Industries - Transportation & Operations • Springfield, IL, US
Full-time
Last updated: 30+ days ago • Promoted
Application Specialist - Greenview, IL
Prairieland FS • Greenview, IL, USA
Full-time
Quick Apply
Last updated: 30+ days ago
Application Developer
TradeJobsWorkForce • 62563 Rochester, IL, US
Full-time
Last updated: 30+ days ago • Promoted
IT Low Code Developer & SQL Analyst
United Community Bank • Auburn, IL, US
Full-time
Last updated: 26 days ago • Promoted
Travel CT Tech - $2361 / Week
LRS Healthcare - Allied • Springfield, IL, US
Full-time
Last updated: 7 days ago • Promoted
Locate Technician - Montgomery County, Illinois
Stake Center Locating • Litchfield, IL, US
Full-time
Last updated: 30+ days ago • Promoted
Senior Software Development Leader
Oracle • Springfield, IL, United States
Full-time
Last updated: 4 days ago • Promoted