Job Title: Enterprise Data Warehouse (EDW) Informatica ETL Developer
Location: Telecommute (with occasional travel to Springfield, IL)
Type: C2C / W2
Visa Status: H1B
Job Summary:
Client is seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our 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, particularly within healthcare-related data systems.
Key Responsibilities:
- Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various sources.
- Automate data staging processes and optimize ETL job scheduling.
- 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 various Informatica transformations.
- Monitor and troubleshoot ETL jobs across all environments.
- Write and optimize complex SQL queries and Unix Shell scripts for Teradata data marts.
- Collaborate with stakeholders to define requirements and document technical solutions.
- Participate in unit, integration, and system testing.
- Provide technical support, mentoring, and guidance to team members.
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.
- Bachelors or advanced degree in IT, Computer Science, or a related field.
Preferred Qualifications:
- Residing in or near Springfield, IL.
- 5+ years of data warehouse development and data modeling experience (ERWIN).
- 2+ years of experience with Azure Data Factory and Snowflake.
- Experience with Python, R, or JavaScript (React).
- Familiarity with IDQ, Address Doctor, and Metadata Manager.
- Experience with Medicaid, Medicare, or healthcare data systems.
...Position Summary We are seeking a strategic and creative Social Media + Marketing Manager to lead our digital marketing efforts and elevate... ...manage user-generated content to showcase authentic customer experiences. Collaborate with the Director on seasonal campaign...
...The Business Data Analyst supports the Data Engineering & Business Intelligence team by helping... ...QA checks and validate data at a basic level (record counts, field consistency,... ...any background experience involving data entry, databases, or QA / Test automation....
...Security Professional Opportunity We are looking for Security Professionals to hire for... ...Nevada. Applicants must have a Nevada PILB Guard License to apply. Our objective is to... ...Security field. We have openings for day shift, night shift in both part time and full time...
...ABOUT OF CLIENT Join Our Client as a Senior Network Engineer and lead the design, security, and optimization of enterprise network infrastructure. Bring your expertise in Cisco, SD-WAN, and cloud environments to drive innovation and reliability across global systems....
...development Join Our Team as a 1099 Independent Contractor Van Driver! There is a reason why our contractor's average tenure is... ...Requirements: MINIMUM 2 years of professional courier experience, Airport experience mandatory. Must be 21 years of age or older with...