EDW Informatica ETL Developer
Job in
Springfield, Sangamon County, Illinois, 62777, USA
Listed on 2025-12-30
Listing for:
Datamaxis
Full Time
position Listed on 2025-12-30
Job specializations:
-
IT/Tech
Data Engineer, Data Analyst, Data Warehousing, Database Administrator
Job Description & How to Apply Below
Location
Telecommute (with occasional travel to Springfield, IL, two to three times per year)
Job SummaryWe 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 Power Center 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.
Key Responsibilities- Design and implement ETL solutions using Informatica Power Center 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.
- 7+ years of experience with Informatica Power Center and ETL development.
- 5+ years of experience writing complex SQL and performance tuning.
- 5+ years of experience with Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server).
- 5+ years of Informatica Power Center administration 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.
- 5+ years of data warehouse development experience.
- 5+ years of data modeling experience using ERWIN or similar tools.
- 2+ years of Unix Shell (Bash/Korn) scripting experience.
- 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.
- Residing in or within driving distance of Springfield, IL.
- U.S. Citizen or U.S. Permanent Resident.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×