Myticas Consulting
Overview
Job Title: Enterprise Data Warehouse (EDW) Informatica ETL Developer
Duration: 12 months with possible multi-year extension/s
Location: Springfield, IL
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.
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.