Myticas Consulting
EDW Informatica ETL Developer (32541)
Myticas Consulting, Chicago, Illinois, United States, 60290
Join to apply for the
EDW Informatica ETL Developer (32541)
role at
Myticas Consulting 1 day ago Be among the first 25 applicants Join to apply for the
EDW Informatica ETL Developer (32541)
role at
Myticas Consulting EDW Informatica ETL Developer
EDW Informatica ETL Developer
Job Title:
Enterprise Data Warehouse (EDW) Informatica ETL Developer
Duration:
12 months with possible multi-year extension/s
Job Summary
Clover Consulting (a Myticas Co.) is are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer for a large, direct client in Springfield, IL. This opportunity will be an assent to the 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.
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.
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. Bachelors or advanced degree in IT, Computer Science, Mathematics, or a related field. Strong organizational and time management skills. 2025 Page 1 of 2 Enterprise Data Warehouse (EDW) ETL/Informatica Developer
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.
, : Michelle Corino
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Contract Job function
Job function
Information Technology Industries
Software Development Referrals increase your chances of interviewing at Myticas Consulting by 2x Get notified about new ETL Developer jobs in
Chicago, IL . Chicago, IL $80,000.00-$130,000.00 9 months ago California, United States $130,000.00-$160,000.00 1 week ago Software Engineer, Data Infrastructure & Acquisition - Chicago, USA
Chicago, IL $140,000.00-$200,000.00 3 weeks ago Chicago, IL $95,000.00-$110,000.00 2 days ago Chicago, IL $80,000.00-$85,000.00 1 month ago Rolling Meadows, IL $77,500.00-$151,000.00 2 weeks ago Python and Kubernetes Software Engineer - Data, AI/ML & Analytics
Staff Engineer - Finance Data Specialist (Remote)
Chicago, IL $115,000.00-$260,000.00 1 week ago Python and Kubernetes Software Engineer - Data, Workflows, AI/ML & Analytics
Staff Engineer - Finance Data Specialist (Remote)
Chicago, IL $115,000.00-$260,000.00 3 weeks ago Senior Staff Software Engineer, Financial Data
Greater Chicago Area $191,000.00-$265,000.00 2 weeks ago Chicago, IL $140,000.00-$180,000.00 1 week ago Data Analytics and Vertical Engineering - Claims Domain Engineer
Chicago, IL $70,000.00-$160,000.00 3 weeks ago Chicago, IL $135,000.00-$150,000.00 5 days ago Senior Business Data Analyst, Member Experience Reporting
Business Data Analyst BI / PBM Rebates (Remote)
Chicago, IL $130,000.00-$170,000.00 1 week ago Senior Staff Software Engineer - Data Acquisition
Maine, United States $169,000.00-$225,000.00 2 weeks ago Data Transformation Analyst (US, remote)
Chicago, IL $60,000.00-$68,000.00 1 day ago Chicago, IL $120,000.00-$130,000.00 2 weeks ago Chicago, IL $90,000.00-$160,000.00 16 hours ago Litigation Data Analyst - Mass Tort & Product Liability
Electrical Commissioning Engineer (Data Centers) Remote
Chicago, IL $90,000.00-$145,000.00 3 days ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
EDW Informatica ETL Developer (32541)
role at
Myticas Consulting 1 day ago Be among the first 25 applicants Join to apply for the
EDW Informatica ETL Developer (32541)
role at
Myticas Consulting EDW Informatica ETL Developer
EDW Informatica ETL Developer
Job Title:
Enterprise Data Warehouse (EDW) Informatica ETL Developer
Duration:
12 months with possible multi-year extension/s
Job Summary
Clover Consulting (a Myticas Co.) is are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer for a large, direct client in Springfield, IL. This opportunity will be an assent to the 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.
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.
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. Bachelors or advanced degree in IT, Computer Science, Mathematics, or a related field. Strong organizational and time management skills. 2025 Page 1 of 2 Enterprise Data Warehouse (EDW) ETL/Informatica Developer
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.
, : Michelle Corino
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Contract Job function
Job function
Information Technology Industries
Software Development Referrals increase your chances of interviewing at Myticas Consulting by 2x Get notified about new ETL Developer jobs in
Chicago, IL . Chicago, IL $80,000.00-$130,000.00 9 months ago California, United States $130,000.00-$160,000.00 1 week ago Software Engineer, Data Infrastructure & Acquisition - Chicago, USA
Chicago, IL $140,000.00-$200,000.00 3 weeks ago Chicago, IL $95,000.00-$110,000.00 2 days ago Chicago, IL $80,000.00-$85,000.00 1 month ago Rolling Meadows, IL $77,500.00-$151,000.00 2 weeks ago Python and Kubernetes Software Engineer - Data, AI/ML & Analytics
Staff Engineer - Finance Data Specialist (Remote)
Chicago, IL $115,000.00-$260,000.00 1 week ago Python and Kubernetes Software Engineer - Data, Workflows, AI/ML & Analytics
Staff Engineer - Finance Data Specialist (Remote)
Chicago, IL $115,000.00-$260,000.00 3 weeks ago Senior Staff Software Engineer, Financial Data
Greater Chicago Area $191,000.00-$265,000.00 2 weeks ago Chicago, IL $140,000.00-$180,000.00 1 week ago Data Analytics and Vertical Engineering - Claims Domain Engineer
Chicago, IL $70,000.00-$160,000.00 3 weeks ago Chicago, IL $135,000.00-$150,000.00 5 days ago Senior Business Data Analyst, Member Experience Reporting
Business Data Analyst BI / PBM Rebates (Remote)
Chicago, IL $130,000.00-$170,000.00 1 week ago Senior Staff Software Engineer - Data Acquisition
Maine, United States $169,000.00-$225,000.00 2 weeks ago Data Transformation Analyst (US, remote)
Chicago, IL $60,000.00-$68,000.00 1 day ago Chicago, IL $120,000.00-$130,000.00 2 weeks ago Chicago, IL $90,000.00-$160,000.00 16 hours ago Litigation Data Analyst - Mass Tort & Product Liability
Electrical Commissioning Engineer (Data Centers) Remote
Chicago, IL $90,000.00-$145,000.00 3 days ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr