EDW Informatica ETL Developer (4 positions)
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.
Recommended Jobs
Facilities Services Manager
About Public Storage Since opening our first self-storage facility in 1972, Public Storage has grown to become the largest owner and operator of self-storage facilities in the world. With thou…
Remote Affiliate
About the Opportunity: We’re helping local families access a 100% FREE community solar program that provides discounted energy credits: no fees, no installation, and no change to their current uti…
Electrical MEP Coordinator
Join a dynamic and collaborative team as a Site MEP Technical Coordinator, where you will play a key role in bridging owner project requirements with onsite activities and commissioning. This positio…
Client Success Associate (Entry level, Remote)
Job Description Job Description OUR HIRING PROCESS: We will review your application against our job requirements. We do not employ machine learning technologies during this phase as we believe…
Senior Software Controls Design Engineer - VMEC
Job Description The Role: The VMEC team develops the embedded controllers and software that power GM’s propulsion, steering, and suspension systems, enabling advanced features such as suspensio…
Principal Analyst, Risk Management - Finance Risk Management, Control Testing
Principal Analyst, Risk Management - Finance Risk Management, Control Testing Capital One is seeking a motivated professional to join the Finance Risk Management (FRM) team as a Principal Analy…
Principal Data and Semantic Architect (Hybrid Work Schedule)
Position at Parts Town Principal Data & Semantic Architect See What We’re All About As the fastest-growing distributor of restaurant equipment, HVAC and residential appliance parts, we like…
Telephone Triage - Onsite (CMA/LPN)
Job Description Job Description Title: Telephone Triage - Onsite (CMA/LPN) Employment Type: Full Time Work Hours: Monday through Friday, 8-hour shift ranging from 7:30AM to 5:05PM City…
Supplier Quality Auditor
Position Overview International has an exciting opportunity for a Supplier Quality Auditor to join our team! The Supplier Quality Auditor conducts supplier audits, according to VDA 6.3, to …
Stock Associate
Why You’ll Love World Market For over 60 years, we have searched the globe for design inspiration, emerging trends, and time-honored handicrafts, to bring you stylish home décor, quality fur…