Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)
No Travel Required
Skills
Informatica Power Center
Teradata (V17+)
SQL
Bash/ Korn
ADF
Snowflake
Python
R
Java script/ React
Medicaid
Medicare
IDQ
Job Details
ETL Informatica PowerCenter developer with Medicaid experience
Spring Field, IL (Remote) || Local to Springfield, IL are highly preferred||
6+ Months
6+ Months
Responsibilities:
- Design, develop, and optimize ETL solutions using Informatica PowerCenter.
- Implement automated data staging, integration, and scheduling processes across large datasets.
- Build, test, and maintain mappings, mapplets, workflows, and sessions using advanced Informatica transformations.
- Administer ETL environments (development and production), including backups, recovery, and system tuning.
- Write and optimize complex SQL and Unix Shell scripts to support Teradata-based data marts and reporting layers.
- Participate in solution design, requirements analysis, testing, and documentation activities.
- Collaborate with cross-functional teams and clients to align solutions with business needs and timelines.
- Provide technical guidance and mentorship to junior developers and analysts.
- Keep up with new technologies and recommend improvements to enhance performance and scalability.
Requirements
- 9+ years of experience in ETL development with Informatica PowerCenter
- 5+ years of experience with Teradata (v17+) and tools such as Fastload, TPT, Multiload
- 5+ years of experience in ETL environment administration (PowerCenter)
- 5+ years of writing and tuning complex SQL queries
- 2+ years of Unix Shell scripting (Bash/Korn)
- Strong communication, documentation, and mentoring abilities
- Bachelor s or advanced degree in Computer Science, IT, Mathematics, or related field
- Excellent organizational and time management skills
Preferred Qualifications:
- 5+ years of data warehouse development experience
- 5+ years of data modeling using ERWIN or similar tools
- 2+ years of experience with Azure Data Factory and Snowflake
- Familiarity with scripting languages like Python, R, or JavaScript/React
- Experience with Informatica Data Quality (IDQ), Address Doctor, or Metadata Manager
- Experience working in Agile environments
- Exposure to Medicaid, Medicare, or healthcare data systems and standards
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.