EDW Informatica ETL Developer

Summary

Join our Enterprise Data Warehouse (EDW) team as a highly experienced Informatica Extract Transform Load (ETL) Developer. This role focuses on designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata, supporting healthcare-related data systems. You will need extensive experience with Informatica PowerCenter, SQL, Teradata, and Unix Shell scripting. The position requires strong communication and collaboration skills, along with a Bachelor's or advanced degree in a related field. The ideal candidate will have experience with data warehousing, data modeling, and Agile environments. This is a telecommute position with occasional travel to Springfield, IL.

Requirements

• 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

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

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